'Get Items' Filter Query not reading Title column

[Anonymous]

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?

[Nived_Nambiar]

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

[Anonymous]

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?

[Nived_Nambiar · Accepted solution]

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 🙂

[Anonymous]

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 !

[Nived_Nambiar]

You are welcome @Anonymous 

Well i have learned something new also 🙂

 Have a nice day 🙂