Forum Discussion

i4th8's avatar
i4th8
Copper Contributor
Jul 31, 2024

Character encoding in field names when working with power automate

This morning, I ran into an issue that I thought that someone else out there might run into. If you have a field name for example "SSL2" SharePoint is going to encode that field name with something like "_x0053_SL2" you can see this name in the end of the URL when you open the list settings, then select that column. However, if you then try to use this field name in an OData filter you will get an error that the column does not exist. I was able to figure out that the field name when you are trying to access that field in the OData filter is "OData__x0053_SL2". I was able to figure this out by creating a step that called Get Items without a filter then I checked the data that was returned. 

 

Hope this helps someone!

  • Jon_Lake's avatar
    Jon_Lake
    Brass Contributor

    Hi i4th8 , I found this useful explanation:

    "Essentially SSL2 is being encoded to _x0053_SL2 because it resembles an "A1 mode" excel cell reference ([a-zA-Z]{1,3}[0-9]{1,5}). When Sharepoint sees one of those it decides it needs to encode the first character."

     

    Here is the full conversation.

Resources