How to filter get items properly for people?

(0) Share

Report

Posted on by FabianAckeret

969

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-bacao-msft on at

Like (2)

Report

Re: How to filter get items properly for people?

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:

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

Best Regards,

Was this reply helpful? Yes No
FabianAckeret 969 on at

Like (0)

Report

Re: How to filter get items properly for people?

Works like a charm. Thank you!

Was this reply helpful? Yes No
kitUser 27 on at

Like (0)

Report

Re: How to filter get items properly for people?

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

Was this reply helpful? Yes No
kitUser 27 on at

Like (0)

Report

Re: How to filter get items properly for people?

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.

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

Was this reply helpful? Yes No
Thet 3 on at

Like (0)

Report

Re: How to filter get items properly for people?

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

Was this reply helpful? Yes No