cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drishm
Frequent Visitor

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.

View solution in original post

drishm
Frequent Visitor

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (34,196)