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?
How to customize or format Date and Time values in a flow - Power Automate | Microsoft Learn
Try formatting the date
this way doesn't work, because my tables are all dynamics, and I can't use this
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
User | Count |
---|---|
27 | |
16 | |
15 | |
10 | |
10 |
User | Count |
---|---|
45 | |
29 | |
28 | |
24 | |
23 |