How convert text to datatable?

(3) Share

Report

Posted on by dominono9

I want to convert text to datatable

Please tell me how to do?

↑ to ↓

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

VJR 7,635 on at

Like (1)

Report

Use loops, string functions, split, etc on your textlist variable.

You have to form a string like %{ ^['ColumnName1', 'ColumnName2'], ['1', '2'], ['3', '4'] }%

And then pass it to Set variable

The output of this set variable will be a datatable

Was this reply helpful? Yes No
Verified answer

AutomateWithDev 30 on at

Like (6)

Report
Hi @dominono9

You can build a flow as shown below:

Here, first I have created a data table with the column headers using the following expression in a 'Set Variable' action:

%{ ^['Column 1', 'Column 2', 'Column 3'] }%

Then, I split my text into a list with New Line as separator using a 'Split Text' action to create a list with each of the row elements in the text file:

Next I iterate within this list element and the again use a 'Split Text' action for splitting the current row item with a comma separator:

For each iteration I will get a list called as TextList as shown below:

Now, in the end I just use a 'Set Variable' action again to add a new datarow consisting of all the items in the newly generated list to my original data table variable with the following expression:

%DataTable + [TextList[0], TextList[1], TextList[2]]%

My final output is as shown below:

------------------------------------------------------------------------------------------------------------------------------
If this post helps you with your problem, please mark your as Accepted solution. If you like my response, please give it a Thumbs Up.
------------------------------------------------------------------------------------------------------------------------------

Was this reply helpful? Yes No
dominono9 83 on at

Like (0)

Report

Thank you very much. I Understand!

Was this reply helpful? Yes No
GucluGunduz 12 on at

Like (0)

Report

I have a variable number of data in my Excel table. While there are 11 data in some rows, there are 15 in others. If I keep the number low in the last "set variable" line where we print the data to the test lists, it does not include excess data, but if I make it high, this time it gives an empty directory error. how can i fix this

Ekran görüntüsü 2...

Was this reply helpful? Yes No