Flow to send email notification when it is less than 15 days left

[drishm]

Hi,

I have a SharePoint list created with the following for contracts:

Title
Todays Date (column created with flow)
Start Date
Expiry Date
Days Left (calculated column of expiry date - todays date)

Flow layout is:

Recurrence
Get items
Apply to each
Send email notification

I am not sure where but I am trying to add some sort of filter where it will only send an email notification when column "Days Left" is less or equal to 15 days.

Any assistance is appreciated.

Thanks.

Thank you.

[v-yiwenxie-msft · Accepted solution]

Hi @drishm 

As calculated column cannot be used in 'filter query' in 'Get items' for sharepoint.

So you can add an action 'Condition' to check whether the calculated column is less than or equal to 15.

Here is the condition:

The function used is:

string('15')

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[drishm]

Hi @v-yiwenxie-msft - thank you so, so much! 🙂 Works amazingly!