Issue converting times and OData output is wrong?

(0) Share

Report

Posted on by Usernametwice

503

Hi all

I have a condition that says if utcNow is less than

"formatDateTime(variables('Time Check'), 'utcNow(), 21:00 tt')" than Update some rows:

On updating the rows, I am trying to get a specific time into the selected row thus using the convert time. My issue is that the resulting time is 1 day ahead at 8am and I cant change it no matter what I try.

Here is the input/output of the conversion and it looks fine:

Here is how i set it up:

Update row:

But here is the output of the update row:

As you can see, there are 2 differrent times. Is there any way I can change the OData out put?? I think this is what is causing my issue because that is the incorrect time. Im not sure if maybe I have to change my time conversion formula either?

I read a bit into this - https://docs.microsoft.com/en-us/powerapps/developer/data-platform/behavior-format-date-time-attribute#using-odata-apis-to-submit-user-local-date-and-time-values

But im still unsure on how to resolve this and get the correct date / time I want?

Thanks for the help everyone.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Usernametwice23

Why you need to convert the time? Can't you directly use the formatDateTime(utcNow(), 'yyy-MM-dd 21:00:00') ?

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report

Hi @abm

Because the same thing happens -
I get the wrong date/time.

Is it possible to convert times in power automate?

Thanks for the help.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Usernametwice23 :

You could try:

formatDateTime('9/11/2021 8:00 AM')

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report

@v-bofeng-msft Hi

I have tried the compose and cannot get the correct time output for update row -

Update row:

Could this be a date/time formatting issue or something else?

Thank you

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report

Also even if I try subtracting 11 hours, it does not work and automatically makes the time 9/11/2021 10:00 instead. (so it subtracts from 9pm) and then if I try adding 11 hours, it makes the time 10/11/2021 8:00.

So it's like it cant just add the todays date (9pm) or something is stopping it in the update rows output and it gets converted again after converting it in power automate functions.

Any help is much appreciated.

Was this reply helpful? Yes No