Skip to main content

Notifications

Community site session details

Community site session details

Session Id : /t7vJBsiC2VBw14bOeoYvo
Power Automate - General Discussion
Answered

Map data form excel to sharepoint list

Like (0) ShareShare
ReportReport
Posted on 17 May 2021 15:20:02 by

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

  • Community Power Platform Member Profile Picture
    on 17 May 2021 at 15:57:44
    Re: Map data form excel to sharepoint list

    Thank you @ScottShearer 

  • Verified answer
    ScottShearer Profile Picture
    25,150 Most Valuable Professional on 17 May 2021 at 15:35:00
    Re: Map data form excel to sharepoint list

    @Anonymous 

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

    image.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard
Loading complete