Answered

Converting a column of tables into a column of text

(0) Share

Report

Posted on by HelloThereAll

I'm having a problem where I am supposed to be able to search through data in a collection from a SharePoint list, but some of the columns have type Table, and I'm trying to convert them into a format that can be searched through and the collection ultimately exported into CSVs, so I need to convert the columns of type Table to columns of type text. Does anyone know how to do this? I've found instructions for individual columns of text into a single string, but not a column of Tables into a column of text.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @HelloThereAll ,

You need the Concat() Function

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
HelloThereAll 82 on at

Like (0)

Report

Can you be more specific, @WarrenBelz? I'm trying to figure out how to reformat a column of tables in a collection to a column of single-line text.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
@HelloThereAll ,

Did you read the guidance I referenced?

If you want commas in between for instance on a field Widgets.Value it would be

Concat( Widgets, Value & "," )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

HelloThereAll 82 on at

Like (0)

Report

There turned out to be two different solutions in the creation of new columns, depending on the circumstance:

1. For columns that were multiple selection, I added a new column with the following value:
Concat(ThisRecord.'Old Column'.Value)

2. For columns that had subfields, like Person columns, I used direct string manipulation:
"Email: "&'Old Column'.Email

I then removed the old columns.

Was this reply helpful? Yes No