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

Expiration + modifying alert + change column date

Hello,

 

So, i am trying to build a flow that does the following actions:

1. Send a reminder 7 days prior a file is going to expire to the mananger

2. After the manager modified the item, send an email to the department that they need to read the file again

3. Mark somehow that the file has been updated and is ready to use, like coloring the row in green?

4. Change the expiry date to one year later, meaning, if a file expired today 06/06/2019, after the file has been modified, change the expiry date to 06/06/2020

 

Later edit: I have manange to build the expiration part

Capture.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Post Prodigy
Post Prodigy

Re: Expiration + modifying alert + change column date

Hi @AlexandruCazan,

 

Based on your description of your requirements, I have created the following two flows to close your idea. You can refer to the configuration in the screenshot below:

Flow 1: Send a reminder 7 days prior a file is going to expire to the manager

Step 1: Create a Recurrence set as every day to check whether any file in the library will be expired in 7days later.

Annotation 2019-06-11 140919.png

Step2: Create the condition to check Expired_Date whether equal to current time add 7 days.

-If yes, send the reminder email with the file link.Annotation 2019-06-11 141023.png

 

Flow 2: When a file is modified, send a reminder email, set the expiration date to one year later. Last, since the row can't color to green, we create a column to mark the modified file.Annotation 2019-06-11 142857.png

You can have a try with it. If there is any problem, please contact us.

 

 

Best Regards,

Community Support Team _ Lin Tu

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

7 REPLIES 7
Highlighted
Helper IV
Helper IV

Re: Expiration + modifying alert + change column date

This seems to require multiple Flow collaborations to achieve this.

What is your current situation and whether there are any problems, please provide more details.

Highlighted
Frequent Visitor

Re: Expiration + modifying alert + change column date

So, i have manage to build the expiration bit, as i have shown in the picture posted, but i think i can add at least one new step in this flow. A yes/no condition in which, if the file was modified by the mananger -> send email to the others letting them know, and if the file wasn't modified, then don't send anything. Also is there any one i can color the row after an item was modified/reviewed?

Highlighted
Post Prodigy
Post Prodigy

Re: Expiration + modifying alert + change column date

Hi @AlexandruCazan,

 

Based on your description of your requirements, I have created the following two flows to close your idea. You can refer to the configuration in the screenshot below:

Flow 1: Send a reminder 7 days prior a file is going to expire to the manager

Step 1: Create a Recurrence set as every day to check whether any file in the library will be expired in 7days later.

Annotation 2019-06-11 140919.png

Step2: Create the condition to check Expired_Date whether equal to current time add 7 days.

-If yes, send the reminder email with the file link.Annotation 2019-06-11 141023.png

 

Flow 2: When a file is modified, send a reminder email, set the expiration date to one year later. Last, since the row can't color to green, we create a column to mark the modified file.Annotation 2019-06-11 142857.png

You can have a try with it. If there is any problem, please contact us.

 

 

Best Regards,

Community Support Team _ Lin Tu

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

Highlighted
Frequent Visitor

Re: Expiration + modifying alert + change column date

Hello,

 

So i got two errors. For the first one i had to get the actual column name, so, instead of 'Expiry_Date', i introduced 'expiry_x0020_date' and i got rid of the error. but the second error is telling me im using a null type and not a string.

23.PNG

I've tried switching the 'item' to 'triggerBody', ive tried reformatting the date in the expression from yyyy-MM-dd to mm-dd-yyyy, i changed the column settings from only date to date and time, and i cant wrap my head around the error..

 

 

Dual Super User III
Dual Super User III

Re: Expiration + modifying alert + change column date

Hi @AlexandruCazan 

 

Can you please post a screenshot of the condition part of the flow?

Highlighted
Frequent Visitor

Re: Expiration + modifying alert + change column date

Hello, it seems like now its working. Thank your for your feedback.

Highlighted
Frequent Visitor

Re: Expiration + modifying alert + change column date

Hey @v-lin-msft,

I have been trying to build a flow and assign it to the library in SharePoint site.

-When biulding a flow 1 I am getting the same error as a previous user and don't know how to sort it out?

-When building a flow 2 I dont seem to be able to run it even though it seems that I have followed all details precisely.

Please halp me out as I am loosing any hope at this stage 🙂

 

 

 

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 Solution Authors
Top Kudoed Authors
Users online (8,108)