Answered

update multiple records from a gallery to a SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I currently have a Sharepoint list titled "test" that is connected as the datasource for a gallery in my PowerApp. Within my gallery, I have the name on the left, with an empty text_input (titled reason) next to it that it empty for all the records (this corresponds with a column titled reason in the SharePoint). I want to the user to be able to go in and change the reason for any/all of these gallery items, and have a button patch over this column to update the records. So in short, is there any way for me to update a single column of these selected records?

The code I am currently using is:

Patch('test', Gallery2.Selected,{Reason:Reasoning.Text})

This issue with this is that it is only updating the selected value in the gallery, but I am not able to have all values in the Gallery update simultaneously. Any help would be very beneficial.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

That being said, I am able to have a button in every record for the gallery, but I would like the user to have a single button to select, which can update all of the records at once.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to update all items in the gallery to its data source?

If you do, you could use the ForAll and Patch functions, but for the reason that it is necessary to find the proper record to update you will need to add a Lable in the gallery items to hold the ID of the record. Below is a demonstration:

And the formula is:
ForAll(Gallery.AllItems,Patch(DataSource,LookUp(DataSource,ID = Value(IDLabel.Text)), {Reason:ReasonInput.Text}))
You could set the Visible of IDLabel to false to hide them in the gallery.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
lai_lai 41 on at

Like (0)

Report
Copy link

Link copied!
Cool! This article is helping me thinking about other situation:

I've 2 different data bases, and want to copy some data from the excel data base to a Sharepoint list.
In bouth sheets I have the record about a same grup of people, but in excel sheet I've a few more colunms.

I want to copy the data from this colums to the Sharepoint, comparing the people with an ID.
Looking your code, I though something like this:

ForAll(Gal_Excel.AllItems; Patch( ShareopointList; LookUp( SharepointList;ID = Value(LabelWithIDinGal_Excel.Text) ); { ColumA:LabelFromGal_ExcelColumA.Text } ) )

But is not working and doesn't present any error..

I'm also worried about the different types of colums. In this case I'm using a Text Type, but I will use other types too.. Can you help me too, please?

I want to do this:

Was this reply helpful? Yes No