Unanswered

How to loop through data in a column?

(0) Share

Report

Posted on by Nivedhana

I have a list of products stored in a table. I need the power automate desktop RPA to loop through the column names and get data into this table from another table. How can we achieve this?
Tried a for each loop, but it does not loop the data.

Screw	Bolts	nuts	Spanner	Bushes

Categories:

Power Automate Desktop

I have the same question (1)

All responses (3)

Answers (0)

UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

Read the data and store into va variable for example exceldata
If the column names are static with their positions then you can check with
Exceldata[0][0]
Exceldata[0][1]

Hope this helps
Usha

Was this reply helpful? Yes No
UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

Id you loop through the data table obviously you can loop through the rows and columns

For further clarification please provide some more info about your requirement

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

If the table headers are are actually stored as headers, you can access them as %DataTable.Columns% (will return the names of the columns in a list variable) or %DataTable.ColumnHeadersRow% (will return the names of the columns in a datarow variable). You can then iterate through them using a loop or a For each.

-------------------------------------------------------------------------
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.

Was this reply helpful? Yes No