Answered

Filter function for Users returns names up to letter "P"

(0) Share

Report

Posted on by Ajwou

Hello,

I have the following filter function setup on a drop down
Filter(Office365Users.SearchUser({searchTerm:"",top:999}), AccountEnabled=true, Or(Department="A", Department="B", Department="C")) and for some reason it returns users only up to letter "P" - it shows 28 names in the dropdown.

Is there something I am missing here?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Ajwou ,

Are there more than 1000 users within Office? If so, you can refer to below video and find a workaround.

www.youtube.com

Best regards,

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Ajwou ,

When reviewing my replies, I found the video link is missing, please check the video now:

www.youtube.com

Best regards,

Was this reply helpful? Yes No
Ajwou on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

Brilliant, that's exactly the solution. Thanks a lot! All sorted.

Was this reply helpful? Yes No