Create a column of values from a column of comma separated string

(0) Share

Report

Posted on by kccchiu

Hello all,

In a collection called mergedData contains different columns.

I have a column named Tag that allow a row to contains multiple values (Choices from Sharepoint) such as this one:

I also have a column named UserTag that contains multiple values but as a string:

I would like to add a column to the collection that has the same data type as Tag but for UserTags. Is it possible?

Thanks in advance.

Thanks,

Kin

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@kccchiu

As I'm only on my mobile I can't verify the Syntax but try something like

Set(mergedDataV2, AddColumn(mergedData, tagRecordColumn, Split(UserTag, ",")))

Was this reply helpful? Yes No
kccchiu 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply, but I have built quite a lot of things around the mergedData collection and would like to have the new column in the mergedData collection.
I have tried your formula but had some error.

Thanks,
Kin

Was this reply helpful? Yes No
kkowal 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! What kind of type is the UserTag field? Is it a simple String? or is it an Object? Can you post the line of code how you created it? I think this would help us to help you 🙂 With regards PowerCorner

Was this reply helpful? Yes No
kkowal 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! What kind of type is the UserTag field? Is it a simple String? or is it an Object? Can you post the line of code how you created it? I think this would help us to help you 🙂 With regards PowerCorner

Was this reply helpful? Yes No
kccchiu 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Thanks for the reply.
The UserTag field is just a string and it follows a pattern like:
string1, string2, stringn

The UserTag column is from a sharepoint list, and the type of column is single line of text.
I had to work with different sharepoint list so I had to merged 2 lists into a collection.

Thanks,
Kin

Was this reply helpful? Yes No
kkowal 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay, so you should first split the UserTag with the Split(UserTag,",") function. Then you will have a collection of strings.

But wait... so you have two different lists. So dont merge the UserTag directly with the tags. First split them and then merge them with the tags!

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@kccchiu

Once your mergedData Collection got created you can't add any new columns. Thats simply not possible.

I have tried this:
ClearCollect(mergedData,mySharePointList); ClearCollect(mergedDatav2,AddColumns(mergedData,"UserTagAsRecord",Split(ThisRecord.'UserTag',"-")));
mergedDatav2 is identical to mergedData but has the addition UserTagAsRecordColumn

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
kccchiu 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply.
I tried your formula and got this result:

Is it possible to achieve this?

<-- I used paint to illustrate the result I want.

Thanks,
Kin

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@kccchiu

The only difference is that using my formula the field UserTagRecords is a Table and you want it to be Records.
I actualy can't see any benefits.

You might be confused because it still shows as comma separated values but this is not th case.

Add a Gallery and use mergedDatav2 as the datasource. Add a second Gallery and use Gallery1.Selected.UserTagRecords in the Items Property. You will see you get each item displayed in a separate row.

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
PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No