Unanswered

Add date using simple yymmdd

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Sundeep_Malik 6,484 on at

Like (1)

Report

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. 🙂

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
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:

Was this reply helpful? Yes No
whissi 43 on at

Like (1)

Report

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

Was this reply helpful? Yes No