comboboxpowerappssharepoint-list

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)

or

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