ForAll, Patch ThisRecord.Title

(0) Share

Report

Posted on by CadeWeiskopf

I’m trying to patch to my SharePoint list within a ForAll function by comparing Title to ThisRecord.Title and I’m not sure why the SharePoint list is not getting patched.

This is my formula:

Set(mapDrawings, Filter(MapTest, Drawing <> Blank()));

ForAll(mapDrawings, Patch(MapTest, LookUp(MapTest, Title = ThisRecord.Title), {Drawing: Blank(), ZoneDrawing: Blank()}); );

Can anyone help me understand what is going on here or how to work around this?

Thank you.

Edit: for extra info, the fields I’m patching are multi line text. The patch function works in other areas of my app when I compare to Title to a string variable or if I put Title = “Title” (doing this works even in the ForAll), the main problem seems to be comparing Title = ThisRecord.Title even though ThisRecord.Title matches the Title.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

BCLS776 8,994 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
The ForAll() function often benefits from having scope better defined using an As operator. Try this and see if it makes a difference:

ForAll(mapDrawings As aRecord, Patch(MapTest, LookUp(MapTest, Title = aRecord.Title), { Drawing: Blank(), ZoneDrawing: Blank() } ) );

Hope that helps,

Bryan
CadeWeiskopf 13 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked, thank you for such a quick reply!