Power Apps Patch Date from DatePicker WITHOUT Time

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I have a requirement in Power Apps to patch the date picker column without time in SharePoint.

I have a SharePoint list [Product Transaction Details]; this list has a Date column [Product Supplied Date], including time.

Now, I have added an Edit form connected with the above SharePoint list on my Power Apps screen. This form has a Date picker control, and also with a dropdown of hours and minutes.

Whenever the user provides the date and time in the edit form and clicks on the Button control.

The SharePoint list should take only the date rather than the time.

For that, On the Button control -> Set its OnSelect property as:

Patch(
 'Product Transaction Details',
 Defaults('Product Transaction Details'),
 {
 Title: DataCardKey12.Text,
 'Supplied Product': DataCardValue13.Selected,
 'Is Paid Or Not': DataCardValue15.Value,
 'Product Supplied Date': DateValue(
 DateValue1.SelectedDate - TimeZoneOffset(),
 "en-US"
 )
 }
)

But still, Its taking a random time. But I must patch only the date without time in the SharePoint list.

Can anyone please suggest how I can resolve this? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Hemashree ,

Try and use

DateAdd(DateValue1.SelectedDate , TimeZoneOffset(), TimeUnit.Minutes)

instead of

DateValue( DateValue1.SelectedDate - TimeZoneOffset(), "en-US" )

Best regards,

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-jefferni

As you suggested, I tried the same formula in my Patch function and the Update property of the Date field.
But still, it's taking a time value in the SharePoint list randomly.

Please suggest me how I can resolve this.

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

Like (0)

Report
Copy link

Link copied!

Hi @Hemashree ,

Sorry, I think what you need should be:

DateAdd(DateValue1.SelectedDate , -TimeZoneOffset(), TimeUnit.Minutes)

Best regards,

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-jefferni

I tried this formula before, but still it's taking a random time.
Patch( 'Product Transaction Details', Defaults('Product Transaction Details'), { Title: DataCardValue12.Text, 'Supplied Product': DataCardValue13.Selected, 'Is Paid Or Not': DataCardValue15.Value, 'Product Supplied Date': DateAdd( DateValue1.SelectedDate, -TimeZoneOffset(), TimeUnit.Minutes ) } )

Please help to resolve this.

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

Like (0)

Report
Copy link

Link copied!

Hi @Hemashree ,

What actual content would you like this field to display, is it 2/12/2024 12:00AM?

Best regards,

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

When the user submits the form, In my SharePoint list, I need to display only date like 2/12/2024.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Hemashree ,

Since the date and time column is set to include time, it's not possible. I think you should use a Single line of Text column instead.

Best regards,

Was this reply helpful? Yes No