cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Time is saving wrong in Share point

Hello Experts,

 

I have issue with the time, i have 2 types of Date time in my App. when i am choosing and saving form the time saves in wrong format.

for example. These dates are saved from Power App as 

TravelStartDate Time : 25/05/2021 16:28

TravelEndDateTime: 25/05/2021 19:58

 

What saves in Sharepoint list

TravelStartDate Time : 25/05/2021 04:28

TravelEndDateTime: 25/05/2021 07:58

 

My SP column i have formatted as 24 hours still, Also i changed the site settings to my region but  it gets wrong value. please advise so i get the exact value what i chose from Power Apps DateTime drop down.

2 ACCEPTED SOLUTIONS

Accepted Solutions
paherna
Community Support
Community Support

Hi @Anonymous ,

 

It appears that your need is to display the value in SharePoint that comes from Power Apps in 24 HR format. If this is the case, you will need to make a change to the SharePoint site settings.

 

You can do this by going to Site Settings > Regional Information. 

 

At the bottom of the page, change the time format to 24 hour. Please note that this will impact the entire site and not just the list you are working with. 

 

Thanks!
Community Support Team - Paola
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

View solution in original post

Chitrakant27
Resolver II
Resolver II

hi @Anonymous ,

 

follow the procedure 

1. open share point your site name.

2. go on setting and click on-site information.

3. scroll down and then click on view all settings.

4. then click on Regional setting.

5. select time zone as per country and save it.

 

automatic time correct time will show.

 

Chitrakant27_0-1622000298449.png

Thanks 

Chitrakant27

View solution in original post

6 REPLIES 6
paherna
Community Support
Community Support

Hi @Anonymous ,

 

It appears that your need is to display the value in SharePoint that comes from Power Apps in 24 HR format. If this is the case, you will need to make a change to the SharePoint site settings.

 

You can do this by going to Site Settings > Regional Information. 

 

At the bottom of the page, change the time format to 24 hour. Please note that this will impact the entire site and not just the list you are working with. 

 

Thanks!
Community Support Team - Paola
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

Anonymous
Not applicable

Hello @paherna , Thanks for looking into this. i have already change the site settings to 24 hr. please look into below screen shot. 

Capture110.PNG

Chitrakant27
Resolver II
Resolver II

hi @Anonymous ,

 

follow the procedure 

1. open share point your site name.

2. go on setting and click on-site information.

3. scroll down and then click on view all settings.

4. then click on Regional setting.

5. select time zone as per country and save it.

 

automatic time correct time will show.

 

Chitrakant27_0-1622000298449.png

Thanks 

Chitrakant27

Anonymous
Not applicable

Hello @Chitrakant27 , This was also done before but issue still persist. Although my locale setting is below shall i change that too

Capture112.PNG

Chitrakant27
Resolver II
Resolver II

@Anonymous,

It will work kindly change the time zone according to your zone .then after signed out and then sign in.

 

Thanks,

Chitrakant27

Anonymous
Not applicable

Hello @Chitrakant27 , yes it is working after login and log out 2, 3 times. thanks for your help

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,583)