Add date using simple yymmdd

Like (0) Share

Report

Posted on 22 Oct 2022 19:56:44 by whissi

Hello Guys,

I am trying to add a date to update sp list through power automate by using (triggerOutputs()?['body/Created']) but its giving me result of (2022-10-22T19:04:31Z) and I don't what that I need it to be 221022 {yymmdd} so I can use it as code numbers.

Any help will be appreciated

All responses (3)

Answers (2)

whissi 43 on 23 Oct 2022 at 08:38:16

Like (1)

Report

Re: Add date using simple yymmdd

@Sundeep_Malik and @grantjenkins Thanks for your help both worked.
Verified answer

grantjenkins 11,059 Moderator on 23 Oct 2022 at 07:56:25

Like (1)

Report
Re: Add date using simple yymmdd

You can get this a couple of ways.

Option 1: Have a Compose or Variable using the expression:
formatDateTime(triggerOutputs()?['body/Created'], 'yyMMdd')

Option 2: If you wanted to convert it to your time zone (dates come through using UTC time zone) then the easiest way is to use Convert time zone as so:

The outputs for both options are below:
Verified answer

Sundeep_Malik 6,482 on 23 Oct 2022 at 07:56:17

Like (1)

Report

Re: Add date using simple yymmdd

Hey @whissi

Just write this:

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

write the above expression. I didn't try it on my end but it should work.

If it works, you can mark this answer as the solution and also thumbs up 👍 the post. It really helps. 🙂