date and time is been updated wrong in the sharepoint

[arshad2]

the date and time is been selected by the user but updated in the sharepoint list wrongly, i tried to change the column to text but it is not returning the time as time is very important. please help me to write the update property to get the selected time and date. note: due to organizational setting restriction,  i am unable to change the region settings

[metsshan]

What is the issue with the value being saved in SharePoint? In the screenshot you shared, I can see a time portion.

[arshad2]

the time is not the selected time from the form, when the user selects the time from the form, the updated time is one day and half an hour backward. how can i update the sharepoint with the time and date as exact as the user selected 

@metsshan 

[Akash17]

Hi @arshad2 

Your formula looks correct still you refer

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-patch-date-and-time-from-date-and-tim...

[metsshan]

It is probably related to Regional Settings. You can change these at both Site and User levels, I suggest you look these settings up online, there are a few guides eg: https://www.spguides.com/sharepoint-online-regional-settings 

Let us know if this helps you find the answer. I expect the time zone being used by your PowerApps users is different from the users of SharePoint.

[arshad2]

i also think the same that the time zone is different in the powerapp and sharepoint. unfortunately i dont have access to update the regional setting of sharepoint. is there any other ways?

@metsshan 

[metsshan]

Sorry, I don't think so. Because Date and Time data types are displayed according to timezone settings, if you want to always show the exact date/time a user sees on their screen in PowerApps, I think you would have to store it in a non-DateTime column.

[v-qiaqi-msft · Accepted solution]

Hi @arshad2,

Since you don't have access to the Region settings in your SPO list, I think the only way is to format Date and time column into a new Single-line-of-text column to save the selected date time from Power Apps.

1). Refresh the data source in Power Apps to get the latest column type changes

2). Modify the Update property as below:

Text(DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0),"m/d/yyyy hh:mm AM/PM")