SOLVED

Date field of sharepoint list is assuming one day prior to the date in imported excel

Copper Contributor

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.



 

 

1 Reply
best response confirmed by Jeyeline (Copper Contributor)
Solution
It works now after changing the timezone at three places
1 best response

Accepted Solutions
best response confirmed by Jeyeline (Copper Contributor)
Solution
It works now after changing the timezone at three places

View solution in original post