Multiple filter excel query

(0) Share

Report

Posted on by Thinzar

I would like to add 2 conditions in the filter query for the same excel table.

Is there any alternate methods to check conditions for filter query in the same excel table at the same time?

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (1)

v-yueyun-msft on at

Like (0)

Report
Hi , @Thinzar
Can you show your error code in your action?
Also , you can try to check if you use the correct column Name in filter query. And try to use this code:
(Preferences eq 'Weekly Wednesday Evening') and (PreferredContentTypes eq 'Text')

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Thinzar

You could use filter array action to perform the filter operation with multiple conditions.

Here is an example:

Filter query used in the above screenshot:

@and(equals(item()?['From'], '1'),equals(item()?['To'], 'r'))

Here, From & To are the columns in excel sheet.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Thanks

Was this reply helpful? Yes No
Thinzar on at

Like (0)

Report

The error status is Bad Request and I have changed and checked the column and used the script you provided.
It still fails when I test it.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (1)

Report
Hi , @Thinzar
I test it in my side , it seems that we can not use the multiple conditions in the "list rows in a present table" action.Sorry for i may confused by the "Get items" action...😅
You can use the @ManishSolanki method to use filter array after List row present in a table and use multiple conditions:

@and( equals(item()?['Preferences '], 'Weekly Wednesday Evening') , equals(item()?['PreferredContentTypes '], 'Text') )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Thinzar on at

Like (0)

Report

Hello, I have also tried with Filter Array provided by @ManishSolanki . I would like to send emails filtered by the above columns. However, after filtering the array, I cannot get the filtered items in order to send the email. What should I do?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Hi , @Thinzar
You can try to directly use the expression:
body('Filter_array')

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Thinzar on at

Like (0)

Report

Thanks for your help @v-yueyun-msft
However, my problem has not been solved completely.
Could you please have a look into it?

I would like to use separate filtered columns from the excel separately in sending email as dynamic contents.
I am stuck in this stage. I cannot use body from filtered array in "Apply to each" input. It says invalid template.

I would like to set variable with each email and send contents to that filtered email.

Sorry for my bad explanation. The main purpose is that I want to use each filtered data like this in below screenshot.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Hi , @Thinzar
According to your error code , it seems you use the body/value , can you try to directly use this code in your apply to each loop:
body('Filter_array')

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Thinzar on at

Like (0)

Report

Thank you for your help.
I have fixed the expression in "Apply to each"
However, when I test the flow, this error occurs.
I want to send email to those two filtered emails.
How can I correct this error?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (1)

Report

Hi， @Thinzar
Can you show your send Email V2 error code in your flow? And how dose your put in your send Email V2 action?
And can you show your Append to string variable action configuration?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No