cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JorgeGBS
Frequent Visitor

Date format is different in PBI / PA

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

JorgeGBS_1-1665752308073.png

Power Automate Result:

JorgeGBS_0-1665752247832.png

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

4 REPLIES 4
Thanura09
Advocate I
Advocate I

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

@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')'

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,328)