Answered

Time Zone from Location Point using Latitude - Longitude

(0) Share

Report

Posted on by LG2

Hi everyone, I would like to get the time in a city based in a different time zone. I have found this formula on Bing documentation but I'm not to sure how to apply it on Power Apps.

https://dev.virtualearth.net/REST/v1/TimeZone/{point}?datetime={datetime_utc}&key={BingMapsKey}

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LG2 :

I've made a test for your reference:

1\Create a flow(Bof0328)

Response Body JSON Schema

{ "type": "object", "properties": { "authenticationResultCode": { "type": "string" }, "brandLogoUri": { "type": "string" }, "copyright": { "type": "string" }, "resourceSets": { "type": "array", "items": { "type": "object", "properties": { "estimatedTotal": { "type": "integer" }, "resources": { "type": "array", "items": { "type": "object", "properties": { "__type": { "type": "string" }, "timeZone": { "type": "object", "properties": { "genericName": { "type": "string" }, "abbreviation": { "type": "string" }, "ianaTimeZoneId": { "type": "string" }, "windowsTimeZoneId": { "type": "string" }, "utcOffset": { "type": "string" }, "convertedTime": { "type": "object", "properties": { "localTime": { "type": "string" }, "utcOffsetWithDst": { "type": "string" }, "timeZoneDisplayName": { "type": "string" }, "timeZoneDisplayAbbr": { "type": "string" } } } } } }, "required": [ "__type", "timeZone" ] } } }, "required": [ "estimatedTotal", "resources" ] } }, "statusCode": { "type": "integer" }, "statusDescription": { "type": "string" }, "traceId": { "type": "string" } } }

2\Add the flow into the app

3\Add a button and set it's OnSelelct property to:

Set(TheResult,'PowerAppV2->HTTP'.Run("61.768335,-158.808765"))

Click the button, the information of the area where the location is 61.768335,-158.808765 will be saved to the variable TheResult.

Best Regards,

Bof
LucioGottardo 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Bof, thank you for following up and for sending me a solution. Unfortunately I was not successful as I’m new at using Flow. However, using the following code, triggered by a button, I am able to obtain the country name based on Latitude – Longitude. Using the above code can I get the time instead of the country name? It wold be a lot easier for me.

Set(varLatLong2; BingMaps.GetLocationByPoint(varForData.'Address 1: Latitude'; varForData.'Address 1: Longitude').address.countryRegion)
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LucioGottardo :
It is not available to get datetime by BingMaps connector.

Best Regards,

Bof
LucioGottardo 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, all much appreciated. I will endeavour further with Flow.