Unanswered

Populate Planner Due date based on plus 91 days from a forms field

(0) Share

Report

Posted on by EmmaMc

Can anyone advise how to populate a Due Date in Planner taken from a date field in Forms with 91 days added? The date field is not a time stamp.

I am currently taking the forms data into an excel sheet (which also has a column that calculates the future date =WORKDAY([@[Date of Health Check]],65) - but I can't get this or the original entry from the Form to populate the Due date in the planner task.

Thank you

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @EmmaMc

Just tried with sample form with date field like below

Date value obtained from form:

Now i have used the below expression to add 91 days to form field date like below
addDays(outputs('Get_response_details')?['body/r48708db6463a4efaa7221cb64371cb21'],91,'yyyy-MM-dd')

Highlighted part, you have to replace the date dynamic variable, in my case it was enter date

Results got:

Hope it helps 🙂
Mark it as solution if resolves your query 🙂

Was this reply helpful? Yes No
EmmaMc 4 on at

Like (0)

Report

Sorry Nived N - I didn't understand your response so unable to know where to apply the formula. I've pasted below the area in the flow and it's the 'Due Date Time' field I need to populate with +91 days from the 'start date time' field.

Does that make more sense? I'm not great on the whole formulas piece so grateful for any suggestions. Thanks.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @EmmaMc

You have to enter the expression in due date like below

then click ok button to make the expression appear on due date field.

Also make changes in expression as said accordingly earlier 🙂

Was this reply helpful? Yes No
EmmaMc 4 on at

Like (0)

Report

Hi Nived, sorry but this still isn't working. Any chance you can send a video of what you are doing and how you are selecting the inputs to get the calculation? Much appreciated.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @EmmaMc

Do you need to know how to enter the expression values ?

Was this reply helpful? Yes No