Announcements
Hi
I have a combobox with items set from a collection. However, I don't seem to be able to patch the item selected to a Sharepoint column. What kind of column do I need to simply patch the selected item? I keep getting errors like expecting TEXT when the item is a RECORD / Table etc.?
There must be a way to patch a combobox item to a SP column?
Many thanks, Justin
Hi @jed76 ,
A default patch should work for a single ComboBox Item.
Patch( YourSPList, Defaults(YourSPList), {YourItemToPatch: ComboBox.Selected.Value} )
_____________________________________________________________________________________Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
@jed76 What is the column type in SharePoint and is it single select or multiselect?
Single select. The column can be anything to make the patch work! I would like to know what column type to use to enable the combobox to be patched.
many thanks.
If the type of data will be numbers then use Number. If will be text or numbers then use single line of text.
@jed76 If you are using Single line of text column in SP and to create new record, then use
Patch(SPList,Defaults(SPList),{ColunName:combobox.selected.value})
If you are using choice column in SP with single select
Patch(SPList,Defaults(SPList),{ColunName:{value:combobox.selected.value}})
Please check.
@vish3027 I get an ERROR when I try to use combobox.selected.value. 'Value' isn't an option? I can only select the individual field names?
@vish3027 actually just got it to work using combobox.selected.<fieldname>
Do you know how I can set the default value for the combobox (or default selected items) to the item in the text column for this combobox. As the column is text, I don't seem to be able to use it for the default item in the combobox?
@jed76 you can tryDefaultSelcteditems: {Result:"Text" } or {Value:"text"}.
Can I do that with THISITEM? All of my other boxes patch to a collection and I set their defaultselected to "ThisItem.<columnname> but I can't do that with the text column into a combobox? Many thanks.
Hi @jed76,
Have you solved your problem?
Since all your Combo Boxes are patched to a collection, I think you could not use the ThisItem because you could not define the special record without a form control. I don't see any necessary for you to display default selected item in a Combo Box if you don't have a form.
If you have single Combo Box to patch selected item to your collection, you should reference to the ID to define a record.
In addition, DefaultSelectedItems property of the Combo Box expects table value while ThisItem.<textColumn> is a text value.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 335 Most Valuable Professional
11manish 165
MS.Ragavendar 96 Super User 2026 Season 1
