Invalid Expression When Filtering GetItems

[csteiner73]

I'm building a Flow to run from a PowerApps.  I was running into issues with a simple filter query, so I broke this part off into a separate flow as a sanity check.  When I run my Flow I get an invalid expression.  What am I doing wrong?

List Name=Equipment

Column Name = PO#

OData Filter= PO# eq 'PO' (Dynamic Content from the input)

I'm trying to return a set of values from other columns in the list based on the input of PO#.

[Expiscornovus]

Hi @csteiner73,

It is very likely that the # is encoded in the internal field name.

Can you try this instead:

PO_x0023_ eq '@{triggerBody()['text']}'

A list of these encoding characters can be found on for example @Paulie78 his blog:

https://www.tachytelic.net/2021/06/encode-sharepoint-column-names-to-internal/

[Redders · Accepted solution]

Try switching experimental features on to see if you can select the column name that way, it might highlight a different issue?

Go to Settings cog, (top right) > View all power automate settings

Then switch on experimental features

What that will do will allow you to select the column within your list

[csteiner73]

Yup this did it.  Turns out the display name of the column (PO#) was different than the actual name of the column (po).  Thankas a ton everyone!