Answered

addDays using Excel fields

(0) Share

Report

Posted on by JMDel

Hello! Newbie at power automate 🙂 I am building a simple flow using the For a Selected Row template on excel to create tasks on Asana. I want to take the Date field on the excel table and use it with addDays() to create a new duedate on Asana but it keeps giving me errors. I've tried searching onto here for solutions but none of them seems to work. Would anyone have any ideas on a workaround? Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report
Hi @JMDel ,

Flow reports an error that the value you provided is empty, which means there are empty rows in your field, so I used an if statement.

If the field is empty, convert it to null. If it is not empty, add the number of days you want and format it into yyyy-MM-dd.

Please try this expression:

if(empty(filed),null,adddays(filed,number,'yyyy-MM-dd')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JMDel 15 on at

Like (0)

Report

Hi @v-yetonggu-msft,

Thank you for the code!

Its giving me expression is invalid 😞

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

Like (0)

Report

Hi @JMDel ，

Could you please provide a screenshot of your flow control and the field names you use?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JMDel 15 on at

Like (0)

Report

Hi @v-yetonggu-msft ,

This was my very first input on the formula
The field on excel is named 'Release Date'

Thank you!

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @JMDel ,

Okay, I know what you mean.

Please try this expression again:

if(empty(triggerBody()?['entity']?['Release Date']),null,addDays(triggerBody()?['entity']?['Release Date'],6,'yyyy-MM-dd'))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JMDel 15 on at

Like (0)

Report

Hi @v-yetonggu-msft ,

It worked, thank you!

Just an additional question, when my excel has values how can I get it to calculate using these dates on excel instead of having it as null?

Thank you!

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

Like (0)

Report

Hi @JMDel ,

The first thing to do is to make sure that your 'Release Date' column meets the date format that exists in Excel.

Please do not create a format yourself, otherwise the date column cannot be calculated in flow.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JMDel 15 on at

Like (0)

Report

Hi @v-yetonggu-msft ,

Noted on that, thank you so much! 🙂

Was this reply helpful? Yes No