
Announcements
Dear community,
I am trying to load my Excel list in a Dataverse tabel with a Power Automate flow. In one of my columns in Excel called "Geboortedatum" i have a date stored. That i would like to store in Dataverse as just Text. I know when you fetch a date in Excel you get a number. So i put the notation to ISO 8601 to solve this. Now i get this format:
"Geboortedatum": "1957-02-28T00:00:00.000Z"
What i would like is to load the column in the Dataverse table with this format below only. So just the date.
"dd-mm-yyyy" instead of"yyyy-mm-dd"
What do i have to change in my Power Automate flow.
Gr. P
Try wrapping the date in a formatdatetime.
You can read more about it here