How to make a collection from semicolon separated values

Like (0) Share

Report

Posted on 15 Apr 2024 11:34:40 by JK-20111451-0

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.

All responses (2)

Answers (1)

JK-20111451-0 31 on 15 Apr 2024 at 13:11:21

Like (0)

Report

Re: How to make a collection from semicolon separated values

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

WarrenBelz 149,221 Most Valuable Professional on 15 Apr 2024 at 12:05:41

Like (1)

Report
Re: How to make a collection from semicolon separated values

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