cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dauren08
Helper II
Helper II

Map data form excel to sharepoint list

Hello everyone,

 

I am trying to transfer data from excel to sharepoint list using power automate. My flow which I already created can do that, but fields with data type date and time they are wrongly transferred.. for example I have in excel file 12.03.2020 but in sharepoint it can be mapped 04.04.2090

so completely wrong. 

has someone already had any experience with it? would be nice if there is any tutorial how I could solve this problem.

 

Regards

Dauren

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User III
Super User III

@Dauren08 

You'll want to select ISO 8601 under Date Format (advanced options) in the List Rows or Get a Row actions.

image.png

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

Scott

View solution in original post

2 REPLIES 2
ScottShearer
Super User III
Super User III

@Dauren08 

You'll want to select ISO 8601 under Date Format (advanced options) in the List Rows or Get a Row actions.

image.png

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

Scott

View solution in original post

Thank you @ScottShearer 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (20,811)