[SOLVED] How do I get a combobox to only list the people in my sharepoint list and not my entire company?

How do I get a combobox to only list the people in my sharepoint list and not my entire company?

So I have a SharePoint list called PeopleList that has two columns: Names (a Person column) and Department (a Text column).

In PowerApps, I am using a ComboBox so that I can select the people from PeopleList. However, when I use either of these two codes:

Items = Choices([@PeopleList].Names)

Items = PeopleList.Names

The dropdown gives an entire table of EVERYONE in my company, not the names found in my SharePoint list. How do I make it so that it only gives the table from my list?

Solution

Your code is populating the dropdown correctly because the formulas mentioned above will give you the source data of your field, which is @Everyone.

To get the names found in my SharePoint list you can use the Distinct function with a combination of ForAll:

ForAll(Distinct(PeopleList, Names), ThisRecord.Value.DisplayName)

Distinct will get you all the distinct people and ForAll will get you the Names of each record