Flow to send an email when SharePoint item is due in 7 Days

[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've currently tried several expressions that are pulling through the date but don't seem to be filtering out results that are due in 7 days - they're just pulling through everything that has a date. 

At the moment my steps are as follows:

- Recurrence

- Initialize Variable (Name: Alert Date. Type: String. Value: 

addDays(utcNow(),7,'MM/dd/yyyy')

-Get Items

- Appy to Each (Value)

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

- If yes, send an email

I Have attached screenshots of my flow below.

Any help would be greatly appreciated.

 

[v-bacao-msft · Accepted solution]

Hi @DI123,

You could filter directly using Filter array contained in Get Items.

In the filter condition, I feel that we need to add another part. If only the setting is less than or equal to, those items that have expired will also be inclueded, so I added a part greater than or equal to.

I have made a test on my side and the flow works well. Please take a try with the following workaround.

The two expressions are:

formatDateTime(utcNow(),'yyyy/MM/dd')

formatDateTime(addDays(utcNow(),7),'yyyy/MM/dd')

Note that they have single quotes on the outside.

Image reference:

Please take a try.

Best Regards,

Barry

[DI123]

That worked perfectly.

Thank you!