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

How to build due date flow

Hi All,
Hope you are doing great today, I need help on building flow from a SharePoint list that has usernames, start date and status. In this flow, I need to automate the process of sending email 3 days before the date if the status is not returned.

 

UserStart dateStatus
Joe24/09/2020returned
Michele05/10/2020with user
Adam19/10/2020with user

 

Anyone who can help me on how to build the flow will be much appreciated. Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
chsanche
Microsoft
Microsoft

Hi @Nasriq 

 

i would build the Flow as follows:

1. A recurrence trigger to run every day

2. Get List items where the Status not equal returned

3. Apply to each on the resulting ones

   a. Get the item start Date and add 3 days

   b. Compare that date against today

   c. If they Match or greater, you can send the email

 

chsanche_0-1599694154482.png

 

 

You can check on the following URL on how to add the 3 days into the date: https://powerusers.microsoft.com/t5/Connecting-To-Data/Add-days-to-time-stamp/td-p/93096

 

 

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

View solution in original post

1 REPLY 1
chsanche
Microsoft
Microsoft

Hi @Nasriq 

 

i would build the Flow as follows:

1. A recurrence trigger to run every day

2. Get List items where the Status not equal returned

3. Apply to each on the resulting ones

   a. Get the item start Date and add 3 days

   b. Compare that date against today

   c. If they Match or greater, you can send the email

 

chsanche_0-1599694154482.png

 

 

You can check on the following URL on how to add the 3 days into the date: https://powerusers.microsoft.com/t5/Connecting-To-Data/Add-days-to-time-stamp/td-p/93096

 

 

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

View solution in original post

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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (50,126)