Unanswered

I can't choose a date and time with Hour Picker and Date Picker

(0) Share

Report

Posted on by s44

691

Hello, I am creating a schedule on Power Apps and I would like that when choosing a date and time on the right, it adds the event to the schedule. However I have a problem. The problem is that no matter what date and time you choose, the event will always appear in the schedule at "07/20/2022 at 6:00 p.m.".
Can you help me solve this problem please? Thanks in advance 😞

My SharePoint list (datasource) :

DateArrivee --> Date formant

Usine --> text format

Heure --> text format

Categories:

Using Apps Using Formulas

All responses (27)

Answers (0)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

If your column is not selected to DateTime please do update it to dateTime otherwise the formula won't work.
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (1)

Report
Re: I can't choose a date and time with Hour Picker and Date Picker

@s44

You have to mention the selected value of the dropdown. In our case it should be something like below.

HourValue1.Selected.Value & MinuteValue1.Selected.Value If you have used any other column instead of Value try adding that column name.
s44 691 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

I used this method to be able to display the time and date differently on my schedule, because I didn't know how to do with a "Date and Time" field @SBax
SBax 1,348 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

I think this is the route of your problem. Is there a reason you need two fields?

If there is no reason not to, would reccomend using one field with the configuration I showed in my last message, as it works as expected using this method (with no modifications to the form in any way)
s44 691 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

I use a "Date" field for the date, and a "Text" field for the time :0 @SBax
s44 691 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

It's already doesn't work 😞 @PriyankaGeethik
s44 691 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

It is as it appeared during creation :// @SBax
SBax 1,348 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

@s44- are you using one field of type date and time (with "include time") selected, or two fields (i.e. one for date, another for time)
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

@s44

YourHourValue and YourMinutesValue are just placeholders you have to add your dropdown values in there. YourHourValue -> add your hour dropdown value and YourMinutesValue -> add your minutes dropdown value.
s44 691 on at

Like (0)

Report

Re: I can't choose a date and time with Hour Picker and Date Picker

I have this error message :c @PriyankaGeethik