Dynamics Community Forum Thread Details

Patch is not working in Forall loop

Hello,

For me for some records below code is not working for some record it works. I am doing simple patch as below but somehow LoopUp or Filter is not fetching record, surprisingly for some record it works but for some it doesnt. I also tried to store same value to hidden label (ex label1.Text)in grid but same issue

ForAll(
Gallery1.AllItems,
Patch(D365Entity1,
First(Filter(D365Entity1, BatchText = ThisRecord.BatchText)),
{Column1: "TestValue", Column2: "test"});
);
or
ForAll(
Gallery1.AllItems,
Patch(D365Entity1,
First(Filter(D365Entity1, BatchText= label1.Text)),
{Column1: "TestValue", Column2: "test"});
);

If i give some hard code value to ThisRecord.BatchText= "B123" then it works.

ForAll(
Gallery1.AllItems,
Patch(D365Entity1,
First(Filter(D365Entity1, BatchText = "B123")),
{Column1: "TestValue", Column2: "test"});
);
can someone help why it is not able ot pick that value?

also i tried to store same value in temporary collection but i can see values of ThisRecord.Batchtext and Label1.Text also but some how patch is not picking up.

Thanks & regards,

Keval
@RezaDorrani, @Pstork1 can you please guide,thanks.
@

Quick Links