cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Iyyanar
Level: Powered On

Wrong time after saving into Sharepoint List

I retrieved data from SQL table and dispplay in PowerApps then get some inputs from users and save the data into SharePoint 2013 Online list. But not saved correct time in SharePoint list date and time field which is displayed in PowerApps. Please help me anyone to resolve this one.

1 ACCEPTED SOLUTION

Accepted Solutions
iamlee
Level 8

Re: Wrong time after saving into Sharepoint List

PowerApps by default will always display in local time. Since you mentioned your time is in EST time, your SharePoint will convert the DateTimeValue from PowerApps. If you don't want the conversion to happen, make your SP field a text field and just post the 'text' value of your PowerApps DateTime field.

View solution in original post

4 REPLIES 4
iamlee
Level 8

Re: Wrong time after saving into Sharepoint List

have you checked the regional settings of your SharePoint?

Community Support Team
Community Support Team

Re: Wrong time after saving into Sharepoint List

Hi @Iyyanar,

Can you share a bit more about your issue ?

By your saying “not saved correct time in sharepoint list , can you show me details about this ?

 

Please check if Time Zone of sharepoint match with your local Time Zone.

Please check if the date and time format of the field from sharepoint list is correct

 

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Iyyanar
Level: Powered On

Re: Wrong time after saving into Sharepoint List

Thanks for your Reply.

 

We converted date and time value in the format of MM/dd/yyyy hh:mm AM/PM in SQL and populate into PowerApps then assigned to SharePoint list  datet and time field.

 

We accesing PowerApps in IST timezone and SharePoint list field have EST timezone.

For example:

SQL Date and Time value : 12/27/2018 07:00 PM and same value display in PowerApps.

While convert this value into DateTimeValue in PowerApps and assigned to SP date and time field then it saved like

12/27/2018 08:00 PM

Thanks

iamlee
Level 8

Re: Wrong time after saving into Sharepoint List

PowerApps by default will always display in local time. Since you mentioned your time is in EST time, your SharePoint will convert the DateTimeValue from PowerApps. If you don't want the conversion to happen, make your SP field a text field and just post the 'text' value of your PowerApps DateTime field.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,442)