Unanswered

Patch gallery update

(2) Share

Report

Posted on by Cosan

Hi. I'm creating a canvas app. It has a gallery connected to SP List. one of the fields in the gallery I've made a dropdown for the user to update the status. But I don't know how to submit the change back to the list to only update that item and not create a new line. This is what I have now. I know its wrong, but I don't know what it should be.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

KeithAtherton 3,705 Most Valuable Professional on at

Like (2)

Report
Hey. To update a record, change the Patch() function call to reference the record which needs to be updated, like this:

Patch(POAP, Gallery4.Selected, {'POAP provider':drp_response.Selected.Value});

More info on the Patch() function: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch

Was this reply helpful? Yes No
jagdeepdua Microsoft Employee on at

Like (1)

Report
Hi. The response from Keith is absolutely spot on, but if I can offer a very very slightly modified version of it? Instead of using Gallery4.Selected to identify the record you want to patch. I prefer to use ThisItem instead. ThisItem represents the current record in the gallery row, so by clicking on your drop down, you will ThisItem will be the row where your drop down is. The code would look like this :
Patch(POAP, ThisItem, {'POAP provider':drp_response.Selected.Value});

two ways to do exactly the same job...

Was this reply helpful? Yes No
Cosan 82 on at

Like (1)

Report

Thanks, but neither of those answers worked. ThisItem wasn't an option, but I typed it in anyway.

I'm wondering if I did something wrong in the gallery

Was this reply helpful? Yes No
Cosan 82 on at

Like (1)

Report

The dropdown is

When I put the patch in for the submit button ThisItem is not an option

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

If you are trying to do this with a button outside of the gallery, you can do something like this.

ForAll(

RenameColumns(Gallery4.AllItems, ID, TempID),

Patch(POAP, Lookup(POAP, ID = TempID), {'POAP provider':drp_response.selected.value})

)

Was this reply helpful? Yes No