Unanswered

Patch gallery update

Like (2) Share

Report

Posted on 23 Jul 2024 08:26:57 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:

Using Apps Using Formulas

All responses (5)

Answers (0)

NWEASD 174 on 03 Feb 2025 at 17:00:28

Like (0)

Report

Patch gallery update

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})

)
Cosan 73 on 29 Jul 2024 at 15:56:39

Like (1)

Report

Patch gallery update

The dropdown is

When I put the patch in for the submit button ThisItem is not an option
Cosan 73 on 25 Jul 2024 at 08:01:26

Like (1)

Report

Patch gallery update

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
jagdeepdua Microsoft Employee on 23 Jul 2024 at 17:38:31

Like (1)

Report
Patch gallery update

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...
KeithAtherton 3,676 Most Valuable Professional on 23 Jul 2024 at 16:55:42

Like (2)

Report
Patch gallery update

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