Skip to main content

Notifications

Power Automate - General Discussion
Answered

Map data form excel to sharepoint list

(0) ShareShare
ReportReport
Posted on 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

  • Re: Map data form excel to sharepoint list

    Thank you @ScottShearer 

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard