cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenVdP
Helper II
Helper II

Changing data type of datepicker control

Hi,

 

I'm having a working solution that is actively used by my employees. Now I have to make an adjustment so people can register thei workload based on hours instead of full days.

 

So I in SharePoint I changed the Date Picker from 'Date Only' to 'Date and Time', which gives the result I want in the SharePoint list.

Now when editing the Power App, the Date Picker control does not update from 'Date Only' to 'Date and Time'.

 

I already tried to refresh the data connection, removing and adding the field back to the edit form, but all without succes.

 

Does anyone has a solution for this?

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@BenVdP 

What you did should work.  Just as a test: what happens if you create a new Edit Form?  Does the time control appear?  If yes, you could cut and paste from the new edit form and change the formula references in your existing form.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

5 REPLIES 5
mdevaney
Super User
Super User

@BenVdP 

What you did should work.  Just as a test: what happens if you create a new Edit Form?  Does the time control appear?  If yes, you could cut and paste from the new edit form and change the formula references in your existing form.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

@mdevaney  when I create a new EditForm the control appears correctly. I'll give it a try what you are suggesting, if it works, I'll mark your answer as the solution.

@mdevaney it does work as you say. 

But it is far from ideal to have to update my app like this...

@BenVdP 
Your original method always works for me.  Not sure what happened in your case, but at least you have a fix 😉

Let's just chalk this one up to some kind of glitch

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

I got it to work. 🙂

 

I removed the datepicker controls, I saved and republished the form. I re-added the controls and *pooooof* they are added as 'Date and Time' controls.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,668)