Answered

Patching Collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi there,

I have a Sharepoint list of student names entitled 'Student Lockdown Register'. In the event of an emergency, you can filter the students by name etc. and add them to a new list ready to be bulk updated in Sharepoint. This is displayed in a Gallery so you know what students you've already selected, there are no duplicates.

The new list is a Collection entitled NewTable. It stores everything under the same name (e.g FullName as FullName) however I have tried using different column names that are different.

On select of a button, I want to update the students in the NewTable with the words "Accounted For" under the column Register.

I just cannot seem to do it. I've tried Patch, For All, UpdateIf etc and nothing seems to work. As a beginner, I'd appreciate some guidance if anyone can help!

I've tried:

ForAll(NewTable,Patch('Student Lockdown Register',LookUp('Student Lockdown Register',ID=NewTable[@ID],{Register:"Accounted For"})))

Among others that I've lost count of!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Can you try to update the expression as:

UpdateIf(TestTable,true, {Register:"Accounted For"})

Note: If you are collecting data in a collection, this will remain until the current session only or if the collection is refreshed anywhere in the app.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

Sorry, I don'y think I made myself clear, but thank you for your response!

I need to patch the collection (entitled NewTable) back to Sharepoint, just with Register (which is currently blank) to now read 'Accounted For' however I could update it to read 'Accounted For' in the Collection if that helps.

With the answer you wrote, how does it know to patch back to the Sharepoint list?

Thanks
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

To update the results to Sharepoint, you may need to update the expression as:

ForAll(RenameColumns(TestTable,"ID","ID1"), Patch('Student Lockdown Register',LookUp('Student Lockdown Register',ID = ID1),{Register:"Accounted For"}))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You're fantastic! I spent far too long trying to figure that one out!