Time zone issues in Power apps portal

Anonymous · ‎08-04-2020

Hi Community Experts!

I am facing an issue in displaying the entity list view on the Portal. I fetch the data in the view from a database and this data is refreshed everyday in the morning. I need only current day's data to be displayed on the Portal and therefore I have added a filter for the Entity view as "'Created On' is today". I am able to view all the Portal records but our client who is in a different time zone is not able to view the record as I have used the filter as 'Today'. So in his time zone the data is not updated in the Portal until my data from the database gets updated next day as a result of which he would see no records displayed on the Portal. Could anyone please help me on fixing this issue.

Your help is greatly appreciated!

Thank you in advance!

OliverRodrigues · ‎08-04-2020

Hi

Is your date field a Date Time or Date Only field? try to make sure the field behaviour is set to Date Only:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/behavior-forma...

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Pages Super User | MVP

Oliver Rodrigues

Anonymous · ‎08-04-2020

Hi @OliverRodrigues ,

I am using the Date only field for the date field on the Portal. Could you suggest on how can we change the portal time zones?

Thank you!

OliverRodrigues · ‎08-04-2020

is the behaviour also set to Date Only?

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Pages Super User | MVP

Oliver Rodrigues

Anonymous · ‎08-06-2020

Hi @OliverRodrigues ,

Thank you for the reply. Even after setting the behaviour to date only, the Portal will show there are no data to display when I change my system's time zone. The portal shows data based on my system time zone. If I set it to my Client time zone and publish the entity view, it shows data and again if I change back to my time zone the portal automatically takes my time zone and shows there are no data to display after 12 am.

For example, the portal refreshes data at 4:30 am UTC which is 10 am IST and 12:30 am EDT. I have set the filter as 'Created On' is Today. When my system is in time zone IST, the portal shows 'no records to display' after 12 am till 10 am until the records are refreshed from the database. Even if I set my system time zone to EDT it shows records and again when I switch back time zone, Portal automatically takes my time zone and shows data accordingly to everyone irrespective of their time zone even if I do not publish the entity view in my time zone and shows 'no records to display' to a person whose time zone is in EDT from 2:30 pm onwards. Could you please help me fix this..

Your help is greatly appreciated.

Thanks a lot!

OliverRodrigues · ‎08-09-2020

Hi

I just tested a similar situation here in my trial environment, and I can't get the same behavior, for me it is working fine even when I change the timezone on my computer

I recommend you open a support ticket with Microsoft so they understand what's happening, the Portals should pick the server date and not the client's

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Pages Super User | MVP

Oliver Rodrigues