Patch formula help Oncheck of Checkbox

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I am trying to update my status based on the check of a checkbox.

I want to update each record in my browsegallery every time i check the box. I want to switch the status to Complete.

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

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

assuming status two is a choice column

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

Like (0)

Report

@TheRobRush

getting error specified column "ID" does not exist.

but i do have it in my SP list -

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
Weird, maybe just try this way then

Patch('Data Source', ThisItem, {Status_two: {Value:"Complete"}})

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

Like (0)

Report

@TheRobRush now im getting column Status_two doesnt exist!

but it does!

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

what is the gallery items code

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

Like (0)

Report
@TheRobRush

BrowseGallery1 Items code -

SortByColumns( Filter( [@'Data Source'], If( Dropdown3.Selected.Value = "Filter for Request Status", Status_two.Value = "New Request" Or Status_two.Value = "GCO Assessment" Or Status_two.Value = "Complete", Status_two.Value = Dropdown3.Selected.Value ) And If( Filter_for_GCO_Lead.Selected.Value = "Filter for GCO Lead", 'GCO Lead_three' = "email@gmail.com" Or 'GCO Lead_three' = "email2@gmail.com", 'GCO Lead_three' = Filter_for_GCO_Lead.Selected.Value ) And (StartsWith( Control_two.Value, 'search box'.Text ) Or StartsWith( ID_three, 'search box'.Text )) ), "Title", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

go to your sharepoint list, in upper right click the gear symbol and click list settings, then on next screen click the name of column 'Status_two' then look in address bar to make sure column name is ACTUALLY status_two, sometimes they ar enot

see image

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

Like (0)

Report

@TheRobRush looks okay here !

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
just to see if it changes, place a gallery in the app with just the bare sharepoint list as the source (none of the filters sorts etc) and just place a button in there that does

Patch('Data Source', ThisItem, {Status_two: {Value:"Complete"}})

and see if it gives you same issue, maybe narrow down whats happening

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

Like (0)

Report

Yup so when I do a vertical gallery, add a button, on select add what you have above, the status changes and is doing the correct action lol. sigh this is so confusing.

Was this reply helpful? Yes No