Announcements
Hi all, I had a quick questions regarding how to to retrieve all names from a sharepoint column into a Combobox. The user will select an option which will act as a filter on a gallery displaying data from that same sharepoint list. I currently have a combobox but no items are being displayed. Any advise?
Make sure that the fields property of the combobox is set to Result as Distinct produces a single column table and renames the column to "Result". In the example "Value" was the name of the column but in your case it will be "Result".
Thanks for your response. Unfortunately, it is not allowing me to make a selection for the primary text and search field.
@Anonymous
As a test, use a dropdown control instead of a combo box and see what displays.
Still nothing after changing to a dropdown.
There is a problem with the SharePoint column name or type of column. Is it a single line of text type? Also go back into SharePoint and locate the list and check if there is a difference between the display name and the actual name . See https://sharepoint.stackexchange.com/questions/787/finding-the-internal-name-and-display-name-for-a-list-column . Use the actual name instead of the display name in your Distinct() function. If the column name (display name) has been changed, SharePoint retains the original name and some of PowerApps functions require the actual column name to work.
@Drrickryp The column type is "person or group". Is distinct an option for this type?
I never use anything other than single line of text, numeric or date/time types of columns in SharePoint. You could try 'RCA Problem Owner'.Value in your Distinct and see if it works. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/The-Ten-Commandments-of-SharePoint-in-PowerApps/ba-p/848842
@Drrickryp
Is there any workaround to how I can automatically pull the DisplayName from the RCA Owner field (Person data type) into a new column (single line of text) and then pull that into the dropdown?
https://www.about365.nl/2018/11/01/handling-sharepoint-lookup-and-people-fields-in-powerapps/ but in the future you can avoid most of these problems by keeping things simple. Complex column types in SharePoint are actually a table within a table and thus violate a basic principle of database management, ie. one piece of data in each cell. I am "old school" about this but it has served me well over the years.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 223
