cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexandruCazan
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
v-lin-msft
Post Prodigy
Post Prodigy

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
tfhegdbn
Helper IV
Helper IV

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.

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?

v-lin-msft
Post Prodigy
Post Prodigy

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

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..

 

 

Hi @AlexandruCazan 

 

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

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

_Title
Frequent Visitor

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
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 (64,010)