Hi @bsamms ,
Yes - actually I have exactly the same process with team staff as our organisation is to large to use the built-in functions.
Your filter will cause a Delegation warning, but should not matter if under 2000 items. Your drop-down will be a Collection
ClearCollect(
YourCollectionName,
Filter(
CaseTracker_AnalystList,
Current=true
)
)
If you want to get no warning, and also Sort, do this
ClearCollect(ColTemp,CaseTracker_AnalystList);
ClearCollect(
YourCollectionName,
Sort(
Filter(
colTemp,
Current=true
),
'A LName'
Ascending
)
);
Clear(colTemp)
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.
