Skip to main content
Community site session details

Community site session details

Session Id : FF2Wej20QHmLESitWCpgo9
Power Automate - Building Flows
Answered

Filter Query - using column with name

Like (0) ShareShare
ReportReport
Posted on 25 May 2021 09:21:07 by 189

Hi!

 

I'm having some trouble using the Filter Query box in Get Items.

 

I want to run my flow but only pull through items that relate to a persons name (column ID Line Manager) but each time I try it fails.  

 

I've tried using these already;

Line Manager eq Name

Line Manager eq 'Name'

Line Manager eq "Name"

 

I've also tried putting the Name in as an expression but that doesn't work either.

 

This is probably so simple to do but just can't work it out!

  • tom_riha Profile Picture
    10,127 Most Valuable Professional on 28 May 2021 at 09:40:33
    Re: Filter Query - using column with name

    Hello @RRMX1 ,

    if it's a person or group column you must specify also the user value to check, you can filter by email, user name or claims.

    Person/EMail eq 'person@company.com'
    Person/Title eq 'Firstname Lastname'
    Person/Name eq 'i:0#.f|membership|xxx@tomriha.com'

     

  • RRMX1 Profile Picture
    189 on 26 May 2021 at 07:43:00
    Re: Filter Query - using column with name

    I think it was possibly because my column was a Person/Group.  It works if I change my column to Single Text

  • RRMX1 Profile Picture
    189 on 26 May 2021 at 07:24:55
    Re: Filter Query - using column with name

    Thanks! It is running through to the end now without failing but it still isn't picking up the lines that I know it should be?

  • Verified answer
    tom_riha Profile Picture
    10,127 Most Valuable Professional on 25 May 2021 at 09:42:49
    Re: Filter Query - using column with name

    Hello @RRMX1 ,

    you must use the column internal name and then it's:

    ColumnInternalName eq 'Name'

    You can take the internal name at the end of the url on the 'Edit column' page in SharePoint.

    image.png

     

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete