cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudheervvs
Helper I
Helper I

Combo box with fill-in choices

I have a multi select combo box (SharePoint choice field) where fill-in choices should be allowed. For a single select choice field I am able to save the filled in choice back to SharePoint, but for multi-select I am not sure how to do it. Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @sudheervvs :

The key is to construct a qualified structure.I've made a test for your reference:

1\My data source(List1)

21.gif

2\Add a combo box(ComboBox1) and set it's Items property to:

 

Choices(List1.Choice)

 

3\Add a button and set it's OnSelect property to:

 

Patch(
    List1,
    First(List1), 
    {
        Choice: RenameColumns(
            Split(
                Concat(
                    ComboBox1.SelectedItems,
                    Value,
                    "##"
                ) & "##" & ComboBox1.SearchText,
                "##"
            ),
            "Result",
            "Value"
        )
    }
)

 

 22.gif

Best Regards,

Bof

View solution in original post

3 REPLIES 3
eka24
Super User
Super User

Try

Patch(Table1,Defaults(Table1),{Column1:"ABC", Column2:Concat(ComboBox1.SelectedItems,ColumnNameInCombobox&" ")}

 

Column2 will pick the selected from the Combobox to Sharepointlist

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi @eka24 , Thanks for your reply. Not only the selected items but the text typed in the combo box should also be saved to SharePoint. The typed text may not match with existing choices, but it should be saved along with selected choices.

Hi @sudheervvs :

The key is to construct a qualified structure.I've made a test for your reference:

1\My data source(List1)

21.gif

2\Add a combo box(ComboBox1) and set it's Items property to:

 

Choices(List1.Choice)

 

3\Add a button and set it's OnSelect property to:

 

Patch(
    List1,
    First(List1), 
    {
        Choice: RenameColumns(
            Split(
                Concat(
                    ComboBox1.SelectedItems,
                    Value,
                    "##"
                ) & "##" & ComboBox1.SearchText,
                "##"
            ),
            "Result",
            "Value"
        )
    }
)

 

 22.gif

Best Regards,

Bof

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,827)