Populate a Combobox Based on a SharePoint List Text Column

(1) Share

Report

Posted on by Thor_PPC

365

Hello,

I am working on improving an existing Power App that someone else made and I'm running into an issue with something I am trying to do.

Within the existing Power App is a Combobox of options. When an option is selected, it populates a Text datacardvalue with the selection and adds a comma at the end. Here is the Default field of the text DataCardValue:

Concat(vComboLLC.SelectedItems, Value & ", ")
 
The Items property of the Combobox is all manually typed values, like ["Value1", "Value2", "Value3"]
 
Supposedly the original creator had a very specific reason for setting the Power App up this way and I am not to change the field to a Choice column in SharePoint.
It will apparently break a lot of other things.
 
 
 
What I am working on is having this field (and all others within the Power App) to have a Default field where they pull in data submitted to SharePoint,
and any OnChanges patch the SharePoint list.
 
I have the patch working by giving the Combobox the OnChange value of:
 
Patch(List1,
    LookUp(Filter(List1,'Email1'=User().Email),'Email1'=User().Email),
    {
        'TextColumn1':DataCardValue25.Text
    }
    )
 
 
My question is: How do I get the Combobox to have a Default value that pulls in and selects the fields that are in the Text column within SharePoint?
I'm assuming I'll have to cut off that comma that gets added, but I'm not sure how to make the choices be selected in the Combobox. Is it even possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

1. Setting the Default Value of the ComboBox Based on SharePoint Data

set the DefaultSelectedItems property of the ComboBox (vComboLLC in your case) to match the data stored in the SharePoint list.

Split(LookUp(List1, 'Email1' = User().Email).TextColumn1, ", ")

2. Updating the ComboBox Selections to SharePoint:

modify the OnChange property to update the SharePoint field:

Patch(List1,
LookUp(Filter(List1, 'Email1' = User().Email), 'Email1' = User().Email),
{
'TextColumn1': Concat(vComboLLC.SelectedItems, Value & ", ")
}
)

3. Removing the Trailing Comma (Optional):

Patch(List1,
LookUp(Filter(List1, 'Email1' = User().Email), 'Email1' = User().Email),
{
'TextColumn1': Left(Concat(vComboLLC.SelectedItems, Value & ", "), Len(Concat(vComboLLC.SelectedItems, Value & ", ")) - 2)
}
)

Try and let me know.

Was this reply helpful? Yes No
Thor_PPC 365 on at

Like (0)

Report

Hello @SaiRT14,

Unfortunately Setting the Default Value of the ComboBox Based on SharePoint Data that you shared doesn't seem to work. As soon as the code is input, it clears out anything that is currently selected by the user.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi Thor_PPC

I will provide a human-generated response - there are a couple of things that may affect the result. Firstly you can get rid of the trailing comma on the Default of the Text Input with (note comma instead of &)
Concat( vComboLLC.SelectedItems, Value, ", " )

Also you do not need both Lookup and Filter on the Patch
Patch( List1, LookUp( List1, 'Email1' = User().Email ), {'TextColumn1': DataCardValue25.Text} )

Now to the DefaultSelectedItems (not the Default) of the Combo Box
Split( LookUp( List1, 'Email1' = User().Email ).TextColumn1, ", " )

All of this works perfectly on a model I created below

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No