Text box Validate To Dropdown

(0) Share

Report

Posted on by Supperpro20

Dear all,

I have a problem with this solution. Can anyone help me, please?

I set up App.OnStart with the Collection:

ClearCollect(NumberDaysOff, "A Day Off", "Two Days Off", "Three Days Off");

I have a label with the name "Total": LbTotal

This label "Total" is a result of calculating how many business days are there between 2 dates (excluding public holidays).

So, the result is 2.

And my idea is when the number on the label is 2. The dropdown with the name will display is "Two Days Off".

Please help me with this.

Thank you all.

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Supperpro20 ,

Firstly, make your NumberOfDaysOff like this - add more if required

ClearCollect( NumberDaysOff, Table( { Value: "A Day Off", Days: 1 }, { Value: "Two Days Off", Days: 2 }, { Value: "Three Days Off", Days: 3 } ) );

Next you will need a List with Public Holidays - I have used Holidays for the List Name and Holiday for the field name containing the holiday date. The value you want would then be (I have used dpLeaveFrom and dpLeaveTo as the Date Picker names)

With( { wDays: RoundDown( DateDiff( dpLeaveFrom.SelectedDate, dpLeaveTo.SelectedDate, Days ) / 7, 0 ) * 5 + Mod( 5 + Weekday(dpLeaveTo.SelectedDate) - Weekday(dpLeaveFrom.SelectedDate), 5 ) - CountIf( Holidays, Holiday >= dpLeaveFrom.SelectedDate, Holiday <= dpLeaveTo.SelectedDate ) + 1 }, LookUp( NumberDaysOff, Days = wDays ).Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Supperpro20 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @WarrenBelz ,
Sorry for the misunderstanding.
My problem is that I want to display Value in Dropdown when the value from the label "Total" appear
I very much appreciate your support. Thank you!

1. I created a collection NumberDaysOff with your instruction:

2. In the Items of Dropdown with the name DropDownFrom. I put the NumberDaysOff.Value

3. The Label with the name LbTotal is calculated

4. I want to display value in DropDownFrom when the label with the name LbTotal is Value
Example :
Total is "1" = DropDownFrom "A Day Off"
Total is "2" = DropDownFrom "Two Days Off"
Total is "3" = DropDownFrom "Three Days Off"
Verified answer

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Supperpro20 ,

All that is required these is

LookUp( NumberDaysOff, Days = Value(YourLabel.Text) ).Value

but to be honest I would repeat the code I posted as relying on calculated labels in a formula is not a good practice.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Supperpro20 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @WarrenBelz ,
I got it. Thank you so much!