cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rssilvaba
Resolver II
Resolver II

CountRows filtering a table witha multiperson field

Hi All,

I am trying to Count the number of rows for a given sharepoint list where I have a Person field that accepts more than one user.

So this would not work:

CountRows(Filter(List, 'Person'.Email = User().Email))

Because the 'Person' is not a Record but another Table. How can manage this to get the correct count?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@rssilvaba 

You would need to use the IN operator instead.

CountRows(Filter(List, User().Email in 'Person'.Email))


---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
mdevaney
Super User
Super User

@rssilvaba 

You would need to use the IN operator instead.

CountRows(Filter(List, User().Email in 'Person'.Email))


---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,284)