Fill combobox Items property with all distinct users from sharepoint List column "Assigned to" which is "person and group" type

[Diggerr]

Fill combobox Items property with all distinct users from sharepoint List column "Assigned to" which is "person and group" type

I have sharepoint List column "Assigned to" which is "person and group" type

When i trying put in Items field Kaizen.'Assigned to'

and to DisplayField ["DisplayName"]

combobox return always bull**bleep** but not a list of users, and this IDS every time changes

Distinct(Kaizen.'Assigned to', 'Assigned to'.DisplayName).Result return same bullbleep

Choices(Kaizen.'Assigned to') Return list of user which is not in this List at all

1. So how to return all users distinct list form sharepoint list column?
2. why here in Formula 'Assigned to', but in debugger Assignedto ? and why i cant reference to debugers displayed name? 
3. Why all debugers columns names is different from really column names in my List?
4. What is difference in debuger returned types as Table, Record, String? How convert one to other?
5. Where can i find normal manuals about powerapss? 

[WarrenBelz]

Hi @Diggerr ,

One of the reasons I do not use complex field types . . .

Distinct(
   AddColumns(
      Kaizen,
      "AssignedTo",
      'Assigned to'.DisplayName
   ),
   AssignedTo
).Result 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Diggerr]

@WarrenBelz  Dropbox return empty fields

[WarrenBelz · Accepted solution]

@Diggerr 

Is this a single or multi-select Person Combo Box ?  What I posted should work on a single selection - tested here and works as below.

If multi-select, it gets a bit harder

Distinct(
   Ungroup(
      ForAll(
         Kaizen,
         Ungroup(
            'Assigned to',
            "DisplayName"
         )
      ),
      "Value"
   ),
   DisplayName
).Result

I have also tested this here and it works as expected.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[victorcp]

Hi,

try this:

Distinct(Kaizen,'Assigned to'.DisplayName)

If needed set 'DisplayFields' and 'SearchFields' properties to: ["Result"]

I hope it helps 🙂

[Diggerr]

@WarrenBelz Perfect, TY,  yes it multiselect box

[Diggerr]

@WarrenBelz  it is possible this results show in gallery?

[WarrenBelz]

@Diggerr ,

Same code, but you are only going to get one field - the Distinct DisplayName as Result

[Sbassmed]

Hello , 

Thanks for sharing your solution with that in mind I´d like to know if it´s possible to have also the email from the user , so when I select an item form the combobox I could use something like Combobox.Selected.Email to get the email or Combobox.Selected.Value to get the DisplayName from the same user 

Also, when i tried 

Distinct(
   Ungroup(
      ForAll(
         Kaizen,
         Ungroup(
            'Assigned to',
            "DisplayName"
         )
      ),
      "Value"
   ),
   DisplayName
).Result

doesn´t allow me to use the .Result

[WarrenBelz]

@Sbassmed ,

You need Value now instead of Result due to a Power Apps recent change.