Answered

Patch from a collection with Lookup column using dataverse tables

(0) Share

Report

Posted on by DamoC

Hi All,

I'd apprecaite your assistance using the Patch function and ForAll. I get errors when I try to patch a filtered collection.

The error says NetsuiteDepartment_LU does not exist, but the image below shows the column is in Event_Players table. I have already tried the logical field name cr462_Netsuitedepartment_lu with no luck either. The single patch statement commented out works fine.

Thanks Damian

PatchIssue.pdf

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

DavidZoon 738 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello,

According your screenshot, I noticed :

Event_Players is in black font. So it might not be reconized as a data source in your editor. Have you removed or renamed it ?

Diffrence between note and Note

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

Was this reply helpful? Yes No
DamoC 34 on at

Like (0)

Report
Copy link

Link copied!

Thanks David I'd missed the note syntax error. Unfortuneatley Event_Players the original error still exists though. I'm not sure why Event_Players is not recognized, as when I uncomment the patch updating one record below the Event_Players is highlighted in green as it should be

Was this reply helpful? Yes No
Verified answer

DamoC 34 on at

Like (0)

Report
Copy link

Link copied!

Hello
Resolved correct syntax is:
ForAll(Filtered_Attendees,Patch([@Event_Players],Defaults([@Event_Players]),
{NetsuiteDepartment_LU:Filtered_Attendees[@NetsuiteDepartment_LU],Note:"Test",Event_LU:var_SelectedEvent
}));
Using both FORALL and PATCH require different syntax. Thanks David for the clue "Event_Players is in black font". See for details. https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Patch-Inside-ForAll-not-working/td-p/564206

Was this reply helpful? Yes No