Unanswered

To update a value under a column in a sharepoint list in multiple row against the logged user from power app

(0) Share

Report

Posted on by Jobimb

I want to update the "Reviewed" column in a SharePoint list for all rows where the "Assignee" column matches the logged-in user. The current formula in the 'OnSelect' property of a button in Power Apps only updates the first matching row.

Patch('Checklist Daily-IBOR and RECON',LookUp('Checklist Daily-IBOR and RECON',Assignee.DisplayName=User().FullName),{Reviewed:{Value:"Yes"}})

Can you please suggest a change to the formula so that it updates all the rows where the "Assignee" matches the logged-in user?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Jobimb ,What is the datatype of your column Reviewed? Is it Yes/No type column? If yes then code will be

Patch('Checklist Daily-IBOR and RECON', LookUp('Checklist Daily-IBOR and RECON', Assignee.DisplayName = User().FullName), { Reviewed:true } )

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Jobimb 11 on at

Like (0)

Report
Copy link

Link copied!
Thanks. But this is not updating in all the rows against Assignee column. It only updates the first row only where below condition matches. I need to update the value to all the rows where Assignee.Displayname = User().FullName)
Assignee.DisplayName = User().FullName)

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Jobimb Use this:

ForAll( Filter( 'Checklist Daily-IBOR and RECON', Assignee.DisplayName = User().FullName ) As Var, Patch('Checklist Daily-IBOR and RECON', Var, { Reviewed:true } ) )

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Jobimb 11 on at

Like (0)

Report
Copy link

Link copied!

Nope, it is not working. Some errors

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Jobimb When you say error what is the error message? Could you please share the screenshot because I cant see your screen. The code is pretty straight.

Try this:

ClearCollect(collection,Filter( 'Checklist Daily-IBOR and RECON', Assignee.DisplayName = User().FullName )); ForAll(colleaction, Patch('Checklist Daily-IBOR and RECON', ThisRecord, { Reviewed:true } ) )

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Jobimb 11 on at

Like (0)

Report
Copy link

Link copied!

On the last part, I am getting below error

ClearCollect(collection,Filter(
'Checklist Daily-IBOR and RECON',
Assignee.DisplayName = User().FullName
));
ForAll(collection,
Patch('Checklist Daily-IBOR and RECON',
ThisRecord,
{
Reviewed:{Value:"Yes"}
}
)

Was this reply helpful? Yes No
Damin 63 on at

Like (0)

Report
Copy link

Link copied!

It should be some think like this, you should specify which record in your table that matches to ThisRecord of ForAll Function, something like this :
ForAll(collection,
Patch('Checklist Daily-IBOR and RECON',
ThisRecord,
{
Reviewed:{Value:"Yes"}
}
)

Was this reply helpful? Yes No
Jobimb 11 on at

Like (0)

Report
Copy link

Link copied!

Nope, it is not working. Refer below part where error reflects

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Jobimb Last bracket is missing for ForAll in your code:

ClearCollect(collection,Filter( 'Checklist Daily-IBOR and RECON', Assignee.DisplayName = User().FullName )); ForAll(collection, Patch('Checklist Daily-IBOR and RECON', ThisRecord, { Reviewed:{Value:"Yes"} } ) )

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Jobimb 11 on at

Like (0)

Report
Copy link

Link copied!

Thank you @ANB & @Damin for the solution.

Was this reply helpful? Yes No