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

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (2)

Report
@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.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

Thanks @RandyHayes

Simpler is better!

Was this reply helpful? Yes No