cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

date from excel error

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

 
 
 
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: date from excel error

@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.

View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: date from excel error

@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.

View solution in original post

Highlighted
Helper IV
Helper IV

Re: date from excel error

thanks @edgonzales , that worked!

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (9,171)