Unanswered

Getting string from created date

(0) Share

Report

Posted on by Community Power Pla...

I'm prefixing all uploaded docs in a library with the ID using an HTTP request. This all works.

What I need to do is extract the date from the created column. I want the output to look like 0520 (for May 2020).

I've experimented with variables, compose but I am thinking I may have to convert the created date to a timestamp then substring the correct numbers. Will need help with that!

Regards,

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Use the expression formatDateTime. See below.

formatDateTime(items('Apply_to_each')?['Created'],'MMdd')

Here I am iterating the created datetime in a loop and formats with month and date.

Another example using todays date.

formatDateTime(utcNow(),'MMdd')

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi abm,

If I wanted to do just the one uploaded document, I don't need the Apply to Each do I?

C

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Thanks for your reply. So after the upload are you trying to rename the filename? Could you please post a screenshot of your flow?

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes - just after a document is uploaded, I'm renaming it. I want to add the created date to that rename along with the ID. All I need to know is how to do the created date as:

0520

This would be May 2020.

The flow:

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Thanks for the screen shot.

Add a compose action before your http request. Under the compose use the formatDateTime against the created date. Then pass the output to next HTTP step.

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Try this expression

formatDateTime(triggerOutputs()?['body/Created'],'MMdd')

You could use this expression directly in your HTTP without the Compose action.

Thanks

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report
Hi @Anonymous ,

The expression for the date should as below:

formatdatetime(triggerBody()?['Created'],'MMyy')

Refer to screenshot below:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

It's my bad yes the format you need is 'MMyy'

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Why use TriggerBody() ?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Your trigger already have that info.

Thanks

Was this reply helpful? Yes No