web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to make a collecti...

Power Apps

Answered

How to make a collection from semicolon separated values

(0) Share

Report

Report

Posted on by JK-20111451-0

31

Hi there,

I'm quite new to Power Apps, and I was wondering, if there is a possibility to create a collection in Power Apps canvas app from values, which are separated by semicolon on a single row. The semicolon-separated values are now saved in the SharePoint list in a single column. I've tried to explain my goal in the following picture:

Does anyone know how this can be achieved in Power Apps?

Many thanks for your support.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @janklaska ,

Try this - you will need to add your data table name and field names.

ClearCollect( colAll, Ungroup( Ungroup( ForAll( YourDataHere As _Data, Table( { Field: _Data.YourField1, Code: Split( _Data.YourField2, ";" ) } ) ), "Value" ), "Code" ) )

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
JK-20111451-0 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Lovely, @WarrenBelz, kudos to you! Works smoothly. Many, many thanks! 👍

Join the conversation