cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drishm
Helper I
Helper I

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

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:

2.18-21.PNG

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.

View solution in original post

2 REPLIES 2
v-yiwenxie-msft
Microsoft
Microsoft

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:

2.18-21.PNG

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
Helper I
Helper I

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,293)