Forum Discussion
Forms - Build/link choice list with SP Term Store
- Feb 11, 2019
Hi EricDeferm
I've never tried Forms and Flow for the SharePoint Term Store, however I did stumble across this discussion thread and blog that might be useful (or not).
https://flow.microsoft.com/en-us/blog/managed-metadata-tago/
Best wishes and good luck!
Cheers
Damien
Hi EricDeferm
I've never tried Forms and Flow for the SharePoint Term Store, however I did stumble across this discussion thread and blog that might be useful (or not).
https://flow.microsoft.com/en-us/blog/managed-metadata-tago/
Best wishes and good luck!
Cheers
Damien
- EricDefermFeb 12, 2019Iron Contributor
Hi Damien_Rosario tx for directing me the discussion blog article, that was really helpful. I managed to get it working for single value Managed Meta Data fields referencing Term Store sets. Still struggling with multi value MMD fields and the correct syntax.
For a single value MMD field Flow just requires to put the value of the corresponding selected option from the Form (given that Form choice list is composed as follows <value>|GUID. With the correct choice option Flow converts it as follows (for a Form field called Language) --> "Language": { "Value": "Chinese Simplified|7d195f65-0778-41da-a0b9-c44af83c3c0b"}
However for multi value MMD fields, Flow is not converting the syntax to a proper result, for the Country field the following happens --> "Country": [ { "Value": "[\"Argentina|a6b99d64-f5ec-42fe-b41c-95e4d4935e61\",\"Australia|c8f575d4-087e-4838-8324-1298f0c14cdcArgentina\"]" } ],
Whereas the correct syntax (when assigning values in Flow it self) looks like this
"Country": [
{ "Value": "Argentina|a6b99d64-f5ec-42fe-b41c-95e4d4935e61" } ,
{ "Value" : "Australia|c8f575d4-087e-4838-8324-1298f0c14cdc" }
],
Will continue the quest for 'clean' syntax.
- EricDefermFeb 22, 2019Iron Contributor
I've found an easier way to assign Managed Metadata Fields in Flow. Using the hidden list https://<tenant>.sharepoint.com/TaxonomyHiddenList you can lookup the corresponding term store key via the 'Title' column. Next step > assign the value by combining the Label (plain text) and IdForTerm separated by the '|' (pipe).
- eliotcole-projectfiveOct 23, 2019Brass Contributor
EricDeferm ... dang ... looks like that list has been hidden a bit better now!
Ah!
After a day's work (not just on this!!) I have found it.
It's now here:
`[siteURL]/Lists/TaxonomyHiddenList`