web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Map data form excel to...
Power Automate
Answered

Map data form excel to sharepoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @Anonymous 

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

    image.png

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you @ScottShearer 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 809

#3
Haque Profile Picture

Haque 645

Last 30 days Overall leaderboard