Approver Action Date not showing accurate date

[kevinjeronne]

I have an approval flow that is connected to a power app that is utilizing SharePoint lists.

I have a column named 'Approver 1 Action Date' with a type of Date and Time

in the following pictures below:
The requested date code is from the 'Created' column that is automatically present on a sharepoint item which shows accurate date. Says here January 25, 2024 

clearly the approver date must be over than the requested date because no way the approver can approve a request without even the request being sent.

this is the code im using for the approver date:

If(IsBlank(ThisItem.'Approver 1 Action Date'),
"",
"Action Date: " & Text(ThisItem.'Approver 1 Action Date',DateTimeFormat.ShortDate))

this is the code im using for the request date:

"Request Date:  " & Text(ThisItem.Created,DateTimeFormat.ShortDate)

for the value I set on 'Approver 1 Action Date' in power automate 

I tried to use both the responseDate and requestDate. But both still shows the inaccurate results so I figured might be on the code/function written in the text property.

[Jmanriquerios · Accepted solution]

Hi @kevinjeronne 

I recommend you review the following points:

1. Check the Power Automate date output so that you see the format it returns and above all use the correct value that should be when the approver approves or rejects the request.
2. Sometimes when we work with hours, the time zone and regional configuration may play a role, there I recommend that the date output use a convert time zone time action to ensure that regardless of the user's regional configuration all They will be under the same time zone.
3. Create a label in your Power Apps, where you bring the value that the flow is returning and in this way you validate that the value is correct.

This has already happened to me with Dataverse and I solved it with the convert time zone and then it worked perfectly

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

[kevinjeronne]

will try this. 
I'll accept yours as a solution once it worked with me too. Thanks a lot @Jmanriquerios 

tried this method. 
utc to AUS Eastern Standard Time

i requested at 1/25/24 and the approver action date became 1/26/2024 

im going to lose it. Seems like I made a mistake somewhere.
wondering what is the default timezone of the action "wait for approval" 

[kevinjeronne]

I solved my problem using this

apparently this converts utc to local time
to match the 'Created' Column 

DateAdd(ThisItem.'Approver 1 Action Date',-TimeZoneOffset(),TimeUnit.Minutes)

[kej]

hello @Jmanriquerios 

just wanted to ask how do I get the source time zone of a create for an approval request date  ( date the approval request was sent )

does it follow the sharepoint regional setting or my local setting?

[Jmanriquerios]

Hi @kej 

It depends on the configuration you have set up for the field

[kej]

but I have not configured anything yet before I used the convert time zone. the requested date is one of the dynamic content of create an approval.

I want to know what source time zone will I put.

Please refer to this post. would be a huge help @Jmanriquerios 
https://powerusers.microsoft.com/t5/Building-Flows/How-do-I-know-the-source-time-of-a-Request-Date-f...