Loop through Choices to build a list for dropdown items

(0) Share

Report

Posted on by Tina Chen

Hi,

This sounds simple, but i can't seems to figure out an efficient way to achieve this.

The scenario is simple. I have a Department Choice. I want all the choices to be the items of a dropdown control so the page can filter data based on the department dropdown filter. This is easy. But what i want is an extra "Select All" option in this list of items so the page's default choice is "Select All" and no data gets filtered initially.

Here is my attempt to achieve what i descriped above. This code is incorrect, but hope you get my idea.

 Collect(colDepartmentOptions, { Name: "--All--", Value: 0 });
 ForAll(Filter(Choices(Department), Value >= 5 && Value <=11) As d, 
 Collect(colDepartmentOptions, { Name: d.Label, Value: d.Value })
 );

Thanks for your help!

Categories:

General Questions