web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : tc763zE59T8DDEuls6hYp8
Power Automate - Building Flows
Answered

'Get Items' Filter Query not reading Title column

Like (0) ShareShare
ReportReport
Posted on 24 Mar 2023 12:08:35 by

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:
1.PNG
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:
2.PNG

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

3.PNG

 

4.PNG

What am I doing wrong?

  • Nived_Nambiar Profile Picture
    17,961 Super User 2025 Season 2 on 24 Mar 2023 at 14:42:21
    Re: 'Get Items' Filter Query not reading Title column

    You are welcome @req77 

     

    Well i have learned something new also 🙂

     Have a nice day 🙂

  • Community Power Platform Member Profile Picture
    on 24 Mar 2023 at 14:38:21
    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 !

  • Verified answer
    Nived_Nambiar Profile Picture
    17,961 Super User 2025 Season 2 on 24 Mar 2023 at 13:51:12
    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

     

    Nived_Nambiar_1-1679665771096.png

     

    Nived_Nambiar_0-1679665744017.png

     

    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 🙂

     

     

  • Community Power Platform Member Profile Picture
    on 24 Mar 2023 at 13:43:08
    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?

  • Nived_Nambiar Profile Picture
    17,961 Super User 2025 Season 2 on 24 Mar 2023 at 12:14:43
    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 

     

    Nived_Nambiar_0-1679660075177.png

     

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

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete