Dropdown values comparison in powerapps.

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

In my app i need to compare End time is greater than Start time.

Following is my scenario,

Start Time : End Time :

Now i need to compare this two dropdown values.

If start time is less than End Time i need to display Notify msg.

If(Value(Concatenate(start.Value,":",minute.Value))<Value(Concatenate(End.Value,":",minute1.Value)),Notify("To Hour must be gretaer than Starting Hour",NotificationType.Warning)).

Is this correct?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Digital 1,207 on at

Like (1)

Report
Hi @Dhinesh28R ,

Put this in your startHour Items property:
RenameColumns(DropColumns(AddColumns(Sequence(25,0),"DateText",Text(Value,"00")),"Value"),"DateText","Value")

And this in the startMin Items property:
RenameColumns(DropColumns(AddColumns(Sequence(59,0),"DateText",Text(Value,"00")),"Value"),"DateText","Value")

Repeat for your endHour and endMin Items.

You can convert the selected values to date type using DateTimeValue and compare them using DateDiff

For my test condition I have output a text box but you could use this condition in the visible property of a label, or to trigger an alert.
If( DateDiff( DateTimeValue(startHour.Selected.Value & ":" & startMin.Selected.Value), DateTimeValue(endHour.Selected.Value & ":" & endMin.Selected.Value),Minutes ) <0, "Alert! Start time is less that end time", "Start time is greater than end time" )

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@Dhinesh28R,

Use time function like:

Time(startHourDropDown.Selected.Value, startMinutesDropDown.Selected.Value,0)

and then compare the two values.

Hope it helps !

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like (0)

Report

Hi @gabibalaban,
After converting and then Compare Now its working man.

Thanks.

Was this reply helpful? Yes No