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!
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'
I think it was possibly because my column was a Person/Group. It works if I change my column to Single Text
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?
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.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2