Search code examples
powerbipower-automate

Change in date format while using power Automate

I m using power automate to export table from power bi to a csv file. But the date format in columns is getting changed.

The following is my power automate workflow that i m using.

enter image description here

The following is the date format that it is exporting 2024-05-30T18:30:00.000Z But i need this format instead. 31-may-2024

I have tried changing the format of date in power query but it is not working.

Solution

  • The time you are receiving is in UTC and you can convert it to your standard time using convertFromUtc() method. It takes in 3 parameters:

    convertFromUtc('<timestamp>', '<destinationTimeZone>', '<format>'?)

    You can refer to the documentation here for more details:

    https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#convertfromutc