Answered

formatDateTime() function not working with dynamic content

(0) Share

Report

Posted on by dt235293

When I use the Start Date and End Date dynamic content normally, the flow works correctly, but I get an output with a full timestamp that looks ugly.

So I tried to use the formatDateTime() function to clean it up.

Unfortunately, when I try to call the start and end date dynamic content in the middle of a function, those items do not appear for me, the only items that appear are "body" and "value", which I don't want.

Is this a bug? And is there a workaround?

Thanks!

Screenshot of full workflow up to the point where I have an issue:

Screenshot of using dynamic content in the "Start" field in the Create HTML Table section.

Screenshot of the dynamic content field after I create an expression. Notice that my options shrink:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

dt235293 9 on at

Like (0)

Report
Copy link

Link copied!

Of course, i found an immediate workaround once I posted this:
convertTimeZone(item()?['Start'],'UTC','Central Standard Time','g') will provide the user with this date notation:
7/19/2022 7:00 AM

Was this reply helpful? Yes No
sabrina45322 10 on at

Like (0)

Report
Copy link

Link copied!

for today

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

lowercase M is minutes, big M is months. you can change around what is in the single quotes.

for other days
formatDateTime(addDays(utcNow(),-1),'MM-dd-yyyy')

-1 = yesterday, etc.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dt235293,

Glad that you have resolved your problem.

Could you please mark your reply as an answer to help more users?

Thanks for your cooperation.

Was this reply helpful? Yes No