Applies to Product - Power Apps
What’s happening?
The datetime column shows a difference between the dataflow and the SharePoint list.
Reason:
The discrepancy in the datetime values is due to the SharePoint list's time being in a different timezone, requiring an adjustment to align with the expected timezone.
Resolution:
To resolve this, add a step in Power Query to adjust the datetime values. Use the following formula to add the necessary time adjustment: = Table.TransformColumns( #""Changed Type"" , { { ""StartDate"" , (x)= x + {ALPHANUMERICPII} ,type datetime } , { ""EndDate"" , (x)= x + {ALPHANUMERICPII} , type datetime } } ) This adjustment accounts for the timezone difference by adding the appropriate hours to the datetime columns.