Unanswered

Help needed for list variable

(0) Share

Report

Posted on by adelevance1

Hi there,

After I did some web scraping action in desktop flow, Data were stored in a variable as table with six column structures as follows.

However, in order to change this to a three-column structure, I would like to insert the data of the fourth, fifth, and sixth columns below the data of the first, second, and third columns. So I tried to create new data table action and then insert rows to data table action as well.

If the variable name is %ExtractedData%, %ExtractedData[0]% will be the data in the first row, but how do I load the data in the first column instead of the row?

Any comments would be appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

julia5306 29 on at

Like (0)

Report
Copy link

Link copied!

You could try using a "for each" to do this, in which case %ExtractedData[0]% would be all the rows in the first column, hence the first column, rather than the first row. It's a bit counter-intuitive, but if you use a For Each CurrentItem in ExtractedData, then within the loop use CurrentItem[0] to iterate through the first column, it should work!

Was this reply helpful? Yes No
Prabu 55 on at

Like (0)

Report
Copy link

Link copied!
Hi @adelevance1

try this format to retrieve the column specific data
%ExtractedData[row][column]%

Example
%ExtractedData[0][0]%

Was this reply helpful? Yes No