Error: Fetching items failed

(0) Share

Report

Posted on by isogunro1

195

I get the following error for the below:

"Error when trying to retrieve data from the network: Fetching items failed. Possible invalid string in filter query"

ClearCollect(colQuadActionsPrice, 'Quad-Actions-Price');

ClearCollect(finalColQuadActionsPrice, Filter(colQuadActionsPrice, parentID.Id =varNewListItem.ID));

ForAll(
finalColQuadActionsPrice,
Patch('Quad-Actions-Price', LookUp('Quad-Actions-Price', ID = ThisRecord.ID),{QuadStatus: {Value: "Active"}} //<-- Points to the LookUp() as the problem
))

But this works

Patch('Quad-Actions-Price', LookUp('Quad-Actions-Price', ID = 38),{QuadStatus: {Value: "Active"}});

Any idea what the problem is?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

isogunro1 195 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked for me

ForAll(
finalColQuadActionsCost,
Patch('Quad-Actions-Cost', Patch('Quad-Actions-Cost', ThisRecord,{QuadStatus: {Value: "Active"}}
)))
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @isogunro1,

Thanks for your sharing.