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
@Anonymous
You'll want to select ISO 8601 under Date Format (advanced options) in the List Rows or Get a Row actions.