Invalid ARGUMENT TYPE (Number). Expecting Text value instead while using a combo box

[hitty]

Ok I am trying to concat a combo box to a label. One of the object in my combo box is a number.

Text --> Concat(project_search.SelectedItems, Object) --> Returns Invalid argument type (Number). Expecting a text value instead

so I tried 

Text --> Concat(project_search.SelectedItems, Value(Object.Text)) --> Throws an error in the concat

Text --> Concat(project_search.SelectedItems, Object.Value) --> Throws an error in the concat

Any ideas how to convert this field? 

[Pstork1]

Use the following

Concat(project_search.SelectedItems, Text(Object.Value))

[RandyHayes]

@hitty 

What is the Items property of your combobox and what columns are in the records of the combobox?

[hitty]

No luck on this, threw another error within the formula

[hitty]

The item property is the project_list and are you talking about the fields of the combo box? 

[RandyHayes]

@hitty 

Yes, the columns in the project_list table...what are they and which ones are you trying to concat together?

[hitty]

The column is a number within a sharepoint list. The columns name is total where they input a number. 

Project_Search is the Combo Box and total is the column name

Concat(project_search.SelectedItems, total)

[RandyHayes · Accepted solution]

@hitty 

And what do you get with this formula:

   Concat(project_search.SelectedItems, Text(total))

[hitty]

Would this be the same for a column that contains currency? 

Answered my own question. It does not work for currency, the column just shows up blank. Any idea on how to do the same thing for currency?