Issue converting times and OData output is wrong?

(0) Share

Report

Posted on by Usernametwice

501

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.

All responses (5)

Answers (0)

Usernametwice 501 on at

Like (0)

Report

Re: Issue converting times and OData output is wrong?

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.
Usernametwice 501 on at

Like (0)

Report

Re: Issue converting times and OData output is wrong?

@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
v-bofeng-msft on at

Like (0)

Report
Re: Issue converting times and OData output is wrong?

Hi @Usernametwice23 :

You could try:

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

The Result:

Best Regards,

Bof
Usernametwice 501 on at

Like (0)

Report

Re: Issue converting times and OData output is wrong?

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.
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Issue converting times and OData output is wrong?

Hi @Usernametwice23

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