When you use Get Items to return a sharepoint item with an MMS field, the lable displays differently as follows:
a) If you have selected display "Display the entire path to the term in the field" and "Allow multiple values" is true then the full path is returned in the label field.
b) If you have selected display "Display the entire path to the term in the field" and "Allow multiple values" is false then the full path is returned in the label field.
On a side note, it would be nice if the "path" showed up in path in stead of it being null.
Could you please share a screenshot of your flow's configuration?
Could you please show a bit more about the MMS field that you mentioned? Is it a Managed Metadata type column?
Thanks for your feedback, the issue is confirmed on my side. Showing full path (Path property) of a Managed Metadata field value of SharePoint list is not supported in Microsoft Flow currently.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
Thanks for your reply. It would be hard for me to get all the screen shots around the system but I can give you a text export from the flow body (this is an excerpt from the get items body visible after a flow has been run).
When I use a "get items" action with no special settings against a list and examine the body I get this JSON as an example.
"Label": "CPD - Lead",
"Value": "CPD - Lead - Lead|1234-1234-1234-12341234-1234-1342"
Things to note: "Path" is null. Seems like this should have the path in it.
Second thing: If the SharePoint Managed Metadata Column setting of "Display the entire path to the term in the field" is selected and the column is set to allow multiple values. The Label in the retruned JSON (see above) will look like this:
"Label": "Level1:Level2:Level3:CPD - Lead"
If the column is not set to not allow multiple values, then the Lable looks like it does above ("Label": "CPD - Lead"). It would be nice if we got consitent behavori of allways showing the full path in the label if that display option is selected. Is that enough to go on and is that a "new idea" or just a bug?
It seems like the behavior on this changed in the last few days. Now the full path is never displayed in the label and the "Path" remains null. This is a bit disapointing as it broke an entire appliction I was putting together based on being able to access that path info on the label. Any insight on this would be greatly appreacted. It would be amazing if the path started appearing in path.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!