Hello - I am a new userto Power Automate and could use some assistance.
In my flow i have an e-mail address that I would like to use to filter an Excel file based on value from Compose
When I try to using Filter Query "string(outputs('Compose'))" I get the following message:
Here is my flow:
Not sure if this is best practice so any suggestions or comments are welcome.
Solved! Go to Solution.
Please give try to this post solution.
Let me know if you face any issue.
Your filter query expression is wrong. Filter query is based on following expression.
Column internal name eq 'value'.
Suppose your column name is Email then
Email eq 'value'
Hi Hardesh - thank you for the response. Still struggling with the correct syntax to use on Filter Query.
Here is the syntax that I used:
You missed single quotes. Please see my query i wrapped value inside single quote which is very important. Put single quote around compose output.
I am not sue caps EQ will work or not. Try with small eq.
Why you use dynamic content in left side of eq. I told you in previous post it should be internal columnn name. If you are struggling with this. Please use one condition action and which you are doing in query use in condition action. User email equal to compose output.
About this kind of Filter query I am trying to ose other filter different from 'eq'
I tryed to do a filter with contains, startswith... and the filter doesn't work.
The output it is any row obtained. Any solution?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
The Super User program for 2022- Season 2 has kicked off!