Patch Function - Invalid Query String in LookUp

(0) Share

Report

Posted on by bspang

My formulas in the screen's OnVisible property look like this:

ClearCollect(myCollection, Filter(mySharePointList, mySharePointColumn = variable));

ForAll(myCollection, Patch(mySharePointList, LookUp(mySharePointList, ID = ThisRecord.ID), {OTHER_COLUMN: otherVariable}));

But when I navigate to that screen, I get the following error:

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

Status code is 400.

I had to set it up this way because it won't allow patching to the same data source that is in the ForAll. Is it not possible to use a collection as the first argument in a ForAll loop?

Categories:

Building Power Apps

I have the same question (1)

All responses (4)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi
Yes you can use a collection in ForAll

When is variable set? And when is ThisRecord (gallery selected or edit form etc)??

My concern is that these aren't set yet so it fails.

I would recommend using Monitor to catch the errors and get the extended information.
Step 1. Close your App (stop it running)
Step 2. Click the Stethoscope in the Top Right
Step 3. On the bottom click Open Monitor
Step 4. Once Monitor is running go back and run your app
Step 5. Cause your issue to happen
Step 6. Close the app
Step 7. Go to the Monitor and Filter (top right) based on Error, or key word. Find the error line and look at the information Monitor has for why it failed.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
bspang 21 on at

Like (0)

Report

Unfortunately, that error message was gathered in a monitoring session. That was all the detail that was given from that.

Was this reply helpful? Yes No
Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Were you able to pull the actual query string though in the Request Tab of Monitor for that Error?

So that you can validate the parameters in it to see which one might be wrong?

Was this reply helpful? Yes No
TB-12030945-0 2 on at

Like (1)

Report

I was also more than desperate with this error message. Even though the question was asked a long time ago, here is my solution:

WIthin ForAll replace all 'ThisRecord.XYZ' by 'collection[@XYZ]

Example:

ForAll(myCollection, Patch(mySharePointList, LookUp(mySharePointList, ID = myCollection[@ID]), {OTHER_COLUMN: otherVariable}));

2 people found this reply helpful.

Was this reply helpful? Yes No