Unanswered

Gallery Patch function copying same data from last row to sharepoint

(0) Share

Report

Posted on by NP-18101421-0

237

I have been trying to patch my repeating table (gallery with multiple rows) to my SharePoint list, however it keeps copying the data from the last row to all of the added rows. See code for submit button, add event button, and the results of the patch button.

Additionally, the two collections in the app are blank when clicking the patch button. It only shows one column populated.

Help on this will be greatly appreciated!

Add event button:

Submit Button:

Gallery:

ColSelectedMeals:

ColMealDetails:

SharePoint List after Submit button (patch)

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @NPatel12498 ,

Try inserting ThisRecord. before each field value in the Patch function. Like that you are referring to the current record in the ForAll loop instead of the controls in the gallery (where automatically the values of the last item are used). For instance:

Title: ThisRecord.TitleID.Text

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report

This causes errors:

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
HI @NPatel12498 ,

How are the values in the gallery saved to the collection? Having had a better look at your screenshots, it seems you're trying to patch an empty collection to the data source: there's nothing in colMealDetails.

If you haven't done so already, set the OnChange property of the input controls in the gallery to something like the below:

Patch( ColMealDetails, ThisItem, { TitleID: ThisItem.TitleID.Text, EventDate: Text(ThisItem.Evendate.SelectedDate), RequiredMeals: Concat(ThisItem.ComboBox.SelectedItems, Value, ", "), EventDuration: ThisItem.EventDuration.Text, ***Attendees: ThisItem.***Attendees.Text, Non***Attendees: ThisItem.Non***Attendees.Text } )

This should properly populate the collection.

To then submit the collection to the DataSource, you can leave out the .Text, i.e.:

TitleID: ThisRecord.TitleID, EventDate: ThisRecord.EventDate, etc. etc.

The above works on the assumption that all columns are text types. In case you have other types as well, please share which columns have which types.

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report

The event date is a date type and the required meals is a multi select choice column

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @NPatel12498 ,

In that case the below is worth trying to set as the OnCHange property of the input controls in the gallery:

Patch( ColMealDetails, ThisItem, { TitleID: ThisItem.TitleID.Text, EventDate: ThisItem.Evendate.SelectedDate, RequiredMeals: ThisItem.ComboBox.SelectedItems, EventDuration: ThisItem.EventDuration.Text, ***Attendees: ThisItem.***Attendees.Text, Non***Attendees: ThisItem.Non***Attendees.Text } )

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report

HI there are still errors with this code

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

HI @NPatel12498 ,

What errors are you receiving?

You do have to make some modifications to the formula because some identifiers of controls were not given or stricken:

ComboBox: the control where you select the meals

1st ***Attendees: Column name

2nd ***Attendees: the control where the number of ***Attendees is given

1st Non***Attendees: Column name

2nd Non***Attendees: the control where the number of Non***Attendees is given

Also please correct any typing mistakes: I'm doing this in a notepad, so nothing to correct any mistakes.

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report

Hi,

I have adjusted the formula with the correct column names but it is still giving me errors.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @NPatel12498 ,

Can you share the formula please?

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Patch( ColMealDetails, ThisItem, { TitleID: ThisItem.TitleID, EventDate: ThisItem.Evendate, RequiredMeals: ThisItem.RequiredMeals, EventDuration: ThisItem.EventDuration, ****Attendees: ThisItem.****Attendees, Non****Attendees: ThisItem.Non****Attendees } )

The code has less errors after I take out the .text, .selecteddate out of the formula. But this is what I have currently and it is still throwing errors. Disregard the **** that is just data protection on my end.

Was this reply helpful? Yes No