date from excel error

(0) Share

Report

Posted on by EP-29071004-0

Hi,

im tryiing to get a date from excel into my flow and using the workaround with two compose activities with the formula:

addDays('1899-12-30',int(outputs('compose')),'yyyy-MM-dd')

the output from the second compose im puting in an variable integer, for some reason im getting error as follow:

"BadRequest. The variable 'Due' of type 'Integer' cannot be initialized or updated with value '2020-01-31' of type 'String'. The variable 'Due' only supports values of types 'Integer'."

any idea why its not working?

regards,

Eyal

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Perez

Hi there. Have you already tried initializing the variable 'Due' as a String instead of an Integer? I've tested it, and that seems to work.

Keep us posted.

-Ed-

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (1)

Report
Copy link

Link copied!

thanks @edgonzales , that worked!

Was this reply helpful? Yes No