Hi,
I have a date stored in a dataverse table. The column is formatted as a date. When I display this date in my powerapp, there is a one day difference between the two (e.g. date in Dataverse is 1/12/2023 and this date in the app is showing 1/11/2023). Any idea why this is happening?
Thanks and Happy New Year!
@JulieLeahy , thank you. I am glad that you finally were able to solve your issue.
By the way, I registered an account here (been lurking for over a year) just so I could thank you. 🙂
THANK YOU!!! This issue has been PLAGUING me! For what it's worth, I only use "date only" data in my power queries, data tables, and power apps and I was still struggling with this issue until I changed all of the date settings in my tables to "time zone independent".
Most likely cause is that the date in dataverse is defined as user local. In a model driven app the local date will take the User's dataverse Personal setting for the Timezone and display it as per that. However, other interfaces may display it differently due to how they determine the users time zone, sometimes this off the device it is running on or the browser that it is running in. (easiest/most consistent is to try an not use user local unless you have to)
Hello, @karimabdelrazek, Make sure that your Date Column in the Dataverse table has been set to Date Only or Time zone independent in the Time zone adjustment:
If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
Most probably the formatting of the date in powerapps can be the issue, could you share screenshots for both, also include screenshots of the powerapps code that has been used.