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

Categories:

Microsoft Dataverse

PatchIssue.pdf

All responses (3)

Answers (1)

Verified answer

DamoC 34 on at

Like (0)

Report

Re: Patch from a collection with Lookup column using dataverse tables

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
DamoC 34 on at

Like (0)

Report

Re: Patch from a collection with Lookup column using dataverse tables

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
DavidZoon 738 Most Valuable Professional on at

Like (0)

Report
Re: Patch from a collection with Lookup column using dataverse tables

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.