web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Fetching items failed....
Power Apps
Unanswered

Fetching items failed. Possible invalid string in filter query

(0) ShareShare
ReportReport
Posted on by 14
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})));
Categories:
I have the same question (0)
  • pawelbakan Profile Picture
    12 on at
    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();

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard