Forum Discussion

Jeyeline's avatar
Jeyeline
Brass Contributor
Jan 18, 2024

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
  • Jeyeline's avatar
    Jeyeline
    Brass Contributor
    It works now after changing the timezone at three places

Resources