
Hi,
I am working on a form, and I am searching for an answer regarding the following issue:
I have two databases:
I have created a ComboBox in the form with Items = SortByColumns(Source.Table,"Title"). The Source is the second database with entities. I would like to have an option if an entity is not found in the Dropdown of the Combobox, I can enter the entity by myself. Unfortunately, there is no “-” or something else in the existing SharePoint list with the entities.
Is there a way how to manage it?
Thanks a lot for your help.
Regards, Barbara
Hi @Barbara_Sch ,
If no selection is found in the Combo box dropdown area and you still want to save the value, you can easily patch search text of the Combo box. But the point is you will need to patch the text to both lists. So, you can use an If statement to check if selected is blank:
If(IsBlank(Combobo.Selected), Patch(List2, Defaults(List1),{...});Patch(List1,...,{...}),Patch(List1,...,{...}))
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.