cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
romoval
Level: Powered On

GetItems Filter Error

I am getting an error stating a column used on a GetItems Filter Query does not exists on the list I am checking, but it does.

 

Why?

 
 

"Column PDAAA does not exist."

 

But I can see it on the list I am using.

 

GetItemsError01.png

GetItemsError02.png

 

GetItemsError03.png

GetItemsError04.png

GetItemsError05.png6etItemsError05.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: GetItems Filter Error

Hi @romoval 

 

Get the internal column name like you did for PDAAA column and use that.

 

Let me know if that does not work.

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

View solution in original post

9 REPLIES 9
Super User
Super User

Re: GetItems Filter Error

Hi @romoval 

 

Try running the Get Items with no Filter and check the column name and value what you getting for column PDAAA . This will help in finding the issue.

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

romoval
Level: Powered On

Re: GetItems Filter Error

OK, doing that, no filter.

 

Then send myself a notification of the result of the list via e-mail.

 

Got the e-mails, but hey provide a URL reference. In test run, for that step, the outputs body I got the attached.{D456D353-F51B-4CFA-9913-6C4BEBC62986}.png.jpg

 

The string I wanted to filter by is 'Group A - Registered Courses'.

 

It seems the name of the column to use in the filter is "Professional_x0020_Development_x".

 

How do I translate that into the GetItems advanced option Filter?

 

I seems to have spaces.

 

Thanks.

 

Super User
Super User

Re: GetItems Filter Error

Hi @romoval,

Use the column name what you getting in response.

Regards
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
romoval
Level: Powered On

Re: GetItems Filter Error

OK, I am using Professional_x0020_Development_x eq 'Group A - Conferences & Industry Events'. Having 'Group A - Conferences & Industry Events' being a dynamic variable content.

 

I assume here that I can use the name EXACTLY as provided, meaning having "_x0020_" in the middle and "_x" at the end on the GetItems filter option.

 

I no longer have an error in running the filter, still it finds not records.

 

It seems this specific column has a number of attributes and Value is the one that has the string I am searching for "Group A - Registered Courses"

 

If I solely use the string Professional_x0020_Development_x I got no execution errors, but no records are found. If I try to use Professional_x0020_Development_x.value I got execution errors.

 

The other columns have no such sub/attributes (Id, Value, etc.) and I assume can be directly accessed by name.

 

Inked{D456D353-F51B-4CFA-9913-6C4BEBC62986}.png_LI.jpgNoRecordsFound.jpg

This is the new filter condition

 

NewFilterCriteria.jpg

 

romoval
Level: Powered On

Re: GetItems Filter Error

If I try to use any of the other list attributes as filter criteria for GetItems, for the same record, I do get results.

 

WorkingFilterCriteria.jpg

It is specifically not liking the fact that I am querying for that specific attribute of the list.

 

This is not the first Title default attribute created when you create a new list, but it is a new custom attribute I added and it is the first in the order of attributes. Can this be a problem? That the first column has any special usage case?

Super User
Super User

Re: GetItems Filter Error

Hi @romoval 

 

Is your PDAAA  column is type lookup? if yes then you should use different expression in Filter Query, something like follow:

 

My LookuUP column Name is : MyLookUP and its looking up to Title on source list 

 

MyLookUP/Title eq 'Australia'

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

romoval
Level: Powered On

Re: GetItems Filter Error

Yes, it is a lookup.

The attribute name that is looking up on the source list has spaces. So instead of "Title" is "Title 1".

Do I need to enclose it in quotes or use any special character for the space?

Like:

MyLookUp/"Title 1"

Thanks.

Super User
Super User

Re: GetItems Filter Error

Hi @romoval 

 

Get the internal column name like you did for PDAAA column and use that.

 

Let me know if that does not work.

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

View solution in original post

romoval
Level: Powered On

Re: GetItems Filter Error

OK, getting the original list used for lookup gives me that the attribute I am interested in is called Title.

 

Therefore, by using the internal columns names and your forward slash trick I got it.

 

Professional_x0020_Development_x forward_slash Title

 

Thanks.

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,793)