Answered

Filter list by certain values from 2 columns

(0) Share

Report

Posted on by CU30122237-0

I have a "Risk" List. I am trying to build a flow so if 1 column "Status" eq 'Open' and "Handling" is 'Mitigate, read a certain date column, determine if date is 30 days from today, if so, send HTML table of items in email. I have done this successfully after hours of working and wiped my flow but it was only reading "Risk Status". I am unable to figure out how to make sure both columns are meeting the criteria before reading the date column. Just a point in the right direction, any advice, videos, etc would be greatly appreciated.

Update: Pictures

The flow s

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU30122237-0

Could you share screenshot of your flow - need to see how you have design it so that to understand where changes can made in your flow to work as expected.

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!
CU30122237-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nived_Nambiar I have included the picture. I have to not be understanding. I assume with the first Filter query I am limiting the list items to those only with Status eq 'Open'. The condition to limit those items to only Handling eq 'Mitigate'. I am pretty new to this and this is the first time I am attempting to use 2 columns to narrow items. Thank you for your time.
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CU30122237-0

There is no need to use a seperate conditions for Mitigate eq 'Handling', you can add same condition in get items action filter query using and operator. By this output from get items would have items satisfying following conditions

Status eq 'Open'

Mitigate eq 'Handling'

To write the condition - write like this in filter query

Status eq 'Open' and Mitigate eq 'Handling'

Also remove the condition action as the get items would have handled that.

To understand how OR operator is used in filter query - refer this

https://www.spguides.com/power-automate-odata-filter-query/

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!
CU30122237-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nived_Nambiar Thank you very much for that explanation and link to educate myself more. I also followed your Youtube to keep up with what your teaching there. Have a great day.