Unanswered

Date and time saving earlier ( past date )

(0) Share

Report

Posted on by muralikrishna00

Hi every one, running with a issue:

Actually as per business user will select only one date field, but selected date and time has to update/Set in to another date and time field.

so,

Patching Date and time field value in to another date and time field.

{

Title: DataCardValue4.Text,
CopiedDate:(DateValue2.SelectedDate)+Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value),0)

}

CoipedDate is the target field in SP, this need to update from another, so assigning here directly source date time DateCardsValues

With the above code working fine but issue is, it saves one day earlier.

Example:

Source: Selecting Date and Time:	Target: Showing date and time value	Status
12/12/2019 00:00 AM	12/12/2019 00:00 AM	expected(Fine)
12/12/2019 12:00 PM	12/12/2019 12:00 PM	expected(Fine)
12/12/2019 23:30 PM	11/12/2019 12:30 PM	Not expected, saving one day earlier(past).

From 00:00 AM to 23:29 PM (Hours 29 minutes) its saving fine in SharePoint.

but if we save from 23:30 PM to 23:59 PM its saving one day earlier with same time.

as we see 3rd item saving with earlier (past) date.

Really don`t understand what`s wrong here to saving with earlier date.

Configurations:

1.SharePoint regional settings in (UTC+10:00)Brisbane //as per business

2.DateTimeZone in Powerapps : DateTimeZone.Local

how to save with selected day with same time ...?

If anyone can help me, it would be very appreciated.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @muralikrishna00 ,
I have test from my side, but don't have the issue you mentioned.
In my test, I set the time zone and region of SP site as image below, use your patch formula and the data time is patched correctly.

Please check my test, and create a new app to try again.
If this doesn't work, please share the screenshots of SP site regional setting and Advance setting of PowerApps.
Best regards,
Sik

Was this reply helpful? Yes No
muralikrishna00 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,
first of all thank you for your reply and POC.

1. I can able to patch but don`t understand how to get rid of this 4:30 on newly created item.
i am just selecting only date the it should play 12/12/2019 00:00. instead it is displaying 12/12/2019 4:30

Earlier Date Time Zone is in Local in powerapps , i just switched to UTC then its saving with 12/12/2019 10:00 its again wrong.

How to sync time between powerapps and SharePoint. item are showing different times.
example if only date selected then it should display 00:00 instead its displaying 4:30.

2. As you requested please find below screen shot image from regional settings page. this should be same we should not change from this page.
Regional settings page

Date field Advanced settings screen shot from PowerApps .
PowerApps Date field Advanced settings page

I am awaiting fro your support/help.
Thanks,

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @muralikrishna00 ,

Please try to change DateTimeZone of date picker control to DateTimeZone.Local.
BR,
Sik

Was this reply helpful? Yes No
muralikrishna00 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,
I tried with both Local and UTC.
With Local
submitted Displaying value
12/12/2019 00:00 12/12/2019 4:30
13/12/2019 01:00 13/12/2019 5:30
With UTC
submitted Displaying value
03/12/2019 00:00 04/12/2019 4:30
13/12/2019 01:00 13/12/2019 5:30
if possible can we have screen session please ..?
No change in regional settings (UTC+10 Brisbane)
in our case is can we use Converting to UTC or Convert from UTC how it will be useful if yes kindly share with screen shot how/where to use these function conversion functions.

MK

Was this reply helpful? Yes No