Getting string from created date

[Anonymous]

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,

C

[abm]

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

[Anonymous]

Hi abm,

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

C

[abm]

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

[Anonymous]

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:

[abm]

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

[abm]

Hi @Anonymous 

Try this expression

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

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

Thanks

[v-alzhan-msft · Accepted solution]

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.

[abm]

Hi @Anonymous 

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

Thanks

[Anonymous]

Why use TriggerBody() ?

[abm]

Hi @Anonymous 

Your trigger already have that info. 

Thanks

[v-alzhan-msft]

Hi @Anonymous ,

The triggerBody()?['Created'] is the expression of Created dynamic content from the trigger

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.