Unanswered

Flow: Updating the a Date cell in Excel with its current value + 30 days

(0) Share

Report

Posted on by Bogdan_brg

Hello everyone,

I have an excel sheet that is used as input for my Flow, that creates monthly tasks every time the "Due check" column has the status "new task to be created". Two important columns in my excel Sheet are "Start date" and "Due date". So far so good. I use the Create a task connector, take all the needed values and the task is created.

However, once the task was created, I want to update the Start date and Due date with the dates for the next month, for example, if the start date in the excel file was 19.12.2019 when the flow runs, I would like the newly updated cell to be 19.01.2019. In order to update the cell in excel, I use the following expression in the "Start Date" filed: formatDateTime(addDays('Start Date',30),'yyyy-MM-dd'), in the "Update a row" step.

Excel file.JPG Update a row.JPG

Update a row 2.JPG

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

MattWeston365 1,701 on at

Like (1)

Report

Hi @Bogdan_brg the reason is because the reference you have to start date is not fully formed. Effectively you are passing in the string 'Start Date' rather than the full expression reference. As 'Start Date' is a string, it is not able to successfully run the expression. If you delete the 'Start Date' piece, place the cursor there, and then press dynamic content on the top then you'll be able to select the dynamic content you want there.

It should look something like: triggerBody()?['Start_Date'] depending on where the content comes from.

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

Like (0)

Report

Hi @Bogdan_brg ,

According to the error message, this error occurs because the format of the Start Date field value is dd-MM-yyyy, which is an unsupported format in the formatDateTime() function.

Maybe you could consider changing the date format to MM-dd-yyyy format so that this error can be resolved.

Best Regards,

Was this reply helpful? Yes No
Bogdan_brg 26 on at

Like (0)

Report

Thank you Matt! The solution worked and things look good now.

Was this reply helpful? Yes No