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?
Solved! Go to Solution.
And what do you get with this formula:
Concat(project_search.SelectedItems, Text(total))
Use the following
Concat(project_search.SelectedItems, Text(Object.Value))
What is the Items property of your combobox and what columns are in the records of the combobox?
No luck on this, threw another error within the formula
The item property is the project_list and are you talking about the fields of the combo box?
Yes, the columns in the project_list table...what are they and which ones are you trying to concat together?
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)
And what do you get with this formula:
Concat(project_search.SelectedItems, Text(total))
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?
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
252 | |
122 | |
84 | |
83 | |
67 |