Power Automate - How To Filter Excel Rows Using String Value

How to filter Excel rows using string value in Microsoft Power Automate.

My Power Automate Profile

Power Automate Community

Twitter

[ion]

Excellent! I wish u continue teaching in the future.

[andresj]

Hello, thank you very much for the video. How can I return the output of the compose so that it is stored in a variable or elsewhere.

[pokxguy]

hi, how do you handle SPACE in the column header (ex. First Name). I tried First_Name or 'Frist Name' neither works.

[vaishaliverma]

Thank you for the video. My columns are dates, I am getting current date in currdate variable using compose. Now I want to use it in filter query with currdate eq 'value', but this is throwing error. Any help you can provide?

[steve_account]

How do I take this output from the compose and put that data into a brand new spreadsheet?

[gladysaguilera]

hi how to compare two columns at the same time ? I am having trouble with that thank you

[ravitejaayyagari]

Hi can you please create list rows present in table dynamically select file and table value finally upload into SharePoint list in that Excel values.

[kayne]

How do you filter by desired columns that contain spaces using “List Rows Present In Table” based on dynamic excel file

[omarmetwally]

I'm copying existing table ro new file then I'm filtering but the old table has a hidden column, so I get this error "Unable to match columns in the filtered view. Filtered columns count: 7, actual columns count: 10. To use ordering or filtering, please try to make all the columns visible." Any solution? thank you

[gouthamkarakavalasa]

Hi I am not able to combine two queries with and operator. Its throwing error .
(Email_ID eq 'David Smith')
and (Dept_name eq 'Sales')

[dianamgdata]

Hello! What if I want to filter by an array of values found in another excel table?

[shubhamaggarwal]

Hi can we use contains instead of equal

[priyal_]

What if I have a csv file how to do these steps in that case

[lakshayjain]

Hii great video
How can I send the rows which I have extracted through an email ?
I tried but wasn't able to do so.
We cannot access the Compose output outside the for each loop so how can we achieve it ?

[mindvoiceu]

When u can do filter straight in excel itslef for HR in one step, what power automate advantage for doing this i. 4 steps? How it is applied and its Avantage is mossing this video in real world application.

[sqhvkpv]

how to get output to power virtual agents

[twilightcloudcoderz-tcc]

To find two excel data similar value is there any way