cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Excel to planner flow

Hello Everyone,

we want to import an excel content table which is stored in onedrive to planner using create task in planner action, but I receive error message regarding start time format,

 

we have changed the date format several times but it still showing error messages "the request is nvalid cannot convert literal "----" to the expected type edm.datetimeoffset"

 

any idea of what could happened?error nme.JPGlist.JPGtable.JPGdate.JPGnel.JPGerrr.JPG

 

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please refer to screenshot below to create the flow:

1.png

 

The expression in the Start Date Time column as below:

addDays('1900-01-01',add(int(outputs('Compose')),-2))

The expression in the Due Date Time column as below:

addDays('1900-01-01',add(int(outputs('Compose_2')),-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.

View solution in original post

6 REPLIES 6
DeepakS
Super User
Super User

Hi @Anonymous  ,

 

When you format excel cell as a date column, it stores the date as an integer, so to use this in Power Automate, you should use the following expression:

 

addDays('1899-12-30',int(items('Apply_to_each_2')['Date']),'yyyy-MM-dd')

 

actually, we reversing what excel does and getting the date back by adding the integer to default start date. The correct start date is January 1, 1900 but in some cases, It does not return accurate results.

 

Read the following thread about these start dates:

 
 
——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
 
 

 

v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please refer to screenshot below to create the flow:

1.png

 

The expression in the Start Date Time column as below:

addDays('1900-01-01',add(int(outputs('Compose')),-2))

The expression in the Due Date Time column as below:

addDays('1900-01-01',add(int(outputs('Compose_2')),-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.

View solution in original post

Anonymous
Not applicable

Hello @v-alzhan-msft  I attempted to use that same solution but we still getting some error messages: it says cannot process the language expression in the action inputs the parameter is not valid, Do you know why is that happeningplanner.JPG

Hi @Anonymous ,

 

Please check the Date column and make sure the Date column in all the rows couldn't be null.

 

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.

I'm having the exact same problem, también en office en Español.

 

Could it be a language thing? were you able to solve this?

DeepakS
Super User
Super User

Hi ,

Checkout this video, where i am showing how to get data from Excel to Planner, I hope this will help you.

https://youtu.be/5lGkclFRJp4

 

Regards,

Deepak S 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,237)