web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Bulk patch failed The ...

Power Apps

Answered

Bulk patch failed The requested operation is invalid. Server Response: Hours failed: The right side of the "Equal" operator must be a constant value

(0) Share

Report

Report

Posted on by dennisb88

603

Hi all,

I've an app build on dataverse where I try to patch multiple records from a collection in to dataverse.

Because I want to update existing records, I use this formula:

ForAll(col_HoursToApprove,Patch(Hours,LookUp(Hours,ThisRecord.HoursId = HoursId),{Approved:"Yes"}))

The collection is a complete copy of the hours table.

When I try this patch, I get the following error:

"The requested operation is invalid. Server Response: Hours failed: The right side of the "Equal" operator must be a constant value"

Categories:

Building Power Apps

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@dennisb88

If you reverse the 2 parts of the equality operation, does that make a difference?

ForAll(col_HoursToApprove, Patch(Hours,LookUp(Hours, HoursId=ThisRecord.HoursId),{Approved:"Yes"}) )
dennisb88 603 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @timl ,

Thank you for your reply.

No that make not any difference.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dennisb88 ,

Maybe you could try:

ForAll( col_HoursToApprove As TableA, Patch( Hours, LookUp(Hours,TableA.HoursId = HoursId), {Approved:"Yes"} ) )

Best Regards,

Bof
dennisb88 603 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thanks, that's works like a charm!

One further question, Why does this method works and the version I try not? It's the same data.

Anyway thank you for your help.
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @dennisb88 ,

ThisItem and ThisRecord are great, but they only make the innermost record available. In nested situations, it is impossible to reference the record in an outer scope.

I think this link will help you a lot:
https://powerapps.microsoft.com/en-us/blog/formulas-thisrecord-as-and-sequence/

Best Regards,

Bof

Join the conversation