I tried searching through forum topics but couldn't find one that fit my specific scenario.
I have a combobox that is writing to a SharePoint list text field. The combobox allows users to select an option from a different list or write in text in the Search Field that is captured. Currently, everything works as expected -- the dropdown values write to SharePoint as does the SearchText. However, my issue is that when my form is in Edit Mode, the SearchText that is written to the SP field does not display and the ComboBox is empty. I cannot figure out which formula to write on the DefaultSelectedItems property to remedy this.
Here are the codes I am using:
DefaultSelectedItems: With(LookUp(ListName, Title = ThisItem.MySPField),
{Id: ID,
Value: Title
})
Items: LookUpListName
Update (CARD): If (!IsBlank(DataCardValue34.Selected.Title), DataCardValue34.Selected.Title,
If( !IsBlank(DataCardValue34.SearchText), DataCardValue34.SearchText))

Report
All responses (
Answers (