Unanswered

get row values from data table

(0) Share

Report

Posted on by ps_noob_to_pro

I want to get row values from data table.

Since I want to get multiple rows i am using this syntax - %ExcelData[%rowIndex%]%, but this is not a correct syntax, I don't want to send the index value directly like - %ExcelData[3]% , I want to make it dynamic.

PS - Starting with my new journey in Power Automate (PA), I already know UiPath, but things are different here. I’m determined to become a master in Power Automate as well. Cheers!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@ps_noob_to_pro

Please find the some different syntaxes to read datatable values

Fetch DataRow based on Index(Index starts from zero):

%ExcelData[rowIndex]% - This will return the DataRow of your DataTable.

Fetch Specific column value based on Row and column Index (Both index starts from zero):
%ExcelData[rowindex][columnindex]% - It will return value of specific column

Using foreach loop:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

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

Like (1)

Report

Hi @ps_noob_to_pro

The syntax needs row index and column index

%Exceldata[rowindex][columnindex]%

In this way you need to give the both indexes row index and column index

Hope this helps

Usha

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

Like (1)

Report

@ps_noob_to_pro

If you want to loop you can use for each

Then there will be current item

Currentitem gets the full row and

Currentitem[columnindex or columnname].

Hope this helps

Usha

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

Like (0)

Report

Hi @ps_noob_to_pro

If your questions is answered and solved then please close the loop by marking the solution and close the loop.

Was this reply helpful? Yes No