cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FabianAckeret
Solution Sage
Solution Sage

How to filter get items properly for people?

hey there

 

I was wondering how you can use get items to filter by a person? I have a column, let's call it "person", which includes the employee (it's a people picker field). Whenever I make use of the filter option from get items it won't return me any results. Ideally, I'd like to filter by the email "attribute" of that field. Any ideas on how to achieve this?

 

Cheers


Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

Hi @FabianAckeret ,

 

It is not feasible to use Filter Query to filter items with Person filed.

You could consider using Filter array to filter items.

If Person field does not allow multiple selections, please refer to the screenshot below to configure Flow.

Image reference:

13.PNG

Please take a try and if you have further needs, please provide more details.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-bacao-msft
Community Support
Community Support

Hi @FabianAckeret ,

 

It is not feasible to use Filter Query to filter items with Person filed.

You could consider using Filter array to filter items.

If Person field does not allow multiple selections, please refer to the screenshot below to configure Flow.

Image reference:

13.PNG

Please take a try and if you have further needs, please provide more details.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Works like a charm. Thank you!


Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
kitUser
Frequent Visitor

Why does hard coding the email address work but using a dynamic value does not? 

 

kitUser_0-1604077645903.png

 

kitUser
Frequent Visitor

I was able to work around this issue by first initializing a new variable called emailAddress. Then filtering the array with the variable. Still wondering why the direct comparison doesn't function as I expected. 

kitUser_0-1604079576316.png

kitUser_1-1604079644221.png


I tried editing in advanced mode for functions string(), toUpper(), and tried operator contains. 

Hi @v-bacao-msft , I have been struggling to filter the person field that allows multiple selections. I tried 'filter array' but it seems nothing is filtered. Does it require a different method? TIA

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,302)