Answered

'Get Items' Filter Query not reading Title column

Like (0) Share

Report

Posted on 24 Mar 2023 12:08:35 by Community Power Pla...

I have a list where the Title column is a concatenation between the machine name and the day the row was created.
For example, for the row with the Title 'ZX1_23.03.2023' it means that this row is equivalent to machine ZX1 on March 23, 2023, like that:

So far so good, but when I use a Filter Query from the 'Get Items' action to filter the row where the Title column is equal to 'ZX1_23.03.2023', it brings me no row at all. The strange thing is that when I use the Filter Query with the ID of that row (15940), it brings the Title column like this:

But when I use Filter Query to bring this specifc row filtering by Title, it returns me no row at all:

What am I doing wrong?

I have the same question (0)

Summarized by AI

All responses (5)

Answers (1)

Nived_Nambiar 18,021 Super User 2025 Season 2 on 24 Mar 2023 at 14:42:21

Like (1)

Report

Re: 'Get Items' Filter Query not reading Title column

You are welcome @req77

Well i have learned something new also 🙂
Have a nice day 🙂

Was this reply helpful? Yes No
Community Power Pla... on 24 Mar 2023 at 14:38:21

Like (0)

Report

Re: 'Get Items' Filter Query not reading Title column

Incredible! That was exactly it. I was trying to do this since yesterday without understanding why it didn't work haha
Thank you very much, @Nived_Nambiar !

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,021 Super User 2025 Season 2 on 24 Mar 2023 at 13:51:12

Like (1)

Report

Re: 'Get Items' Filter Query not reading Title column

Hi @Anonymous

Finally i was able to find out the reason behind it,

After doing a little reasearch, i found out that get items can captures 100 items by default, if you want to capture more, you have enable pagination and specify the max items that can be extracted by Get items in get item settings

here i have enabled pagination and input 10,000 as max items to be captured by get item actions

More information here
https://sharepoint.stackexchange.com/questions/303692/what-is-the-default-number-of-items-that-are-retrieved-in-the-get-items-action-a#:~:text=By%20default%20the%20Get%20items,of%20the%20Get%20items%20action.

Leanred something new today 🙂

Hope its clear 🙂

Mark it as solution if it resolves ur query 🙂

Was this reply helpful? Yes No
Community Power Pla... on 24 Mar 2023 at 13:43:08

Like (0)

Report

Re: 'Get Items' Filter Query not reading Title column

Hello, @Nived_Nambiar
My list has thousands of rows. When I run 'Get Items' without any filter, it brings a lot of information in the output, but with Ctrl + F I don't find the string 'ZX1_23.03.2023'.
This is very strange, the string is exactly the same as what appears in the Title column of the list. Why can't Filter Query see it?

Was this reply helpful? Yes No
Nived_Nambiar 18,021 Super User 2025 Season 2 on 24 Mar 2023 at 12:14:43

Like (0)

Report

Re: 'Get Items' Filter Query not reading Title column

Hi @Anonymous

I have tried to get items by title it is working fine for me

Do one thing, without the filter query, check what is exact value shown in Title column by checking the output

Was this reply helpful? Yes No