Hi @momureithi ,
Could you tell me which data source the gallery is connected to? A collection or other data sources?
For patching data to a SharePoint list, assume that:
1. Your Gallery is to display a collection, and the collection is reading data from your SP list.
2. You want to update the collection, and write the data back to your SP list.
You can refer to below formula as an example:
ForAll(
RenameColumns(Gallery1.AllItems,"ID","ID1"), /* Use RenameColumns() for disambiguation, you can also rename other columns here */
/* you can add an if()formula outside Patch() to filter some records to edit*/
Patch(
'SPList',
LookUp('SPList',ID=ID1), /* <-- Use the previously renamed column to find specific record */
{
ListColumnOne:GalleryFieldOne,
ListColumnTwo:GalleryFieldTwo,
...,
ListColumnN:GalleryFieldN
}
)
)
Note:
- When using ForAll with patch, you compare the NewId column, against the Id column in your source data. The disambiguation operator is used when two columns belonging to different tables have the same name. If you don’t use this disambiguation operator you will observe that only the first record gets updated always.
- Beside, you also need to make sure that the columnnames are an exact match to the columns in your SharePoint list.
More details from following article:
Reference link
If above formula still cannot solve your issue, please provide more information or screenshots. So that I can have a test in my environment.
Best Regards,
Allen
