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:
Coalesce(DC.Selected, {Value: DC.SearchText, '@odata.type': "#Microsoft.Azure.Connnectors.SharePoint.SPListExpandedReference"})
Items:
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:
When I turn that on my forms stops working and I can no longer enter responses.
See the error when I turn it on:
How can I make it work with multiple choices from my combo box?
Thanks
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
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
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!!
Hi @diegoandre10 ,
I don't know what happened to your app.
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
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:
Thanks!
Video above isn't working can you send an updated link
Thanks
Almog
User | Count |
---|---|
153 | |
93 | |
83 | |
77 | |
58 |
User | Count |
---|---|
198 | |
176 | |
106 | |
96 | |
89 |