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
Advocate I
Advocate I

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
Advocate I
Advocate I

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
Advocate I
Advocate I

@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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,311)