@fmc1
Your formula has a mismatch of columns. You are specifying a value column in the first record and then adding records that have a Result column from the Distinct function. These will not compare.
I would skip the collection for this...It is overkill and adds to performance drags in your app!
If you want a more dynamic way, then set your Items property to:
Ungroup(
Table(
{Items: Table({Result:""}) },
{Items: Sort(Distinct(Master,Dept),Result)}
),
"Items"
)
This will provide an accurate Items property to your control and will add the blank to the Distinct list of the Dept records.
Why this over the collects?
1) It does not drag your app with collections
2) It will be completely dynamic
3) If you even need to maintain the Items property, it will be in one place - no need to see that it is based on a collection and then try to figure out where the collection is set (you cannot search for collections and see where they are defined in PowerApps...so you're left with trying to figure it out on your own)
IF you want to make it more based on the OnStart of the app, then use a Variable NOT a collection. For the main point of number 3 above. You CAN search on Variables, you cannot search on collections.
So, in your OnStart:
Set(glbDepartments,
Ungroup(
Table(
{Items: Table({Result:""}) },
{Items: Sort(Distinct(Master,Dept),Result)}
),
"Items"
)
)
Then change your Items property of the Dropdown to : glbDepartments
At least with that, if you ever need to maintain something about the Items property, you will see it is a variable and can then just look that up to see where it is defined...again, can't do that with a collection!
