Concat/Concatenate a single column of a data table with multiple columns

(0) Share

Report

Posted on by AndyH_JSY

Hello!

I have an app that has an Excel table as the backend data source.

Some of the fields are 'Customer Name', 'Location Name' and 'Device Name'. I have a Combo Box in PowerApps that has Customer Names, this, in turn, filters the Data Table in PowerApps to show the devices and locations only specific for that customer.

The user can then select multiple 'Devices Names' in a separate Combo Box, this works fine, and I have a Concat function that splits out the Devices Names from the Combo Box.

This leaves a column in the Data Table called 'Location Name', I want to be able to do the exact same Concat function I did on the Combo Box, so the locations will list (eg, Location A, Location B, Location C) this can be in any order.

Any suggestions are greatly appreciated!

Thanks in Advanced

Andy!

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

Community Power Pla... on at

Like (0)

Report

I tried this...maybe not the best way but it worked for me.

Combobox On Change - ClearCollect(collection, ComboBox.SelectedItems.Device)
Label Text - Concat(collection,Location,", ")

Was this reply helpful? Yes No
AndyH_JSY 84 on at

Like (0)

Report

Thanks for your reply!

What I am trying to do is Concat the fields within the Data Table, instead of the Combo Box.

Here is my Data Table (attached):

What I am trying to do is Concat the 'Device Location field into a text box. So the text box would display 'Newcastle, Isle of Man' etc.

Ideally, I'd like to remove duplicates but this isn't required.

Thank you!

Capture.PNG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How do you want to display the locations? In a label, etc.?

Was this reply helpful? Yes No
AndyH_JSY 84 on at

Like (0)

Report

I've just edited my post as it wasn't displaying correctly. Hopefully, that is clearer!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think my first suggestion will still work.

Set the On Change property of the Device Combobox to collect the locations of the selected devices, then concat the collection datatable into the text box.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

To remove duplicates you can use distinct in the textbox/label Text.

Concat(Distinct(collection,Locations),Result,", ")

Was this reply helpful? Yes No
AndyH_JSY 84 on at

Like (0)

Report

The issue is I am unable to collect the location names with the Collect function from the data table -

ClearCollect(Collection, DeviceNameInput.SelectedItems.'Device Name') //This is only collecting the selected items in the Combo Box, whereas I would like to Collect the Items in the 'Device Location' column of the data table.

I do believe the Concat(Distinct(collection,Locations),Result,", ") will work, however, I cannot get them into the Collection first.

Trying to do ClearCollect(Collection, DataTable1.Selected.'Device Location') but it doesn't like this.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

If you copied from the editor, try changing the Device Location code to SelectedItems and not Selected. Thats what Im doing in my test and it works.

Was this reply helpful? Yes No
AndyH_JSY 84 on at

Like (0)

Report

I was trying this earlier, but for some reason SelectedItems is not an option for the DataTable?

See attached for OnChange property.

Capture.PNG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have the combo box set to Item Name, but I'm collecting the Brand Family of the Selected Items On Change of the combo box.

Then I'm concatenating the distinct results of my collection in to a label.
You can see here that there are duplicates in the collection.

Was this reply helpful? Yes No