How to patch all items in source table based on condition

(0) Share

Report

Posted on by JK-20111451-0

Hello there,

I'm not quite sure if the subject of this topic can be interpreted correctly, but I will try to explain my scenario:

I have a gallery (galMain) displaying distinct user IDs from a SharePoint list (AppAllUsers). I've added a button to every gallery record, and now I want to achieve the following. When I click the button, it will read the user ID of the selected item (ThisItem) and patch every row in AppAllUsers where userID = ThisItem.userID. It should write a text string "Action01" to the column ActionID within the same SharePoint list.

I've tried to achieve this with a combination of ForAll, LookUp, and Patch functions, but I haven't succeeded. I can provide you with my formula, but I'm not sure if my approach is correct in the first place.

Many thanks for your suggestions and help.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

vkondreddygari 88 on at

Like
a
(1)

Report
Copy link

Link copied!

You can try something like this-

Patch( AppAllUsers, LookUp( AppAllUsers, userID = ThisItem.userID; ), { ActionID :"Action01"; } )
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
HI @janklaska,

Please set the OnSelect property of the button as:

UpdateIf(AppAllUsers,userID =Gallery7.Selected.userID ,{ActionID: "Action01" })
JK-20111451-0 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello both,
thank you very much for your suggestions. Both formulas work fine for me, but I selected @v-qiaqi-msft's reply as a solution to my problem, because I'm receiving a non-delegable warning with @vkondreddygari's LookUp formula. 🙂