Unanswered

Create a date field = today's date + 1 month to show in my HTML table and email

(0) Share

Report

Posted on by MerlinT

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

Step 1.jpg

Step 2.jpg

Step 3.jpg

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

UshaJyothiKasibhotla 200 Moderator on at

Like (0)

Report

Re: Create a date field = today's date + 1 month to show in my HTML table and email

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.

Was this reply helpful? Yes No
MerlinT 42 on at

Like (0)

Report

Re: Create a date field = today's date + 1 month to show in my HTML table and email

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

Was this reply helpful? Yes No
UshaJyothiKasibhotla 200 Moderator on at

Like (2)

Report

Re: Create a date field = today's date + 1 month to show in my HTML table and email

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.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (1)

Report
Re: Create a date field = today's date + 1 month to show in my HTML table and email

Hi @MerlinT ,

Please add DocumentDueDate and expression in 'Select':

addDays(utcNow(),30,'yyyy-MM-dd')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Verified answer

MerlinT 42 on at

Like (0)

Report

Re: Create a date field = today's date + 1 month to show in my HTML table and email

Thanks so much for the detailed response. Worked exactly as I wanted.

Was this reply helpful? Yes No