Unanswered

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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-qiaqi@microsoft.com on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report
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.

Was this reply helpful? Yes No
sgreenough on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Thank you!

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report

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

Was this reply helpful? Yes No