Dataverse Backend Canvas App - Trying to call the User table in a combo box

(0) Share

Report

Posted on by ams9

I have a canvas app with a Dataverse backend, not SharePoint.

I have a combo box looking at the Users table (systemusers) that will not load. When I only look at the first couple records it loads perfectly okay -

Filter(FirstN(Users,100),'Users (Views)'.'Canvas App Lookup View').

However, when I take out the FirstN() it does not load. I am assuming it is because of limitations of 2000 rows. Is there any way around this? I need to pull the whole list.

Any guidance is much appreciated. Thank you.