Answered

Get current date in a specific format

(0) Share

Report

Posted on by ddhwls1

I need to trigger a url that appends the current date to the end of the url in the format mm-dd-yy. I can use CurrentDateTime and retrieve current date only but I can't find how to convert the format to what I need. I thought this would be easy but I can't seem to find or figure it out. Any help is appreciated.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

CFernandes 8,482 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hey @ddhwls1

You need to use the Expression

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

https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/how-to-customize-or-format-date-and-time-values-in-flow

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
ddhwls1 13 on at

Like (0)

Report
Copy link

Link copied!

perfect. Thank you.

Was this reply helpful? Yes No
ddhwls1 13 on at

Like (0)

Report
Copy link

Link copied!

I guess that answered the formatting question but when the command shows up in the url vs passing the actual date.

I set a variable OD= to 'formatDateTime(utcNow() 'MM-DD-YY'
when I try and pass the variable to https//www.somewebsite.com/%OD% it shows as https://www.somewebsite.com/formatDateTime(utcNow()%20'MM-DD-YY')

obviously, I am new to this.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @ddhwls1

Add a Compose -

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

Add another Compose -

concat('https://www.somewebsite.com/',outputs('Compose'))

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
ddhwls1 13 on at

Like (0)

Report
Copy link

Link copied!

I truly appreciate your willingness to help but I don't see option to add a Compose. Perhaps this is a premium option?

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @ddhwls1 Compose is not Premium.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
ddhwls1 13 on at

Like (0)

Report
Copy link

Link copied!

I'm not seeing the option for a data operation. Evidently we aren't using the same app or I'm just confused. Attached is what I see.

Was this reply helpful? Yes No
ddhwls1 13 on at

Like (0)

Report
Copy link

Link copied!

I was using power automate desktop. It's located in cloud flow. Thanks for the help.

Was this reply helpful? Yes No