Hi @Iantaylor2050 ，
The formula I provided was to save search text in Combo box's search area to SP list as the Title column value if there is no item selected in the combo box. This is the only way to add a new item within combo box since there is no more place of a combo box to type in.
About your first question, if it is a LookUp column means it retrieves records from another list so you will have to add records to the list being looked up then the LookUp column could find the new items.
If you really want to make users type in new items clearly and save them to SP list when there is no item could and has been selected, you could add a TextInput box in the data card upside or beside the default combo box and turn off the search feature of the combo box, then make typed in text of the TextInput box as the search text or the source of new item instead.
I made a mistake in above formula that submitted the form without setting the LookUp column value, but with the help of the method of adding a TextInput, you could add another button such as a plus icon if needed to add a new item to the lookup list, with the formula below:
If(IsBlank(LookUp(LookUpList,Title=TextInput.Text)),
Patch(LookUpList,
Defaults(LookUpList),
{Title:TextInput.Text} // All requied columns need to set the value here
),
Notify("The tag has already exists, please select in the dropdown!",NotificationType.Warning)
//To warn and avoid duplicate items
)
The the Update of the LookUp column Data Card should be:
If(!IsBlank(DataCardValue.Selected),
DataCardValue.Selected,
LookUp(LookUplist,Title=TextInput.Text)
)
Then the submit button only need to be SubmitForm(NewForm)
Since within one button we could not trigger two submit action point to one SP list, the add button of the new tag is required so that users could first add a tag to LookUp list then when submitting the form the lookup column have a value to look up from.
Hope I have explained clearly and 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.
