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.

View solution in original post

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

View solution in original post

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (979)