web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Show data based on the...
Power Apps
Unanswered

Show data based on the account location

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

I want to show data based on the account's time zone and not based on the user time zone.

 

The data stored in table are in UTC.

 

On column it shows only two options User Local, Time Zone Independent. This will show the data based on User Time zone or UTC respectively.

 

Is there any way I can show data in Account location, my accounts are from different time zones, but user will be same who will be looking at data.

Categories:
I have the same question (0)
  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @Umesh_B,

    Do you want to cuto-capture the location of the account and display date for that time zone?

     

    Currently, Power Apps only supports to get the location of the current user instead of the account.

     

    Here is the thing, If the data retrieved from the store is time zone independent, but your date picker is set to local, the UTC data will be displayed as user local time based on the user's time zone in their profile. The reverse is also true, a user local value from the store will be displayed as UTC if the your date picker is set to UTC. 

     

  • Umesh_B Profile Picture
    2 on at

    Hi Qi,

     

    Thank you for your replay,

    I am building an event base ticketing system the data is collected from IOT. If I am communicating with the Account which if from another time zone, then I must know the event time in their time zone while communicating with them.

     

    Can you please suggest, how do we achieve this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard