Split a string and store it into 2d collection

[IAmTheAppUser]

I have a string passed from flow. 

I can define the string passed from flow to powerapp to whatever format I want but the current format it below:

number/streetname/suburb/state/postcode|number/streetname/suburb/state/postcode|number/streetname/suburb/state/postcode

String Explanation:

- different addresses are separated by |

- different part of an address is separated by /

- There can be 20 of addresses (so 20 rows in the collection as the final result) but the format is the same.

Expected end result:

- different addresses is showing on different rows

- every row has 5 text block showing different parts of the address

Thanks for the help 🙂

[RezaDorrani · Accepted solution]

Hi @IAmTheAppUser 

ForAll(Split(TextValue,"|"),Collect(dataLoad,{Number:First(Split(Result,"/")).Result,StreetNumber:Last(FirstN(Split(Result,"/"),2)).Result,Suburb:Last(FirstN(Split(Result,"/"),3)).Result,State:Last(FirstN(Split(Result,"/"),4)).Result,PostCode:Last(Split(Result,"/")).Result}))

TextValue - is the value returned from PowerApps

dataLoad - is the name of the collection

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[IAmTheAppUser]

Awesome! It worked. Thanks a lot !