Collection from SharePoint List with Managed Metadata columns

[tianaranjo]

Greetings,

I am wanting to create a collection referencing the indexed column (WorkYear) of a SP list and would like to include "* All" in the collection (to be used in a filter dropdown).  The formulas I have tried are below.  This is collecting the work years; however, "* All" is not being added to the collection.  The WorkYear column in SharePoint is a single line of text field, not date or numeric.

Formula1
ClearCollect(
    colWorkYear, 
        Distinct(
            SharePointListName.Work_x0020_Year,Work_x0020_Year),
    Collect(
        colWorkYear,
            {Result: "* All"}))

Formula2:

ClearCollect(
    colWorkYear, 
        Distinct(
            SharePointListName.Work_x0020_Year),
    Collect(
        colWorkYear,
            {Result: "* All"}))

[Jeff_Thorpe · Accepted solution]

Here is a formula that works for me:

ClearCollect(colWorkYear, Distinct(SharePointListName, Work_x0020_Year));
Collect(colWorkYear, {Result:"* All"})

[tianaranjo]

Thanks @Jeff_Thorpe - missed it by that much :).  

Your solution works great. 

Is it basically one in the same to reference an SP index and SharePoint column? 

Thanks!

[Jeff_Thorpe]

Is SP Index is referring to index columns in a list? In general not all columns are index in a list and they don't need to be in order to use them in PowerApps. For larger lists where you are going to be using filter/lookup functions then you might want to index the columns that are being used in the filter/lookup to help with performance and the list view threshold if the list is over 5k items.