cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VincentVH
Frequent Visitor

Converting hexadecimal values to strings

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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

 

View solution in original post

1 REPLY 1
Expiscornovus
Super User
Super User

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

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,511)