cascading drop down inc. destinct and Filter from sharepoint list

(0) Share

Report

Posted on by eisenhauer

hi folks,

i got following problem with this few line of code:

//This is working
ClearCollect(dDBrancheData,{Result:"All"});
Collect(dDBrancheData,Distinct(Application,Branche));
//This is working this collection stays empty 
ClearCollect(dDSegmentData,{Result:"-"});
Collect(dDSegmentData,[Filter(Application, Branche = dDBranche.Selected.Result),Segment)];

but if im using the filter code on item (dropdown) itself it will work.

Filter(Application, Branche = dDBranche.Selected.Result),Segment)

but why its not working in the collection code ?

mybe some on has a clue 🙂

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@eisenhauer

I use a different code for creating the items for dropdown and combobox controls that doesn't involve using collections.

Hat tip to @WarrenBelz and @RandyHayes for the formulas
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Drrickryp

Just an FYI to simplify a little bit...when you are working with one column tables like those from Distinct or Choices, you can shorten the formula for adding the All to:

Ungroup( Table({Items:Table({Result:"ALL"})}, {Items: Sort(Distinct(Table1, state), Result)}), "Items" )

When you need the entire record in the resultant table, I find the Sequence formula to be quicker, but the above can be adapted to do that as well.
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @RandyHayes

Simpler is better!