Answered

Get Items Filter Query Internal Name error

(0) Share

Report

Posted on by Paul2000

I have a simple list named Source1 with columns I added named Col1, Col2, Col3.

I've created a simple filter query in Get Items using the internal Col1 name _x0043_ol1 which I obtained by going to List Settings, selecting Col1 and grabbing the internal name from the URL. Here is what I'm seeing when I do that.

x/_layouts/15/FldEdit.aspx?List={DCF865F8-956B-46B1-9448-AA8DD35A887B}&Field=_x0043_ol1

In Get Items this is what I am using in the Filter Query. _x0043_ol1 eq 'Kuhn'

'Kuhn' is a value in Source1 Col1 of my list.

When I run the flow I'm getting the following error indicating the column doesn't exist.

Column '_x0043_ol1' does not exist. It may have been deleted by another user.
clientRequestId: eb7b708b-56fd-4c8a-ae01-45c281b73f4e
serviceRequestId: eb7b708b-56fd-4c8a-ae01-45c281b73f4e

When I run the flow using column name Title or Author and searching for values I know are there the flow works fine. The issue is the columns that I created don't work when I use the Internal names.

I am using my free Dev license from MS so could this be an issue with the subscription?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Paul2000

To find the name Run the Get Items using Title then open the run history. Check the Get Items results against each fields. Identify the column 'x0043_ol1' in your results. Later modify the query accordingly.

Thanks

Was this reply helpful? Yes No
Verified answer

Paul2000 21 on at

Like
a
(1)

Report
Copy link

Link copied!

Seems I figure this stuff out after I ask the question.

Seems SP doesn't like it when you name columns Col1, Col2, etc. When I did that I get a "funky" internal name that begins with an underscore.

When I created a new column simply named "test" and applied my filter query it worked. The Internal name was (you guessed it) "test" so all worked well.

Perhaps this is because the name contains a number or naming a column as "col1", "col2", etc. confuses SP. I don't know.

Thanks for the reply.

Was this reply helpful? Yes No