Answered

How to write a convert to UTC formula in Powerapps?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

This works in Power Automate but doesn't look like it works in powerapps.

convertFromUtc(outputs('Wait_for_an_approval')?['body/completionDate'],'South africa standard time','dd/M/yyy H:mm tt').

How do I write this correctly in Powerapps?

Also, if I'm passing date data types from date pickers in power apps to flow (ask in powerapps) I noted that there is a special format that must be used in the text function to format the string namely "yyyy-mm-dd" in order for Sharepoint to accept it.

Is there a specific formatting for Sharepoint as far as the time goes? Is "yyyy-mm-dd H:mm tt" fine? If not please tell me the correct time formatting.

Thank you very much.

Regards,

Daniel

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Anonymous

Take a look at the documentation on TimeZoneOffset. There is an example there for converting to UTC.

Basically - DateAdd( Now(), TimeZoneOffset(), Minutes )

When you set a date in SharePoint, you do not need to convert it to text, you can simply use the date type returned from the date formulas.

When you pass a date to flow - you are correct that it does need to be in the proper format.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Randy,

Many thanks you helped me immeasurably! It's working.

Regards,

Daniel

Was this reply helpful? Yes No