Answered

Filtering SharePoint List Items on Date and Choice Fields for Reminder Email

(0) Share

Report

Posted on by KristenHammett

Hello,

I'm fairly new to Power Automate and I am trying to determine the best way to implement an email reminder for SharePoint list items. The requirement is that if the item's Completed Status is No (a choice field) and it has been 7 days since the item was created, send a reminder email. I'm planning to create a scheduled flow that runs daily for this, as the email is actually supposed to be a digest of multiple items that may be open, but I'm trying to figure out how I could filter on both the choice field and the date field with the 7 days from the created date logic. Can this be accomplished with an ODATA query on GetItems or would I need to do something else, like a FilterArray?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@KristenHammett

You'll want to use a filter query with 2 conditions connected with an AND. Here is a great blog post that will explain how.

Was this reply helpful? Yes No
Verified answer

KristenHammett 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you, @ScottShearer ! The link you provided is helpful for reference composing the filter query. I'm glad to know I can query those fields together. It looks like I can't perform the logic relative to checking if it has been 7 days since the item was created from within the odata query itself. I think this post may have the answer I need for how I can make that date comparison and looks like I'll need to iterate through the results to check this.

Was this reply helpful? Yes No