power apps, checkbox in a gallery. when checked it will update excel cell table with a date & time

(0) Share

Report

Posted on by Jeffrey_H

118

Hello,

I've setup an Excel table that I display in a gallery.

The gallery has been filtered.

This gallery also has a checkbox in each item.

When Checkbox is "checked" I would like it to update an excel table cell (yes/no), cell default is blank, no data)

When checkbox was checked in gallery item, this will generate a (true or false) or (Yes or No) to the excel table.

I would also like to change the checkbox label to change text label from "Check this box when Card is completed" to "Card Completed"

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Jeffrey_H,

Do you want to update a yes/no column in Excel table based on the Checkbox in Gallery?

Actually, how to write the patch formula depemds on the column type of this yes/no column in Excel table, I will assume it is a GENERAL type in excel table.

If you already have had a General column to save the checkbox value, please try to set the following formula.

1). Set the OnCheck property of the Checkbox to:

Patch(Table1, ThisItem, {'Yes/No_Column':If(Self.Value,"Yes","No")})

2). Set the Text property of the Checkbox to:

If(Self.Value,"Card Completed","Check this box when Card is completed")

Was this reply helpful? Yes No
Jeffrey_H 118 on at

Like (0)

Report
Copy link

Link copied!

This worked with the exception, when the data is updated in the spreadsheet, it changes the Checkbox back to unchecked, even through the data has changed in the spreadsheet. How can I keep it from changing back, so it indicates that this is completed?

Was this reply helpful? Yes No
Jeffrey_H 118 on at

Like (0)

Report
Copy link

Link copied!

Hello Qi,
Because some of the limitations of using Excel as my data source, I have migrated to a sharepoint list.
Now my formula for the checkbox is not working correctly.
Do you have an idea on what I need to do to fix this?

The Checkbox is inside a gallery.

Currently:
OnCheck = Patch('ThankYouCardList', ThisItem, {Card_Completed:If(Self.Value,"Yes","No")})
Default =
OnSelect = Select(Parent)
OnUnCheck = false
Text = Patch('ThankYouCardList', ThisItem, {Card_Completed:If(Self.Value,"Yes","No")})

To recap from previous question.
This is data is in Microsoft List
Before switching the data from Excel to a List the Checkbox did update the data in Excel, but now is not in the list.
Also the Checkbox still reverts back to blank after a few seconds. Now when the app is run by the next person or reopened by the same person, the Checkbox should be blank(new person using app) also if a returning person using the proper ID can look at their data showing that the checkbox's that were checked previously are still checked. Now this ID may have multiple thank you cards to create, but do not have to be completed all at once. That is why I would like the option to indicate completed check marks.

Also this will confirm that the data source has been updated too.

Was this reply helpful? Yes No