I want to add the actual time when i created an item

(0) Share

Report

Posted on by JasonJunio_3

I want to add the actual time when i created an item, I use the function utcNow() for the formula in my powerAutomate but only the date is added to my list
Here is my flow:

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-mingkz-msft Microsoft Employee on at

Like (0)

Report

Re: I want to add the actual time when i created an item

Hi @JasonJunio_3,
please check if the date column in your SP list includes time.

Best Regards,
Kyrie

Was this reply helpful? Yes No
JasonJunio_3 29 on at

Like (0)

Report

Re: I want to add the actual time when i created an item

thank you @v-mingkz-msft, it seems your solution is correct, but it seems that I'm getting an incorrect time. How can I solve this? I get 1:55 AM instead of 4:55 pm

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (1)

Report
Re: I want to add the actual time when i created an item

@JasonJunio_3
You can try this formula:
formatDateTime(utcNow())

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Re: I want to add the actual time when i created an item

Is the difference between times the same as your local time zone's difference to UTC?

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report

Re: I want to add the actual time when i created an item

Why can't you just look at the default "Created" column for an item?

The created column is automatic for every item and unable to be deleted.

If you absolutely need the "Time" column to be filled with the "Created" date time, then just use the dynamic content Created in the update Time field.

Was this reply helpful? Yes No