You’re offline. This is a read only version of the page.
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!
If your questions is answered and solved then please close the loop by marking the solution and close the loop.
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
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
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 🚀
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (