Map data form excel to sharepoint list

Like (0) Share

Report

Posted on 17 May 2021 15:20:02 by Community Power Pla...

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

All responses (2)

Answers (1)

Community Power Pla... on 17 May 2021 at 15:57:44

Like (0)

Report

Re: Map data form excel to sharepoint list

Thank you @ScottShearer
Verified answer

ScottShearer 25,150 Most Valuable Professional on 17 May 2021 at 15:35:00

Like (2)

Report

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.