cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ck25415
Level 8

Get item filter query on empty single line text/people picker column

Hello,

 

I am trying to using get item action on a sharepoint list by filtering empty columns. I have tried as mentioned in this post but get an error 

 

My query expression : columnname eq null as menitoned in above post and i get an error message

The expression \"columnname eq\" is not valid

 

I also tried columnname eq 'null', I dont get any errors but I also get items that have a value in that column.

 

Any ideas?

 

Thanks,

 

I get an error message

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Get item filter query on empty single line text/people picker column

Hi @ck25415 ,

 

I tested ColumnName eq null on my side, which is valid for filtering fields of type Single line of text.

I guess the ColumnName you configured is incorrect. The ColumnName it need here is not necessarily the same as what you see in SharePoint List.

 

You could consider not configuring Filter Query first. After Get items action is executed, check the name of this field in Body, as below:

4.PNG

Then configure the Column Name displayed in Body in Filter Query.

Image reference:

5.PNG

 

Please take a try and let me know if issue still exists.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Get item filter query on empty single line text/people picker column

Hi @ck25415 ,

 

I tested ColumnName eq null on my side, which is valid for filtering fields of type Single line of text.

I guess the ColumnName you configured is incorrect. The ColumnName it need here is not necessarily the same as what you see in SharePoint List.

 

You could consider not configuring Filter Query first. After Get items action is executed, check the name of this field in Body, as below:

4.PNG

Then configure the Column Name displayed in Body in Filter Query.

Image reference:

5.PNG

 

Please take a try and let me know if issue still exists.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 116 members 5,358 guests
Please welcome our newest community members: