Forum Discussion
Set values for Managed Metadata (aka Taxonomy) columns in PowerApps and Flow! (First Release)
I'm really struggling with two items related to Managed Metadata:
Currently the PowerApp works fine:
It uses a SharePoint list data source that includes a Yes/No column named "Highlight"
Scenario A - makes a star visible if this column = true
If(Highlight=true,true,false)
Scenario B - filters the list to only show items where this column = true
Filter(Events
,EndDate>Now()
And
Highlight=true
)
I am changing the data source column to Managed Metadata.
The Term Set has 2 Terms in it: Highlight, Don't Highlight.
The column name is "Highlight_x0020_Indicator"
There's a few reasons I'm making this change, here's a couple of them.
- SharePoint's Highlighted Content Web Part provides more flexibility with MMD over boolean.
- Deliver a consistent column set-up across my full SP ecosystem with Universal Site Columns and Content Types
- I'll be using this approach everywhere to call-out important news, events, documents, etc., and MMD gives me me more flexibility for changes in the future.
For the life of me, I can't figure out how to make the PowertApp scenarios work properly when the source is MMD over boolean. It is probably some simple trick required when working with MMD and PowerApps.
Does anyone have ideas here?
Thanks in advance.
I figured this out, and thought I'd post the solution in case it can help anyone else.
If you want to use a Managed Metadata column from a SharePoint list to filter data in PowerApps, you cannot use the field natively, like you would a normal S/P field. You must use the GUID of the term.
Through the exercise of figuring this out, I discovered, there’s a hidden list that you can get all sorts of details about Terms, including their GUID. In the past I've created a bogus Flow to pull GUID details. Using this hidden list is so much easier! (Note that you must have used the term in on the site for it to show-up in the list)
Path for hidden list:
…../Lists/TaxonomyHiddenList/AllItems.aspx