Answered

Invalid Expression When Filtering GetItems

(0) Share

Report

Posted on by 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#.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,828 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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/

Was this reply helpful? Yes No
Verified answer

Redders 546 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
csteiner73 24 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No