cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Continued Contributor
Continued Contributor

Collection from SharePoint List with Managed Metadata columns

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"}))

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Here is a formula that works for me:

 

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


--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Here is a formula that works for me:

 

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


--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

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!

 

 

Highlighted

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.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,807)