Get Items Filter Query Error

[TraceyLoo]

I'm trying to use the Get Items Filter Query on a Column in my SharePoint list other than the Title index column and receive the expression is not valid for any column except for Title.   

[RobElliott]

Check that the internal name of the Req# column is correct as it has the # symbol so SharePoint might be changing it. Go to the List settings open the column and check what's after Field= and use that intyneral name in the filter query.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[TraceyLoo]

Hi Rob,

Thanks for the response.   I'm not sure where to find the Field = within the column edit; here is what I see: 

[TraceyLoo]

I've also tested using other fields without a # in them - only works if using Title field of my list.

[RobElliott]

When you are in that Edit column screen the innternal name of the column is shown in the address bar at the top after Field=

[TraceyLoo]

Digging a bit deeper I have found the URL and field= information:

https://aetnao365.sharepoint.com/sites/xxxxxxxxxxl/_layouts/15/FldEdit.aspx?List=%7B4CAED5AB%2D2FE8%...

I tried using field%5F4 eq '7654321BR' and it still failed with same error.

The expression "field%5F4 eq '7654321BR'" is not valid. Creating query failed.
clientRequestId: 80c0e221-7243-4944-9f4a-c31a174d5f70
serviceRequestId: 80c0e221-7243-4944-9f4a-c31a174d5f70

[RobElliott]

@TraceyLoo you don't copy the field= text, just the characters after it. Try it with Req_x0023_ eq...

[TraceyLoo · Accepted solution]

Me again, so I learned that the Copy Link Address of the column is not the same as displayed when opens the column to edit in the URL field at top of browser page.   That field= name was field_4

So your solution was correct; it was a user error on my part in finding that field= name.   Hoping this helps other new Power Automation users.

All the tutorials I've watched are just using the column name and not having to find this name in the URL.  Any thoughts on why this is like this for my SharePoint list and PA workflow?