I am creating this flow and it keeps on telling me that it failed due to the query. This is what it looks like.
When I test the flow it keeps giving me these error details. Any clue?
@tbrew
Looks like you have a space between the words Store and Number words.
In Filter Query, you need to use Store_x0020_Number.
Try the following in Filter Query:
Store_x0020_Number eq '<STORE NUMBER FIELD>'
Regards
Krishna Rachakonda
Hey there. So, I think it's the space in "Store Number" that might be throwing things off. Try running the Get Items without the filter to look at the results and see how that field is being presented. Try something like this: "Store_x0020_Number eq 'Dynamic Value'" (without the double quotes) and see what happens.
Keep us posted.
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Hi @tbrew ,
Please refer to the following thread to get the internal name of the list column:
how-to-get-internal-names-of-columns-in-sharepoint-lists
Or you could run the Get items action without configuring Filter Query first, then you could get the internal name of the field from the body of Get items action.
Hope this helps.
Best Regards,
Has your problem been solved? You need to get the internal name first. If the field type is number, you don't need to add single quotes outside the second parameter when configuring Filter Query.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 462 Super User 2025 Season 2
Tomac 456 Moderator
abm abm 243 Most Valuable Professional
