cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Setup expiry and change the font colour

I want to do a flow for sharepoint online.

I have a sharepoint list with Staff(person or group), Training1(DAte_Column), Training2(DAte_Column), Training3(DAte_Column), Status

condition1 is when training 1 is 30 days from now, send email to staff.

condition2 is when training 1 is 60 days from now, send email to staff.

condition2 is when training 1 is 90 days from now, send email to staff.

 

Whats the best way to create the workflow

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Setup expiry and change the font colour

Hi @zsheriff2019,

 

Could you please explain more details about your requirement?

What is the trigger in your flow? 

Do you want to check all items in the sharepoint list?and your requirement is as below:

condition1 is when training 1 is 30 days from now, send email to staff.

condition2 is when training 1 is 60 days from now, send email to staff.

condition3 is when training 1 is 90 days from now, send email to staff.

 

If yes, please refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

The expression in the Condition as below:

@equals(formatDateTime(items('Apply_to_each')?['Training1'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 30), 'yyyy-MM-dd'))

 

The expression in the Condition 2 as below:

@equals(formatDateTime(items('Apply_to_each')?['Training1'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 60), 'yyyy-MM-dd'))

 

The expression in the Condition 3 as below:

@equals(formatDateTime(items('Apply_to_each')?['Training1'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 90), 'yyyy-MM-dd'))

 

Best regards,

Alice

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (8,263)