Cascading Filter from Sharepoint choice Column

[suman4apr]

Hi,

I have two choice filter which contains value.

Now I'm trying to make it cascading in Powerapp form but Unable to get this done.

Here I have added screen shot of these two filter. 

Please take a look and guide me to get it resolved.

Above image is choice column which I have created in Sharepoint and using sharepoint list choice column, I'm creating form in Powerapps.

Below is first choice filter their Item Property.

Below is second filter and their Item Property.

I have gone through many thread like this https://powerusers.microsoft.com/t5/Building-Power-Apps/Cascading-dropdown-with-SharePoint-Choice-co... ffor solution but IN every thread, People are using dropdown1 in formula but I don't have any dropdown in my form. Either I have combobox or datacard but no dropdown. You can see in below Image.

I simply  want that If I select anything in filter one then second filter should give value only related to first filter.

Thanks in Advance!

[WarrenBelz]

Hi @suman4apr ,

I will use names in Blue - replace them with our own names.

What you are asking is that the choice from DropDown RiskLevel1 on field EnterpriseRiskLevel1 (I will also use .Value - change if incorrect), which is part of the data set RiskList filters the choices of RiskLevel2 DropDown. EnterpriseRiskLevel2 is the second field.

Try this in the Items property of RiskLevel2

Filter(
   RiskList,
   EnterpriseRiskLevel1 = RiskLevel1.Selected.Value
   )
.EnterpriseRiskLevel2

I am assuming here that the second drop-down has its own values, but only show those that match the first choice selected.

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.

[suman4apr]

What is RiskList and RiskLevel1 in Below formula ?

my sharepoint list file name is IA_CAPD which contains two choice column called Enterprise Risk Level-1 and Enterprise Risk Level-2

And as It is combobox so It is not accepting .Value

Filter(
   RiskList,
   EnterpriseRiskLevel1 = RiskLevel1.Selected.Value
   )
.EnterpriseRiskLevel2

Can you please replace my column name and data file name in your above formula?

[suman4apr]

Here I have tried your formula but It is not accepting. Below is screen shot.

It is giving error at two place. One is while putting =(Is Equal to) and second error while using .(Full stop) before Value.

FYI, This is choice column not normal dropdown. Please see my main post where I have added screen shot of choice column from list.

Filter(
Table_query__1,
EnterpriseRiskLevel1 = EnterpriseRiskLevel1.Selected.Value
)
.EnterpriseRiskLevel2

[WarrenBelz]

OK @suman4apr ,

I do not have the names of the ComboBoxes, so I will call them Combo1 and Combo2. Firstly, the .Value could be .Result if a Distinct filter or .FieldName (the actual name) if from a filtered list. The easiest way to find out is when you type Combo1.Selected. you should see the valid choices in a box just below. If you cannot see this, please provide the Items property of Combo1.

Try this in the Items property of Combo2. 

Filter(
   IA_CAPD,
   'Enterprise Risk Level-1' = Combo1.Selected.Value   //change the .Value to the valid text
   )
.'Enterprise Risk Level-2'

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.

[WarrenBelz]

HI @suman4apr ,

You need the combobox name before .Selected.Value

[suman4apr]

I have used combobox name before .selected.value. Please see below.

Above image is of Enterprise Risk Level-1 and it's combobox name is DataCardvalue13

And Same name I used in Enterprise Risk Level-2 filter's Item property. You can see in right side highlighted formula bar or item property.

Filter(
IA_CAPD, 'Enterprise Risk Level-1' = DataCardValue13.Selected.Value
)
.'Enterprise Risk Level-2'

[WarrenBelz]

Hi @suman4apr ,

I will try to go another way as there is something not clear here.

I have done an actual example of this on a SharePoint list I have called Crew. The Crew members have a Type - which is actually their job role.

So the first DropDown is called ddType and has the Items Property

Distinct(Crew,Type)

It produces a crew Type list as below.

The second DropDown shows the filtered FullName all crew names of that Type. The Items property of this is

Filter(Crew,Type = ddType.Selected.Result).FullName

It produces as full list of all crew names belonging to that Type

Are you able to relate this structure to what you have ? All fields in the data set are text.

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.