cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahmedadly2
Regular Visitor

Multi-line text to Table/Collection

Hello All,

 

I am building a PowerApp that can convert from Multi-line text to a Table/Collection as follow

Street;HouseNumber;City,
BilkStr;99;Frankfort,
KarlStr;80;Köln,
...;.....;......

I wanted to convert it to a DataTable like this

StreetHouseNumberCity
BilkStr99Frankfort
KarlStr80Köln
............


How this could be achieved using ForAll, split .. etc ?

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@ahmedadly2 

The Split() function would be used on each record to create the columns.  See https://www.youtube.com/watch?v=sj-UDq8Iuow to see how to create the collection from the columns. 

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

@ahmedadly2 

The Split() function would be used on each record to create the columns.  See https://www.youtube.com/watch?v=sj-UDq8Iuow to see how to create the collection from the columns. 

View solution in original post

v-bofeng-msft
Community Support
Community Support

Hi @ahmedadly2 :

Sorry,I just noticed that @Drrickryp  has already replied to you, I suggest you consider his suggestion first. You could consider this plan as an alternative reference:

Although the use of split should be able to achieve your needs, but the formula will be more complicated. I suggest you try to use flow:.I've made a test for your reference:

1\Create a flow:

vbofengmsft_0-1626310053797.png

2\Add the flow into powerapps

vbofengmsft_1-1626310782583.png

3\Add a button and set it's OnSelect property to:

 

 

ClearCollect(TheTable,'PowerAppV2->ParseCSV'.Run("Street;HouseNumber;City,
BilkStr;99;Frankfort,
KarlStr;80;Köln,"))

 

 

The Result:

vbofengmsft_2-1626310929067.png

Best Regards,

Bof

 

 

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,906)