web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Split values in a colu...

Power Apps

Answered

Split values in a column by comma and put all split values in a new column

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have the following table

ClearCollect( Products;
 Table(
 { Product: "Widget, Luke"};
 { Product: "Gadget"};
 { Product: "Gizmo"};
 { Product: "Apparatus, Peter, Ab"}
 )
);;

I want to split each record by comma and return a single column that contains all split values like this:

Product
Widget
Luke
Gadget
Gizmo
Apparatus
Peter
Ab

I have tried a lot of things, including asking ChatGPT but I didn't manage to get a solution. Please help me out.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

This should do it

Ungroup( ForAll( Products, Split( Product, "," ) ), "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.

MVP (Business Applications) Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot!

Join the conversation