Convert splited ComboBox to text

(1) Share

Report

Posted on by ML-18090909-0

Hi,

I have specific forms to display data in ComboBox thanks to this forum

If(IsBlank(ComboBox4.Selected.Miasto);[];Split(LookUp(Lokalizacja;Miasto = ComboBox4.Selected.Miasto).Dzielnica; ","))

Now I try Patch some data to MS list and I cant gather the data from this box, cus I need text instaed of tabel ect...

Patch(CarShareLista;Defaults(CarShareLista);
{
Title: TextInput2.Text;
Hasło: TextInput2_3.Text;
Miasto: ComboBox4.Selected.Miasto;
Dzielnica: Concat(ComboBox5.SelectedItems;ThisRecord & "") <- Here is the problem
}
)

Can someone can help me?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Pro_User_365 546 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Nacked ,
In PowerApps, to convert the selected items of a ComboBox into a single text string for patching to a data source, you can use the Concat function with the appropriate column name that represents the value you want to concatenate. It seems like you're trying to concatenate records directly, which is why you're facing issues. Instead, you should reference the specific property of the record that contains the text you want.
Here's how you can modify the Dzielnica field in your Patch function:
Patch( CarShareLista, Defaults(CarShareLista), { Title: TextInput2.Text, Hasło: TextInput2_3.Text, Miasto: ComboBox4.Selected.Miasto, Dzielnica: Concat(ComboBox5.SelectedItems, DzielnicaColumnName & ", ") } )
Replace DzielnicaColumnName with the actual name of the property in the SelectedItems records of ComboBox5 that contains the text you want to concatenate. The "& ", " part is concatenating each selected item with a comma and space as a separator. Adjust the separator as needed for your specific case.
This will create a comma-separated list of the selected items in ComboBox5 and patch it as a text string to your CarShareLista.
Note: After receiving the answer, if you find it helpful, please consider accepting it. 😊 Regards, Ali Shahzad
ML-18090909-0 31 on at

Like
a
(0)

Report
Copy link

Link copied!
I used concat function cus I saw this in other post. But without concat is possibility to convert this data to a text?
And unfortunatly your proposal of solution dont work or I made somthing wrong.
Data to ComboBox5 is from colection which look like:

Miasto: Obszar:
Gdańsk Osowa,Centrum,Wrzeszcz
Sopot Górny,Dolny

So I replaced DzielnicaColumnName to "Obszar" And i got notification "Obszar wasnt recognize"

Dzielnica: Concat(ComboBox5.SelectedItems; Obszar & ",")
Pro_User_365 546 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Nacked ,
The issue you're facing with the `Concat` function not recognizing "Obszar" likely stems from PowerApps not recognizing it as a field within the items selected from ComboBox5. This can happen if "Obszar" is not the correct field name within the items or if there's a syntax error.
To address this, make sure that "Obszar" is indeed the field name that contains the value you want to use from the `SelectedItems` property of `ComboBox5`. If "Obszar" is correct, then the formula should look like this:
Dzielnica: Concat(ComboBox5.SelectedItems, Obszar & ", ")

However, if "Obszar" is not recognized, it might be because it is not directly accessible, perhaps due to it being a complex object. In such cases, you should use the `Value` property or another relevant property to access the text within "Obszar". The formula would be:
Dzielnica: Concat(ComboBox5.SelectedItems, YourSubField & ", ")

Replace `YourSubField` with the actual subfield name that holds the text value in your collection. If "Obszar" is a column in a table, you might need to use `YourCollectionName.Obszar`.
Also, ensure you are using the correct syntax for your environment. The semicolon `;` is typically used in some locales instead of a comma `,` to separate arguments in a function.
If these solutions do not work, it might be helpful to revisit the structure of the data source and collection to ensure the fields are correctly named and accessible for the `Concat` function.
Best regards.