cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Date and Time Update to Sharepoint Resetting Time Dropdown

I have an app created from a sharepoint list where I am using my browse gallery to update the list with a date picker and time dropdown.  I have the date picker and dropdown in my browse gallery.  I was trying to keep it here instead of in the edit screen for ease of use.

 

I have the Update of my data card on my edit screen set to the following.

DatePicker2.SelectedDate + Time(Value(HourDropdown.Selected.Value), 0, 0)

 

When I submit my edit form using submitform function the HourDropdown resets to a Default Value of 1 and updates my sharepoint list to 1 am instead of the Value I picked.  I have tried to set my Default on the dropdown to false or blank but it didnt work.  Is there a way to prevent it from resetting?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Date and Time Update to Sharepoint Resetting Time Dropdown

I solved by setting my Default on my dropdown list as the following.

 

Hour(DateTimeValue(ThisItem.act_start_date))

 

Where "act_start_date" is my sharepoint column

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Date and Time Update to Sharepoint Resetting Time Dropdown

I solved by setting my Default on my dropdown list as the following.

 

Hour(DateTimeValue(ThisItem.act_start_date))

 

Where "act_start_date" is my sharepoint column

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,459)