Answered

How to Add Text Input to Multiple Selection Column

(0) Share

Report

Posted on by sgreenough

I am new to PowerApps and working on my first project which is a submission form.

My PowerApp has a datacard that is a dropdown box which allows for multiple selections, including a selection called "Other (Specify)". Items is set to Choices([@'A101-PE_2'].'Services Requested'). The column in my SP list is set to Choice, allow multiple selections and allow fill in choices.

When "Other (Specify)" is selected, a text input box appears for the user to provide additional description. For the text input, I have Visible set to "Other (Specify)" in DataCardValue2.SelectedItems.Value

I need all of the items selected from the dropdown AND any text entered into the text box to update to my SP list.

For Update, I am using the formula DataCardValue2.SelectedItems and this works in updating SP with all of the selected items, but how do I also include anything entered in the text box?

Categories:

Using Apps Using Formulas

General Questions

All responses (6)

Answers (1)

KrishR 431 on at

Like (0)

Report

Re: How to Add Text Input to Multiple Selection Column

Hi @sgreenough ,

How did you handle the display mode displaying the other text in text input and only selected items in the combobox?

Thank you
Community Power Pla... on at

Like (0)

Report

Re: How to Add Text Input to Multiple Selection Column

@v-qiaqi-msft, your idea worked perfectly for what we needed.

Thank you!
Community Power Pla... on at

Like (0)

Report

Re: How to Add Text Input to Multiple Selection Column

@WarrenBelz,

I am using the script you provided above. We choose "other" and type in a value. The only thing that submits to SharePoint is "other" and not the value we manually input.

You use wMC in your script. What does that do?

Thank you!
sgreenough on at

Like (0)

Report

Re: How to Add Text Input to Multiple Selection Column

@WarrenBelz , thank you so much for your quick response! I've been trying to solve this issue for days. This solution works perfectly!!!
Verified answer

WarrenBelz 146,702 Most Valuable Professional on at

Like (1)

Report
Re: How to Add Text Input to Multiple Selection Column

Hi @sgreenough ,

Try this on the Update of the Data Card

If( "Other (Specify)" in DataCardValue2.SelectedItems, With( { wMC: Concat( DataCardValue2.SelectedItems, Value & "," ) & TextInput8.Text }, ForAll( Split( wMC, "," ), {Value: Result} ) ), DataCardValue2.SelectedItems )

Please click Accept as solution 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 Thumbs Up.
v-qiaqi@microsoft.com on at

Like (1)

Report
Re: How to Add Text Input to Multiple Selection Column

Hi @sgreenough,

Do you want to combine all the Combo Box selected Items with the input choice and save it to the SP list?

I have made a simple test for you, please take a try as below.

Set the Visible property of the text box as below:

If( "Other (Specify)" in DataCardValue2.SelectedItems.Value,true,false)

Set the OnSelect property of the save button as below:

ClearCollect( MyCollection, DataCardValue2.SelectedItems, {Value: TextInput8.Text} ); SubmitForm(Form2)

Set the Update property of the data card as below:

If( "Other (Specify)" in DataCardValue2.SelectedItems.Value, MyCollection, DataCardValue2.SelectedItems )

Hope this could help you at some degree.