You’re offline. This is a read only version of the page.
42
I have created a flow to identify which files in a sharepoint library require review. Each file has a nominated reviewer.
So it gets the file properties for files that meet a number of filter queries. It pulls out the email addresses, uses a variable to take out the duplicated email addresses, creates a HTML table and sends one email to each reviewer listing all the relevant files they need to review.
What I would like to do, is add an additional field to the HTML table to create a Review Deadline date based on today's date + 4 weeks (I know the basic expression for this). This date would then be included in the email and I will add an extra step to update the file properties in sharepoint with that date.
What I am struggling with is where to add it in the flow i.e. is it another variable, is there a way to add it directly into the HTML table etc....
Hi @MerlinT ,
Please add DocumentDueDate and expression in 'Select':
Share
Report
All responses (
Answers (
addDays(utcNow(),30,'yyyy-MM-dd')Best Regards,
Sunshine Gu
Hi @MerlinT
write compose and place that function in that and the output of the compose then give the output of compose in the HTML table.
Try this
Hope this helps
Usha.
Thanks Usha. I do know how to add the date + period. My issue is where to actually add it, and what type i.e. do I add it as another variable or can I somehow add it in the HTML table directly etc.?
please find below thread
https://powerusers.microsoft.com/t5/Building-Flows/Add-X-months-or-year-to-today-s-date/td-p/1372059
Hope this helps,
Usha.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
