cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diegoandre10
Post Partisan
Post Partisan

Enable multiple choice and free text responses from combo box

Hi all

 

I am trying to enable on my combo box the choice options of my SharePoint List and also would like to enable free text too.

 

The user should be able to enter multiple choices whether it's from the choices catalog or free text.

 

The SP list column called 'Distribution' is a choice datatype and has "Can add values manually" enabled.

 

The code I am using under update is the following:

 

diegoandre10_1-1628520654968.png

 

 

 

 

Coalesce(DC.Selected, {Value: DC.SearchText, '@odata.type': "#Microsoft.Azure.Connnectors.SharePoint.SPListExpandedReference"})

 

 

 

 

Items:

 

diegoandre10_3-1628521455120.png

 

The App lets me successfully only use either submit the choices catalog from my SP or enter any free text I want. But I can't use both. 

 

I realized that I had "allow multiple selections" disabled:

 

diegoandre10_4-1628521565757.png

 

When I turn that on my forms stops working and I can no longer enter responses.

 

See the error when I turn it on:

 

diegoandre10_5-1628521692250.png

 

How can I make it work with multiple choices from my combo box?

 

Thanks

 

 

16 REPLIES 16
diegoandre10
Post Partisan
Post Partisan

Hi @v-xiaochen-msft 

 

It doesn't work when I add a text as seen at the end of the video.

 

Regards.

diegoandre10
Post Partisan
Post Partisan

Another concern I have with OnSave is that it's related to 'Packaging', however I will need this same thing in other combo boxes. Not just packaging.

 

Can we keep using onSelect as you did initially?

 

Regards @v-xiaochen-msft 

v-xiaochen-msft
Community Support
Community Support

Hi @diegoandre10 ,

 

This is a custom form in sharepoint .

You should save and pulish the app an use it in sharepoint.

When you click on the save button on sharepoint ,it will work.

 

Best Regards,

Wearsky

Hi @v-xiaochen-msft 

 

Can we keep using onSelect as you did initially?

 

My concern of using OnSave is that it's related to 'Packaging', however I will need this same thing in other combo boxes like 'Ingredients', 'Distribution', etc. Not just packaging.

 

Please see what happens with onSelect:

 

https://1drv.ms/u/s!ApgeWwGTKtFdh1iDCu6L4qxEMi4l?e=87cVVa

 

Thank you once again!!

 

v-xiaochen-msft
Community Support
Community Support

Hi @diegoandre10 ,

 

I don't know what happened to your app.

vxiaochenmsft_0-1628576782315.png

You can see I can use this . It didn't have an error.

But you should not use the onselect property of combo box here.

When you click on the combo box ,the formula will work.

In otherwords, the formula works before you choose values.

 

Best Regards,

Wearsky

 

Hi @v-xiaochen-msft 

 

I am getting a bit confused sorry. In your image you have onSelect with a SubmitForm code.

 

What would be the code considering I need to apply this same free text + choice selection not just packaging but for other columns too? 

 

Can you share again the code here please?

 

I would like to keep OnSave like this because it keeps it the original way and is not referenced to a single column:

 

diegoandre10_0-1628577391981.png

 

 

Thanks!

Video above isn't working can you send an updated link

Thanks 

Almog

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,181)