I've been looking at some other posts but they sort of confuse me, I have a list of users who we do firedrills for and once that drill is finished I just want to reset the status of all people back to "Not Reported"
Seems to be suggestions to use a gallery and use the ForAll to loop through but do I have to ensure that all SharePoint list columns are in this statement, I just want to patch the one column (which is a dropdown as shown in the code).
ForAll(AllUserGallery.AllItems,Patch(UserList,Defaults(UserList),{Title:AllUserGallery.Selected.Area,Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:4,Value:"Not Reported"}}))
Solved! Go to Solution.
Hi @Andrew260z1
Depending on the source list of users that you want to update, I would investigate the use of the UpdateIf function.
This would enable you to update a single a single column in multiple rows.
https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-update-updateif
Hi @Andrew260z1
Depending on the source list of users that you want to update, I would investigate the use of the UpdateIf function.
This would enable you to update a single a single column in multiple rows.
https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-update-updateif
thanks for that I knew I was going about it the wrong way.
what worked for me
UpdateIf(UserList,!(Status.Value="Not Reported"),{Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:4,Value:"Not Reported"}})
User | Count |
---|---|
203 | |
92 | |
83 | |
47 | |
42 |
User | Count |
---|---|
252 | |
105 | |
103 | |
62 | |
57 |