cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frixel
Post Prodigy
Post Prodigy

Filter query will not work

Hi,

 

I try to make a filter query in my flow but is doesn`t work.(i can`t fint an example how do do it😥)

 

1.png

7 REPLIES 7
Pstork1
Dual Super User III
Dual Super User III

Those filter queries are written in OData format, so you are using the wrong syntax.  Here's a good article on Odata queries for SharePoint get Items.  The syntax is the same for Excel.

OData Filter query in SharePoint Get items in Flow (sharepains.com)

and a reference of common OData syntax.

Common Filters for Microsoft Flow: A Reference Chart for Users of all Kinds – Ion All the Things



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hi @Pstork1 

 

Thanks for your fast answer.

But i tryed it on many ways and don`t get it working.

 

What is not good on this?

The name of the colomn that must be filter is "Outcome" 

1.png

 

This is on the site you referd to.

 

2.png

Pstork1
Dual Super User III
Dual Super User III

What kind of column is Outcome in Excel?  For substring to work it needs to be a General Text column I believe.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Yes it is a text colomn.

 

1.png

Pstork1
Dual Super User III
Dual Super User III

Sorry, I did some more testing and the Excel connector doesn't support the substringof() function for OData.  Different connectors provide different levels of support for OData.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

okay, at least thank you for the help.


I can't figure it out either. Read a lot on google but are often all very old messages about previous versions but still nothing can find how it works.

Pstork1
Dual Super User III
Dual Super User III

Excel is the problem.  It does work on some other data sources, like SharePoint.  And Odata does work for Excel, just not substringof().



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,180)