Answered

Split a Long String in Table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have this long string that I want to convert into a table with two columns (name and price). I used ":" and ";" in the string so I wish these were the separators. So, the string, for example, is: "banana: 40; apple:50; coconut: 30;"

This way I want the name appear in a column and the price in the second one. I was able to develop a listbox where each "name: price" was in a row by using the Split function. So, do you know how can I do this?

Does someone knows how I can do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi! You could try something like:

ForAll( Split(*YourString*, ";"), { Name: First(Split(ThisRecord.Value, ":")), Price: Last(Split(ThisRecord.Value, ":")) } )

Placing this inside a Collect statement, or something similar, will return a table with the data formatted as you specified.

Was this reply helpful? Yes No
Verified answer

Talha_Dar 870 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

You can use the following code on a button or in the OnStart property of your application to create a collection from a string.

ClearCollect( records, ForAll( Split( "banana: 40; apple:50; coconut: 30;", ";" ) , If( !IsBlank(ThisRecord.Value), With( { record: Split( ThisRecord.Value, ":" ) }, { Name: First(record).Value, Price: Last(record).Value } ) ) ) )

Now, just use "records.Name" or "records.Price" on your listbox to populate them with the specific details.

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you. It really worked. I just had to change the names to the real scenario and use gallery instead of datatable.

Thank you.

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the feedback! I'm glad to hear that the solution worked for you. If you found it helpful, please consider giving it a thumbs up. If you have any more questions or need further assistance, feel free to ask.

Was this reply helpful? Yes No