web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Converting hexadecimal...

Power Automate

Answered

Converting hexadecimal values to strings

(0) Share

Report

Report

Posted on by VincentVH

27

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!

Categories:

I have the same question (1)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,746 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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', '&')

Was this reply helpful? Yes No

Join the conversation