207
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.
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
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 🙂
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
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.
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
Anyone?
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,011
Most Valuable Professional
Share
Report
All responses (
Answers (
