Unanswered

Show people in Combo/Dropdown box from Sharepoint List People Type

(0) Share

Report

Posted on by StuartSmith

225

I have a SharePoint list with several columns including a column called "Name" which is a "Person or Groups" type. This column has a list of names.

Is it possible to have a Combo/Dropdown Box that will show the names from the above column? I have tried adding a combo/dropdown box and then connecting to the data source, but the actual column name isn't listed in the values list to link to the combo/dropdown box.

Hope that makes sense.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

StuartSmith 225 on at

Like (0)

Report

Anyone?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi
I had some issues when creating/naming columns in SP list. The 'Name' column isn't still actually called 'Title' is it? Did you add a new column for the 'Name' column or just edit and rename the 'Title' column?
If you click the cog (settings) in the top right hand corner of your SP list and go to 'list settings' - what is the 'Name' column actually called?

If its not that, and you have connected the dropdown control to the data source, you may need to change the 'value' field in the drop down properties as per below - mine is called 'Session Title' - it gives me the results from this column in my SP list.
Hope this helps

Michael

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report

Thanks for replying. I done some testing and a "Dropdown Box" does not see the "Name" field in the SP List, but a "ComboBox" does see the "Name" SP List field, if I put the "Items" field of the "ComboBox" as "Users.Name", but then the "ComboBox" is still empty 🤔.

I have also just noticed that a "Dropdown Box", if "Items" is set to "Users.Name", it must be able to see the SP list as if i select the Dropdown Box chevron, it displays the correct amount of items as per the "Name" column in the SP List, but you just cant see the items (if that makes sense). So if there are 3 names in the SP List, the Dropdown Box show 3 empty rows. All very odd.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Stuart
In my reply above, in the 'value' field of the drop down control what do you have in that?
I have lots of dropdowns in my app im building at the moment, which is my 1st so not pretending to be an expert. My data source for each dropdown is the SP list, which is the 'Items' field in the screenshot above and then the 'Value field' is what i want it to show - so in your case its 'Name' (if that is exactly what that column is called in your SP list)

Hope this helps
Michael

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (1)

Report

Hi Michael, I think I may have figure the reason, just not the solution. I get the error on the "Dropdown Box" that says...

Warning: The columns produced by this rule are all nested tables and/or records, however the property expects at least some columns of simple values (such as text, or numbers)

and from what I remember, this is because the SP List type of "People and Groups" is a group of attributes such as "Name", "Email", etc so the "Dropdown {DD} Box" can handle that. Somewhere deep in the back of my brain, I remember something about having to create a collection to display all the attributes and then use the collection to populate the DD.

I guess I have some Googling to do 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Stuart

I see, I dont have any experience with that People & Groups type - does the column have to be that type or can it just be text? Like you say if it was just a text type there is no reason the above shouldnt work.

I have learnt everything by Google or Youtube!

Be sure to post the solution in this post (and mark your solution as solution!)

Thanks

Michael

Was this reply helpful? Yes No