How to filter the Sytemuser table

[nhtkid]

Hi,

I have a Dataverse table that has a lookup column to the User table.

I referenced this table in the Power Pages form with a search input field.

When I click search, it shows up all the system users as well as my actual enabled license user.

How can I filter the view so it will only display the actual staff that were added to Dataverse, without all those system users.?

Thanks!

[Jcook · Accepted solution]

@nhtkid 

You can create a view on the table to filter out the ones that “start with” #.

[nhtkid]

Hi @Jcook,

Thanks for the reply.

The  Systemuser table already have a default called "Enabled Users", which only list the staff user with licenses, not including any of the # system accounts.

However, how I use it?

When I created the column that referenced this table, it doesn't give me an option to define a view.

When my page form got created based on this table, I don't get to choose what view can I use for this input field.

[Jcook · Accepted solution]

Hi @nhtkid 

You have to edit the form, and on the form select the user field lookup, and switch the view.

[nhtkid]

Thank you @Jcook!

I am such a noob and you are incredible.

Thanks for all the help.