cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tony_Feole
Helper I
Helper I

Filter Excel file based on Email address from Compose

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:

 

image.png

 

Here is my flow:

 

image.png

 

Not sure if this is best practice so any suggestions or comments are welcome.

Thank you
Tony

1 ACCEPTED SOLUTION

Accepted Solutions

8 REPLIES 8
Hardesh15
Super User
Super User

@Tony_Feole 

 

Please give try to this post solution.

https://powerusers.microsoft.com/t5/Building-Flows/Filter-Excel-File-s-Rows-and-Send-Email-Based-on-...

 

Let me know if you face any issue.

 

Thanks

Hardesh

Hardesh15
Super User
Super User

@Tony_Feole 

 

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'

 

Thanks

Hardesh

Hi Hardesh - thank you for the response.  Still struggling with the correct syntax to use on Filter Query.

 

image.png

 

Here is the syntax that I used:

image.png

 

Thanks again,

Tony

@Tony_Feole 

 

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.

 

Thanks

Hardesh

Here is the error I am now receiving using lowercase 'eq'

 

image.png

 

image.png

 

@Tony_Feole 

 

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.

 

Thanks

Hardesh

Thank you Hardesh.

 

-Tony

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,279)