Power Platform Community Forum Thread Details

I have a dropdown that I would like to take names from a sharepoint database "automated test roster" based off of 4 nested dropdowns using and/or logic. this if what I have that works for three dropdowns.

And(
!IsBlank('Loc Dropdown_5'.Selected.Result),
!IsBlank('Rank Dropdown_7'.Selected.Result),
!IsBlank('Domain Drop'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Location = 'Loc Dropdown_5'.Selected.Result,
Rank = 'Rank Dropdown_7'.Selected.Result,
'Domain Level' = 'Domain Drop'.Selected.Result
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
If(
And(
!IsBlank('Loc Dropdown_5'.Selected.Result),
!IsBlank('Rank Dropdown_7'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Location = 'Loc Dropdown_5'.Selected.Result,
Rank = 'Rank Dropdown_7'.Selected.Result,
IsBlank('Domain Drop'.Selected.Result) || 'Domain Level' = 'Domain Drop'.Selected.Result
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
If(
!IsBlank('Domain Drop'.Selected.Result),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
IsBlank('Loc Dropdown_5'.Selected.Result) || Location = 'Loc Dropdown_5'.Selected.Result,
IsBlank('Rank Dropdown_7'.Selected.Result) || Rank = 'Rank Dropdown_7'.Selected.Result,
'Domain Level' = 'Domain Drop'.Selected.Result
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
ForAll(
Distinct(Automate_Roster_Test, ColleagueName_Hide),
{Result: ThisRecord.Value}
)
)
)
)

When I try to add the 4th (below) I only get a blank selection. Here's what I have That doesn't work

If(
And(
!IsBlank('Loc Dropdown_5'.Selected.Result),
!IsBlank('Rank Dropdown_7'.Selected.Result),
!IsBlank('Domain Drop'.Selected.Result),
!IsBlank('Engagement Drop'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Location = 'Loc Dropdown_5'.Selected.Result,
Rank = 'Rank Dropdown_7'.Selected.Result,
'Domain Level' = 'Domain Drop'.Selected.Result,
'TSD BCM Engagement Teams'='Engagement Drop'.Selected.Result
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
If(
And(
!IsBlank('Loc Dropdown_5'.Selected.Result),
!IsBlank('Rank Dropdown_7'.Selected.Result),
!IsBlank('Domain Drop'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Location = 'Loc Dropdown_5'.Selected.Result,
Rank = 'Rank Dropdown_7'.Selected.Result,
'Domain Level'='Domain Drop'.Selected.Result,
IsBlank('Engagement Drop'.Selected.Result) || 'TSD BCM Engagement Teams' = 'Engagement Drop'.Selected.Result
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
If(
And(
!IsBlank('Loc Dropdown_5'.Selected.Result),
!IsBlank('Rank Dropdown_7'.Selected.Result),
!IsBlank('Engagement Drop'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Location = 'Loc Dropdown_5'.Selected.Result,
Rank = 'Rank Dropdown_7'.Selected.Result,
'TSD BCM Engagement Teams' = 'Engagement Drop'.Selected.Result
IsBlank('Domain Drop'.Selected.Result) || 'Domain Level' = 'Domain Drop'.Selected.Result,
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
If(
And(
!IsBlank('Loc Dropdown_5'.Selected.Result),
!IsBlank('Domain Drop'.Selected.Result),
!IsBlank('Engagement Drop'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Location = 'Loc Dropdown_5'.Selected.Result,
'Domain Level' = 'Domain Drop'.Selected.Result,
'TSD BCM Engagement Teams' = 'Engagement Drop'.Selected.Result,
IsBlank('Rank Dropdown_7'.Selected.Result) || Rank = 'Rank Dropdown_7'.Selected.Result,
),
ColleagueName_Hide
),
{Result: ThisRecord.Value}
),
If(
And(
!IsBlank('Rank Dropdown_7'.Selected.Result),
!IsBlank('Domain Drop'.Selected.Result),
!IsBlank('Engagement Drop'.Selected.Result)
),
ForAll(
Distinct(
Filter(
Automate_Roster_Test,
Rank = 'Rank Dropdown_7'.Selected.Result,
'Domain Level' = 'Domain Drop'.Selected.Result,
'TSD BCM Engagement Teams' = 'Engagement Drop'.Selected.Result,
IsBlank('Loc Dropdown_5'.Selected.Result) || Location = 'Loc Dropdown_5'.Selected.Result,
),
ColleagueName_Hide
),
{Result: ThisRecord.Value},
ForAll(
Distinct(Automate_Roster_Test, ColleagueName_Hide),
{Result: ThisRecord.Value}
)
)
)
)

Sorry for the large insert, but if someone could help me with where I'm going wrong that would be appreciated

Categories:

Building Power Apps

Hi @BenSt ,

Firstly you do not need all of that code

Distinct(
 Filter(
 Automate_Roster_Test,
 (
 Len('Loc Dropdown_5'.Selected.Result) = 0 ||
 Location = 'Loc Dropdown_5'.Selected.Result
 ) &&
 (
 Len('Rank Dropdown_7'.Selected.Result) = 0 ||
 Rank = 'Rank Dropdown_7'.Selected.Result
 ) &&
 (
 Len('Domain Drop'.Selected.Result) = 0 ||
 'Domain Level' = 'Domain Drop'.Selected.Result
 ) &&
 (
 Len('Engagement Drop'.Selected.Result) = 0 ||
 'TSD BCM Engagement Teams' = 'Engagement Drop'.Selected.Result
 )
 ),
 ColleagueName_Hide
)

I also suggest you try and get rid of that "workaround" distinct code that MS imposed when the Distinct output changed to .Value = just use Distinct(whatever) and the output will be .Value (as per the code above).

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