
Announcements
Hi,
When fetching terms from the Term store that contain an ampersand, that term cannot be used to create a new Document Set in SharePoint, because an ampersand is encoded to a non-default hexadecimal value 0xFF06. Therefore I would need to do a replace:
replace([haystack], 0xFF06, '&')
But I have so far not found a working function to convert the hex value into a string that can be used by the replace function. Did anyone already solve this? Thx!
Hi @VincentVH,
Can you share a couple of screenshots how you are retrieving the termset values and how you are creating the document set/updating the metadata of that document set in your Power Automate flow? Is that by any chance via the REST API?
When I am retrieving a term store value from an SharePoint Get item action I will get the MMS column in the following format.
So, I am not seeing any hexadecimal values and I normally use the Value part of it without any encoding.
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
"TermGuid": "58742b76-1756-4c23-b5a1-7e984d15a88b",
"WssId": 6,
"Label": "Contoso & Sports",
"Path": null,
"Value": "Contoso & Sports|58742b76-1756-4c23-b5a1-7e984d15a88b"
}
Btw, have you also tried the following syntax for your replace function?
replace(string(outputs('Compose')), '0xFF06', '&')