Combobox going blank (sharepoint list form)

[WorkingRicardo]

I have this combobox that has a bunch of options, and if the user does not find what he is looking for, he can write it in the combobox and whatever was written will be saved. For the first time he is saving, it will record it to Sharepoint list (text column) and it will stay there if you then re-open the item. However, if you save again, this item will go blank.

The way I managed the SearchText to save was changing the Update property of the combobox like so:

If(
    !IsBlank(ComboBox3.Selected.No_);
    ComboBox3.Selected.No_;
    !IsBlank(ComboBox3.SearchText);
    ComboBox3.SearchText
)

Then this is how I managed it for the combobox to retain what was written with the DefaultSelectedItems property

If(
    !IsBlank(Parent.Default);
    If(
        !IsBlank(LookUp(Wilo_Iberica_S_A__Customer; No_ = Parent.Default));
        LookUp(Wilo_Iberica_S_A__Customer; No_ = Parent.Default);
        {Value: Parent.Default}
    )
)

Don't know where I'm going wrong with this... Any suggestions?

[VishalJhaveri]

This is a Prompt Response.

It seems like you're encountering an issue where the ComboBox loses its value after saving it to SharePoint. Let's break down your formulas and see if we can identify the problem.

1. Update property of the ComboBox:

   excel

   Copy code

   If( !IsBlank(ComboBox3.Selected.No_); ComboBox3.Selected.No_; !IsBlank(ComboBox3.SearchText); ComboBox3.SearchText )

   This formula checks if ComboBox3.Selected.No_ is not blank. If it's not blank, it returns ComboBox3.Selected.No_. Otherwise, it checks if ComboBox3.SearchText is not blank and returns it. This part looks fine and should update the ComboBox with the selected value or the entered text.

2. DefaultSelectedItems property of the ComboBox:

   excel

   Copy code

   If( !IsBlank(Parent.Default); If( !IsBlank(LookUp(Wilo_Iberica_S_A__Customer; No_ = Parent.Default)); LookUp(Wilo_Iberica_S_A__Customer; No_ = Parent.Default); {Value: Parent.Default} ) )

   This formula checks if Parent.Default is not blank. If it's not blank, it looks up the corresponding record in Wilo_Iberica_S_A__Customer based on the value in Parent.Default. If a record is found, it returns that record. Otherwise, it returns {Value: Parent.Default}. This part also seems fine and should set the default value of the ComboBox correctly.

Given that both formulas seem correct, the issue might be elsewhere. Here are a few things to check:

• Data Source and Field Types: Ensure that the SharePoint list column where you're saving the ComboBox value is of the correct type (text) and can accommodate the data you're trying to save.

• SharePoint Patch Operation: When saving the ComboBox value to SharePoint, are you using a Patch function or any other method? Double-check your saving mechanism to ensure that it properly updates the SharePoint list item without unintentionally clearing the ComboBox value.

• Data Refresh: After saving the ComboBox value to SharePoint, check if any data refresh operation is happening that might reset the ComboBox value.

If none of these seem to be the issue, you might need to provide more context or details about how the ComboBox value is being saved to SharePoint and any other relevant formulas or processes involved in your app.

[WarrenBelz]

Hi @WorkingRicardo ,

You can improve the top item to

Coalesce(
    ComboBox3.Selected.No_;
    ComboBox3.SearchText
)

for the second item, you will need to field names:
The first YourListFieldName is the field in your current list in the Form or Gallery displayed (which I assume is a Choice or Lookup column).
The second FieldNameHere is the field being looked up in Wilo_Iberica_S_A__Customer (which I assume is Text)

{
   Value:
   Coalesce(
      LookUp(
         Wilo_Iberica_S_A__Customer; 
         No_ = Parent.Default
      ).FieldNameHere;
      ThisItem.YourListFiledName.Value
   )
}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[WorkingRicardo]

@VishalJhaveri hello! ty for your reply. What do you mean by "This is a Prompt Response."?

I also don't get what you mean by "excel Copy code"

So, what I get by your post is that the formulas should be correct, no? The column is of type text. And I'm saving it to Sharepoint with a button with "SubmitForm(SharePointForm1)".

Other things that might help?

[WarrenBelz]

@WorkingRicardo ,

If you want a non-ChatGPT response, please have a look at what I posted.

[WorkingRicardo]

@WarrenBelz ty for the reply.

The way I got the DefaultSelectedItems property with no error was this:

I'm not sure if its correct still.

{
   Value:
   Coalesce(
      LookUp(
         Wilo_Iberica_S_A__Customer; 
         No_ = Parent.Default
      ).No_;
      ThisItem.'Número de cliente'
   )
}

However, when saving with button with the SubmitForm function, it goes like that: 

 And it Sharepoint it goes blank

The sharepoint column is of type text for this. Im just using a combobox to update it. 

[WorkingRicardo]

@WarrenBelz lol I was saying that way of texting seems way too familiar  😂

[WarrenBelz]

HI @WorkingRicardo ,

What types of fields are _No and 'Número de cliente' ? We simply need to get it all down to Text values then refer to {Value: . . } with the two options.

[WorkingRicardo]

@WarrenBelz 

"No_" is a Text Excel column where the combobox is taking its option from Iberica Excel table. 

'Número de cliente'  is the Sharepoint column where I'm trying to save this. It is algo Text column.

[WarrenBelz]

Hi @WorkingRicardo ,

If 'Número de cliente' and _No are both Text columns, I see the other issue now - DefaultSelectedItems

{
   _No:
   Coalesce(
      LookUp(
         Wilo_Iberica_S_A__Customer; 
         No_ = Parent.Default
      ).No_;
      ThisItem.'Número de cliente'
   )
}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps