web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Help needed for list v...

Power Automate

Unanswered

Help needed for list variable

(0) Share

Report

Report

Posted on by adelevance1

20

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 Img

All responses (2)

Answers Img

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

Join the conversation