Date format is different in PBI / PA

[JorgeGBS]

Hello,

I have the column "Creation Date" in my Power BI table, but when I try to create the same table (HTML Table) with the same data in Power Automate, the data comes different.

Power BI

Power Automate Result:

How can I show the same date in HTML Table with Power Automate?

[Thanura09]

How to customize or format Date and Time values in a flow - Power Automate | Microsoft Learn

Try formatting the date

[JorgeGBS]

this way doesn't work, because my tables are all dynamics, and I can't use this

[PP4Sharon]

@Thanura09 

I have flow that I want to display items if Created is eq to [Today] but the Created date in the SP list is something like 5 hours ago or it spells out the month October 15, 2022...what can I put in the date time format if I want the flow to be [Today] as a variable?

 'formatDateTime(utcNow(),'MM-dd-yyyy')'

[Thanura09]

Yes, it shows that way in the created column. but if you get items in that list and put that 'created' in a variable(lets assume as date) it shows as follows: 2022-03-15T04:27:52Z. So, you can remove the time and see if date = today