Forum Discussion
Jeyeline
Jan 18, 2024Brass Contributor
Date field of sharepoint list is assuming one day prior to the date in imported excel
Hi Team,
I would like to create a power automated flow based on the SharePoint list. I imported an Excel file with having date field. However, in the sharepoint list it is taking previous date to the uploaded format.
I have tried changing date format in excel sheet as well. Still, facing the same issue. How to solve it, so that power automated flow would work fine.
Attaching the sample date field in the sharepoint list and excel book.
Note: We have updated the timezone in sharepoint to GMT +5:30 and local timezone is also the same.
- It works now after changing the timezone at three places
- JeyelineBrass ContributorIt works now after changing the timezone at three places