Patch another list in SharePoint, based on the records from the Gallery

(0) Share

Report

Posted on by Kumar9024021

195

Hi All,

I have 2 sharepoint lists masterlist and employeelist. Request ID exists in both tables where Request ID is a foreign key in employee list.

I have a search box which searches across the masterlist and display the result in Gallery. I have a revoke button in gallery, which should update the status of all employees to Revoked in childlist for that particular requestID

I tried to update the Status field to Revoked in EmployeeList, however couldn't because Gallery is populated with masterlist. Any idea how to proceed ?

Patch(EmployeeList, ThisItem.RequestID=MasterList.RequestID,{Status:Revoke}); // doesn't work

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
use the patch as below:
Patch(EmployeeList, Lookup(EmployeeList,RequestID = ThisItem.RequestID),{Status:Revoke});

I hope this resolved your issue if you see any challenge let me know I am always happy to help.
Regards,
Krishna
If this post helps, then please consider Accept it as the solution and give thumbs-up to help the other members find it more.
Kumar9024021 195 on at

Like
a
(0)

Report
Copy link

Link copied!
@KrishnaV

This only updates 1 record in child, if ID are similar. I want to update multiple childs, with same ID in child table, For eg: With ID 1, there are 3 childs.
The below syntax shows Invalid argument type warning, as ID field in parent table is default ID field from SharePoint and RequestID in child is lookup
Patch(EmployeeList, Lookup(EmployeeList,RequestID = ThisItem.RequestID),{Status:Revoke});

Parent table

Child Table
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kumar9024021 ,

If the Status is choices type column, please try this to RevokeButton.OnSelect:

UpdateIf(EmployeeList, RequestID.ID=ThisItem.ID,{Status:{Value:"Revoke"}})

If the status is single line of text column, please try this.

UpdateIf(EmployeeList, RequestID.ID=ThisItem.ID,{Status:"Revoke"})

Hope this helps.

Sik