Search code examples
powerapps

Extracting data from combobox filled with items from sharepoint

I have a form that contains a combobox field that has options taken from a sharepoint list. The data type is listed as an item, and the function is Choices([@'Name'].ColumnName). I would like to extract the single selected value and convert it into text. Is this possible?

Solution

  • Yes this is easily done.

    It looks like:

    • You have a Sharepoint list
    • With a Person-type column
    • Then you added a Form control to your PowerApps
    • And now you want to get like, DisplayName or JobTitle from the Combobox.

    Because Person-type columns are really record of information, you have to use "dot notation" to get a level deeper.

    Try this:

    • Add a Label control to your PowerApp
    • Set its Text proptery to <yourComboboxNameHere>.Selected.DisplayName

    In the above example, Selected is the record, DisplayName is the column.

    By adding the "." after Selected, you can see all available options.

    Example in action:

    enter image description here