Hi @Anonymous ,
It is a known issue/limit with datetime column in SQL Table. When you display datetime column value from a SQL table within an app, you may have the offset issue (Due to different time zone).
More details about the known issue/limit with datetime column in SQL table, please check the following blog:
https://powerapps.microsoft.com/en-us/blog/working-with-datetime-values-in-sql/
As an alternative soluion, you could consider take a try to remove the datetime type column from your SQL table, instead, add a datetimeoffset type column in your SQL table to store the date time value.
In addition, I also agree with @RandyHayes 's thought almost. If you don't want to remove the datetime column value from your SQL table, I think the TimeZoneOffset() function and DateAdd() function could achieve your needs (mentioned within above blog I provided).
I have made a test on my side, please take a try with the following formula (set the Text property of the Label control in your Gallery to following😞
DateAdd(YourDateTimeColumn, -TimeZoneOffset(YourDateTimeColumn), Minutes) /* <-- YourDateTimeColumn represents the datetime column in your SQL table */
Or
DateAdd(YourDateTimeColumn, 5, Days)
Best regards,
