SharePoint column starting with capital F converted to _x0046_

Recently in a document library in SharePoint Online I have created a Choice column called FYQ1.

I have noticed that the internal field name for the column FYQ01 is Field=_x0046_YQ01

In Power Automate I have a "Get Items" action with the Filter Query _x0046_YQ01 eq 'Completed'



When I run the flow I get the following error" Column '_x0046_YQ01' does not exist. It may have been deleted by another user.

I was able to resolve this issue by viewing the row data in the browser by pasting the following URL in the address bar

http://<YOUR SITE URL>/_api/Web/Lists/GetByTitle('YOUR LIST NAME')/items

The row data returned the following field name:

<d:OData__x0046_YQ01>Completed</d:OData__x0046_YQ01>

I have updated the Filter Query to: OData__x0046_YQ01 eq 'Completed' and the Power Automate executed successfully.

Final thoughts

I am not sure of the reason why or the logic when SharePoint converts the capital F to _x0046_

For example I have created a column called FYAQ1 and the internal field name is Field=FYAQ1 so the capital F is not transformed to _x0046_

If you know the reason why SharePoint converts the capital F to _x0046_ please post it in the comments below.

About the author

Giorgio Capisani

I am an experienced IT professional specialising in Microsoft technologies (SharePoint 2010/2013/Online, Power Platform, Office 365), with over 10 years of experience in large public and private sector organisations.