Fetching items failed. Possible invalid string in filter query

(0) Share

Report

Posted on by asmith36

I'm very new to PowerApps and am working on my first app - a Purchase Order Request that links to Sharepoint and includes a gallery so the end user can add multiple bids.

Everything is working in the app and it writes to my Sharepoint list, but when I try to view submitted requests, I get this error: Error when trying to retrieve data from the network: Fetching items failed. Possible invalid string in filter query.

Based on some google searches, there is an issue in my ForAll Statement. Can anyone help?

ForAll(Gallery2.AllItems, If(Value(inputItemPrice.Text) <> 0, Patch([@'Purchase Requests Required Bids'], {NewVendor_x003f_:inputNewVendor.Selected.Value, VendorName:inputVendorName.Text, ItemPrice:Value(inputItemPrice.Text), CertifiedMinorityWomenBusinessEn:inputMinWomen.Selected.Value, ChildID:SharePointForm1.LastSubmit.ID})));

I have the same question (0)

All responses (1)

Answers (0)

pawelbakan 12 on at

Like (0)

Report

Fetching items failed. Possible invalid string in filter query

If your ForAll patch function does changes to your Sharepoint List then error is somewhere else. Can you share your gallery Items parameter code?

It would be helpful if you would share more informations. This error can show up after your Patch function because it refresh your connection to Sharepoint List.

You can try to change your data management by adding this code in App => OnStart: Set(varSharepointItems, YourSharepointListConnector). Then you replace YourSharepointListConnector in gallery => Items parameter with varSharepointItems. Finally, add Set(varSharepointItems;YourSharepointListConnector) at the end of your ForAll function:

ForAll();

Set();

Was this reply helpful? Yes No