Customise options in a Combo Box based on other selection. IF function to Change column filtering?

[PipManifold]

Hi there,

I’m trying a to program a combo box to display differently depending on a selected value, at the moment this is 4 buttons which update a hidden text field using a variable.

The user comes into the app and is asked how they grouped the task.

My options are School, Discipline, Program, Course

They select the option, it shows all the remaining appropriate fields and updates the Variable to either school, discipline, program or course depending on which button was selected:

If they select School, I want the ‘Program/s’ combo box to default select all the programs in that school and the drop down items to show all the programs in that school.

If they select Discipline, I want the combo box to default select all the programs in that discipline and the drop down items to show all the programs in that discipline (this will be a narrower subset, filtered based on the discipline rather than school column in my SharePoint list).

If they select program or course, I want it to default to no items selected and in the dropdown shows all the programs in the Discipline selected.

I figure I need to program the DefaultSelectedItems and the Items properties using an IF function, but having issues.

Starting with the Items property (because I hope the DefaultSelectedItems will be amending this function) I started with my general items filter function:

Sort(Distinct(Filter('Program contact list',Discipline=CAC_Discipline_String.Text).'Program code','Program code'),Ascending)

And tried to incorporate it into an IF function, however, it doesn’t like the text value of my variable and wants a table value: This is what I tried as my initial argument for discipline but erroring out

If(CAC_SubmissionType_Variable.Value="Discipline",Sort(Distinct(Filter('Program contact list',Discipline=CAC_Discipline_String.Text).Programcode,Programcode),Ascending),"")

Any help would be amazing!

[StalinPonnusamy]

You have to use array to select "DefaultSelectedItems" property like below example. In this example, combobox selection is varies based on the button click. Please change for your use cases.

[PipManifold]

Hi @StalinPonnusamy 

Thanks for your reply.

Unfortunately I'm having trouble implementing this.

I want to filter my program comb box items by the discipline selected, except for in the case that School is selected, in that case I want to filter the programs by the school selected. I'm not sure I'm reading your formula correctly however, it looks like in the 'yes' evaluable you are specifying a table of records containing the values "Consultant" and "Investor" and in the 'else' you are showing compeditor.  I can create a table of record which contain the values selected in the dropdowns for School and Program, however, how do I get it to spit out all the values in my Program column. At the moment it's only returning the Discipline value.

 

[StalinPonnusamy]

Looks like you are looking for a dependent dropdown list. Please refer to this MS Article

URL : https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/dependent-drop-down-lists

[PipManifold]

Thanks for the @StalinPonnusamy .

I started of with a dependant dropdown.  My aim is to customise it further by seeing if I can get it to switch between different dependant dropdown functions depending on the button pressed using the If function.

Something along the lines of 

For Items property:

If(ButtonSelected="School",    (argument)

Sort(Filter('Program contact list',School=CAC_School_String.Text).'Program code','Program code',Ascending),    (if true)

Sort(Filter('Program contact list',Discipline =CAC_Discipline_String.Text).'Program code','Program code',Ascending)) (if false)

For DefaultSelectedItems:

If(
ButtonSelected="School",Sort(Filter('Program contact list',School=CAC_School_String.Text).'Program code','Program code',Ascending),    (Condition 1)
ButtonSelected="Discipline",Sort(Filter('Program contact list',Discipline =CAC_Discipline_String.Text).'Program code','Program code',Ascending),   (Condition 2)
"")    (If no conditions are met)

However, as soon as I bring the If function in to try and join these options it says it can do Text and Table formats in the same function.

[PipManifold · Accepted solution]

Hi @StalinPonnusamy. Thanks so much for your help.

I think I've worked it out. Needed to look at it from a different perspective.

I can set up each of my different functions as a variable on each button and when the button is clicked the variable updates with the appropriate function. No need to try and stitch them together with an If function.