How to filter a list with a Person or Group column type?

(0) Share

Report

Posted on by Rodolfo1840

155

Hola team,

I'd like to filter a list by the Employee Name. However, Employee Name column is a Person or Group column type. So, when I run the attached flow,

I got the following error:

Column 'Nombre_x0020_Empleado.DisplayName' does not exist. It may have been deleted by another user.
clientRequestId: ab374634-f379-459d-aebd-96f1c11e3435
serviceRequestId: ab374634-f379-459d-aebd-96f1c11e3435

I've tried with different syntax but no luck. I think that I should expand the column (with ODATA $expand) but it's not clear to me.

Many thanks,

Rodolfo

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Gristy 2,429 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You are correct, expand is needed, unfortunately this is not supported in power automate. Therefore at this time you cannot do this.

You could copy the display name to a column every time the item is created or modified and filter on that to work around it.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @Rodolfo1840 ,

Maybe you could use useremail as a filter.

Like:

Best Regards,

Was this reply helpful? Yes No
Rodolfo1840 155 on at

Like (0)

Report
Copy link

Link copied!

I tried this but it didn't work:

One or more field types are not installed properly. Go to the list settings page to delete these fields.
clientRequestId: c17b882b-7b5b-472c-9f9a-348b96c62c58
serviceRequestId: c17b882b-7b5b-472c-9f9a-348b96c62c58

Was this reply helpful? Yes No
Rodolfo1840 155 on at

Like (0)

Report
Copy link

Link copied!

It worked!

I realized that the fields ARE case sensitive!

Was this reply helpful? Yes No