AddDays expression

(0) Share

Report

Posted on by Community Power Pla...

What do I need to type in this expression to get the Due Date to be Start Date (which is a field from a Form) + x days.

AddDays-forum post.jpg

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report

Hello @Anonymous
For example, to add 2 days to the start time field, you could use an expression like:
addDays(body('USB_Drive_()')?['Start_Date'];2)

Hope it helps.
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks, I don't think that's quite what I need. The field that will have the calculated date is the Due Date" and the date it shows needs to be "Startdate" field from the form + 5 days (for example).

e.g. the form Start Date is Feb 20th. So Due Date field should be Feb 20th+5 days = 25th (but the Start Date is not manually entered it comes from the Form Field).

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

So, if I understand, you need the start date field from the form response, isn't it? Therefore the expression should be:
addDays(body('get_response_details)?['StartDate'];5)
Hope it helps.
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I got this error..

"error": {
"code": "",
"message": "The request is invalid:\r\nCannot convert the literal 'addDays(body('get_response_details)?['2020-02-12'];5)' to the expected type 'Edm.DateTimeOffset'.",
"innerError": {
"request-id": "8a1ca5c4-8ebe-4044-ab10-70eb12be8cd9",
"date": "2020-02-11T19:36:35"
}
}
}

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hello @Anonymous
You should use formatDateTime function to convert date value to string, as it is expected to create the task in Planner. Have a look at this sample (visit_date is a date field in the form):

Hope it helps!
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks...where would the AddDays expression be placed in this?

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @Anonymous ,

Please refer to screenshot below to create the flow:

The expression for the Due Date Time field as below:

add(outputs('Compose'),2)

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hi @Anonymous
I don't understand your question... Anyway, you could place the formula inside the "Due Date" field in planner task.

Was this reply helpful? Yes No