Checkbox on BrowseGallery, How to Change field value based on check

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have a checkbox like so in my browsegallery -

I want to change my status field on check.

I have this in my OnCheck property -

Set(statusupdate,"Complete"); SubmitForm(EditForm1);

however nothing is happening. How can I change my status based on check property for each record in my browwsegallery?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Add the Checkbox to the Gallery Template (the first record in the gallery that you edit with the pencil icon). Then bind that Checkbox to the value of ThisItem.statusupdate as the default. You'll need to use an IF statement to set the checked property when the gallery loads and then use a Patch to save it since you are editing a Gallery and not a Form so there is no SubmitForm()

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 thank you.

Which property do you mean as "Checkbox value" is that default or oncheck? -

What I have so far -

OnCheck = Set(gblRecordID, ThisItem.ID)

How should the if statement be setup?

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Use an IF() statement in the Default property of the checkbox to set the value of each item when you load the gallery. If you want to save the value when the checkbox is checked or unchecked Set an appropriate Patch() statement in the OnCheck and OnUncheck properties. the if statement would be something like

if(thisItem.statusupdate.Value = "Complete",true,false)

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

okay just need help with why we are setting default property to this if statement.
what is this doing?

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Trying this for patch
Patch(['Data Source'], ThisItem.Status_two.Value, Status_two.Value = "Complete")

also trying this -

Patch(['Data Source'], ThisItem.Status_two , {Status_two:Complete})

where am I going wrong?

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
I think it should be something more like this

Patch(['Data Source'], ThisItem, {updateStatus: {Value = "Complete"}})

assuming the column name is updatestatus.

Was this reply helpful? Yes No