Answered

Trying to add 1 more filter to my flow

(0) Share

Report

Posted on by bobgodin

380

I posted on this forum late last year and thanks to @v-chengfen-msft got a solution to my problem which was to get my flow to send an html email based on data from 2 linked Sharepoint lists. I have a filter that restricts dates to between Today() and Today()+5 so the email only contains data for that time period.

I now want to be able to add a filter on region so I will send an email containing data for Northern region and another email for Southern region

The region field has been added to the Sharepoint list called Trips so I just want to be able to filter Trips by region before I come to the send email part. My flow is laid out in the original post

any help is much appreciated 🙂

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bobgodin You can add one more logic in your filter query. Add this in your filter- Trips eq 'your region dynamic field'

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 thanks but could you tell me where to put this additional query?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bobgodin Pls share screen of your previous filters where you were filtering based on dates.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report
Copy link

Link copied!

hi @Hardesh15 if you click the original post link it has screenshots of the entire flow

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bobgodin sorry can you pls share it again?

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 https://powerusers.microsoft.com/t5/General-Power-Automate/Trying-to-use-Flow-to-send-email-containing-HTML-table-using-2/m-p/1905956?attachment-id=36997

https://powerusers.microsoft.com/t5/General-Power-Automate/Trying-to-use-Flow-to-send-email-containing-HTML-table-using-2/m-p/1905956?attachment-id=36998
https://powerusers.microsoft.com/t5/General-Power-Automate/Trying-to-use-Flow-to-send-email-containing-HTML-table-using-2/m-p/1905956?attachment-id=36999
let me know if this is not enough.....

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bobgodin I want this from you so that you can also understand where i am pointing you for your requirement.

here in filter query add one more after calculated time as i suggested above.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 the region field is in the Trips list not the TripDetails list...

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@bobgodin Then use get items action with the same filter : Trips eq 'your region dynamic field'

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 I have solved the problem. I went to the GetTrips action and added "and region eq 'Water Northern'" and it filtered correctly - see attached screenshot

Was this reply helpful? Yes No