Answered

List of item to Datatable

(0) Share

Report

Posted on by deerzzxdell

Hi all I hope you can help me with this

I have a list in the image.

And I want to insert them in a data table which has 3 columns. Item 0, 1 ,2 will be in the first row 3, 4, 5 will be in the second row and continue like this.

I have created the data table and try to use loop with insert row to data table but still doesn't work out.

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Try using Join text with a white space as a delimiter. This will result in a single string. Then use Parse text on the joined text with regular expressions, using \d+\s[A-Z]+\s[A-Z]+ as the pattern. Make sure you un-tick the checkbox that says "Find first occurrence only", so it returns all matches. This will result in a list where every item will contain 3 items from your original list like this:

00095296810000 PRIIND ST

00980563266000 PRIIND ST

01180006007000 PRIIND ST

With this, you can use a For each loop on the Matches and you can use Split text on each current item, using a white space as the delimiter. You can then use Insert row to data table and use the output of Split text as the row to insert.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
deerzzxdell on at

Like
a
(0)

Report
Copy link

Link copied!

hello, thank you for providing the solution! Everything seems fine at first but when I look through the output data after I use parse text there's some error.
This image is the data that parse text return in matches

And this is the data before I use parse text.

As you can see, in item#3 it should be 'ST' not 'DB'. 'DB' should be with item#4.
deerzzxdell on at

Like
a
(1)

Report
Copy link

Link copied!

I can fix it by myself now. Thank you!