while loading the data from the SharePoint list , the date fields are in the ' 2022-11-17T18:50:00Z ' format.
there are 12 date fields in the list. Is there any way to convert them all at one to "DD-MM-YYYY hh:mm:ss" format.
I have tried to provide timestamp format at main in the load script but it's not working.
Please suggest any solution to that.
One way is as follows
Hi @BrunPierre ,
Thanks for your suggestion, from the above expression, I have to do this for every Datefield.
My requirement is that, is there any way to convert these all DateFields in a single expression?