Unanswered

Finding Individual ComboBox Value in Table

(0) Share

Report

Posted on by VO-19111807-0

I'm trying to have a combo box be referenced in a label to check if it the value from the dropdown is in the table and display as "In List"

current code for label:

If(CountIf('Energy Device Record','Manufacturer Model'= ComboBox2_3.SelectedItems)>0,"In list",If(IsBlank(ComboBox2_3.Selected),"Racking Missing","Not in List"))
 
the error comes in that the combo box is incompatible for comparision.
 
Is there any way around this? or to convert the combobox into text?

Categories:

Power Apps component framework

All responses (3)

Answers (0)

ronaldwalcott 3,820 on at

Like (0)

Report

Finding Individual ComboBox Value in Table

Is Manufacturer Model a Choice field?

What are the items that the combobox is bound to?

Depending on the items property you could get

'Manufacturer Model'.Value = ComboBox2_3.Selected.Value

or

'Manufacturer Model'.Value = ComboBox2_3.Selected.columnname - where columnname is the column name
VO-19111807-0 2 on at

Like (0)

Report

Finding Individual ComboBox Value in Table

"Is this SharePoint or Dataverse?

Are you trying to count all the records where a choice or lookup value is equal to Manufacturer Model and something else? "

'Manufacturer Model'= ComboBox2_3.Selected.Value does not work, says that "Value' is not recognized

This is in Sharepoint

I'm trying to see if the selection from the combobox, is a value in the 'Manufacturer Model' column of 'Energy Device Record'.
ronaldwalcott 3,820 on at

Like (0)

Report

Finding Individual ComboBox Value in Table

'Manufacturer Model'= ComboBox2_3.SelectedItems

would be more like

'Manufacturer Model'= ComboBox2_3.Selected.Value

but is this what you really want to do?

Unable to see the complete formula.

Is this SharePoint or Dataverse?
Are you trying to count all the records where a choice or lookup value is equal to the value in column 'Manufacturer Model' and something else?