Allowing text entry in a combobox that has its option from Excel

(0) Share

Report

Posted on by WorkingRicardo

878

For my sharepoint list form I have a Text column that really updates from a Combobox. This combobox takes its option from an Excel table, altough it can happen that not all options are there. So I want to allow text entry. I got this to work on another setting where the items of the combobox I put manually with the ["option1"] on Items. This for the update property of the datacard

If(
 !IsBlank(DataCardValue28.Selected);
 DataCardValue28.Selected;
 !IsBlank(DataCardValue28.SearchText);
 {
 Value: DataCardValue28.SearchText
 }
)

So it should be the same? RIght now in Update of Excel combobox one Update looks like this:

ComboBox1.Selected.Cliente
(Cliente is the name of the column in Excel)

It should be like this, no? But i get an error "text value expected, but Void was received"

If(
 !IsBlank(ComboBox1.Selected);
 ComboBox1.Selected.Cliente;
 !IsBlank(ComboBox1.SearchText);
 {
 Value: ComboBox1.SearchText
 }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @WorkingRicardo ,

Please try this.

If( !IsBlank(ComboBox1.Selected); ComboBox1.Selected.Cliente; ComboBox1.SearchText )

Best regards,

Rimmon

Was this reply helpful? Yes No