Filter Items on a SharePoint List

[DI123]

Hi All,

I'm currently trying to create a flow that sends an email notification when a SharePoint list item is due 7 days from today's date. I have been able to create a flow that does this successfully, however I need to be able to filter between Active or Closed risks and for the flow to only pull through the Active risks. I was wondering if it's as simple as just adding a bit more information in the filter query?

At the moment my steps are as follows:

- Recurrence

- Get Items (includes a filter query to pull the date through, which I have attached a screenshot of)

-Apply to Each (Value)

- Condition (@lessOrEquals(items('Apply_to_each')?['RiskEventDate'], formatDateTime(addDays(utcNow(), 7)))

- If yes, send an email.

Any help would be greatly appreciated.

[v-yamao-msft]

Hi @DI123,

According to your description, it seems that you would like to filter items that are Active as well.

Please check the following configuration for a reference.

For testing, create a List A includes columns Title, RiskEventDate (Date and time) and Status (Choice).

Add a Button trigger.

Add the action Get items, enter the following code in Filter Query field:

Status eq ‘Active’ and RiskEventDate ge ‘formatDateTime(utcNow(),'yyyy-MM-dd') and RiskEventDate le ‘formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')’

Add a Compose action to return the filtered Title.

Please check the following screenshot:

Best regards,

Mabel

[DI123]

Hi Mabel,

Thank you for your reply. Unfortunately, when I add State eq 'Active' to the filter query in the get items step the flow does not run successfully.

I have attached a screenshot of all of my current steps below.

[DI123]

Hi,

I have managed to find a solution to the issue. It was just a case of adding the internal column header at the beginning of the filter query so my filter query was as follows:

Risk_x0020_Status eq 'Active' and RiskEventDate ge '@{formatDateTime(utcNow(),'MM/dd/yyyy')}' and RiskEventDate le '@{formatDateTime(addDays(utcNow(),7),'MM/dd/yyyy')}'

Thank you for your help.