You’re offline. This is a read only version of the page.
83
Hello Team,
I would really appreciate some help with the following issue.
I have created a Power Bi report where I have embedded power automate and when the user selects Export to excel
and the row data of this table will be saved into an excel hosted in a SharePoint Site.
The flow runs successfully
and the row data are added to the excel table, however the date format is not correct.
Would you be able to help me and give some guidance on what I need to add in my flow in order to format the date to dd/mm/yyyy (UK time)?
Many Thanks,
Vasia
In Excel, right click on any cell having the date say B2 - Format cells - Custom - And see whether the date format is set to mm/dd/yyyy here. If you have any other entry there, just remove that. This should correct your problem.
Use formatDateTime() to customize or format Date and Time values in a flow.
You can go to Add dynamic content > select the Expression tab
Example: formatDateTime('2009-06-15T13:45:30', 'M/dd/yyyy') -> 6/15/2009
Let me know if any queries
Regards
Kaif
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
