Desktop - Extract specific row and column values from Excel

(0) Share

Report

Posted on by dashort

Hi, I am able to create the table and extract it to a variable - ExcelData.

I want to go through a specific row and extract each column to enter it on a website.

I do not see how to specify the row value in the statements and I'm not trying to run a loop as each row will be entered at different times.

Is there someone that knows the syntax to specify what I would think would look like %ExcelData(Row)(Column) ?

Thanks in advance. This is a really great community!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (13)

Answers (2)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

%ExcelData[Row][Column]%
Variable data types - Power Automate | Microsoft Docs

Was this reply helpful? Yes No
dashort 62 on at

Like (1)

Report
Copy link

Link copied!

Thank you for being patient with a noob and taking the time to show me the answer!

Was this reply helpful? Yes No
dashort 62 on at

Like (0)

Report
Copy link

Link copied!

If you want a curveball, tell me how to enter a variable for the row number 🙂 I've tried %ExcelData[VariableName][2]% but it didn't like the variable and told me that it didn't have a property "4", which was the value for the variable, and the row which I wanted.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dashort
Not sure if that's what you asked, but you can define the variable value by 'Set variable' action under 'Variables' group.
In your case, you have to previously add a 'Set variable' to define %VariableName% with the value you want.
Also, notice that Power Automate Desktop is zero base. So, to get the value of first row and first column in your ExcelData variable, you have to use %ExcelData[0][0]%.

Was this reply helpful? Yes No
dashort 62 on at

Like (0)

Report
Copy link

Link copied!

I was looking for a way to use a variable to specify the row so that I can be more flexible and not tied down to a single entry. I tried %ExcelData[%RowVariable%][2] and it spit out an error.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Correct syntax is %ExcelData[RowVariable][2]% in this case.

Was this reply helpful? Yes No
dashort 62 on at

Like (0)

Report
Copy link

Link copied!

Thanks again for your time. When I put the variable in for the row number, I get told "Variable "ExcelData" doesn't have a property "2". 2 is the value for the variable, so at least it's reading it. I'm not sure how to tell it that I need that particular row number....

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Sorry @dashort, gave the first answer without really testing it. My bad.
I think I was able to replicate your error scenario with this flow:
1) Launch Excel
2) 'Read from Excel worksheet' to get an ExcelData variable
3) 'Display input dialog' to input row number as test (%Row% as output)
4) 'Set variable', to see result of %ExcelData[Row][1]% in Flow Variables panel
Got the same error message you mentioned: "Variable "ExcelData" doesn't have a property "x"".
Problem is, using input dialog in this case resulted in %Row% variable as text type.
So I added a 'Convert text to number' action to convert %Row% into a new variable called %RowNumber%, prior to throw it at an adjusted %ExcelData[RowNumber][1]%.
Worked as desired. Check if it applies to your case and give it a try.

Was this reply helpful? Yes No
Riyaz_riz11 4,048 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @dashort

Please check on this

%ExcelData[Row][Column]%

Was this reply helpful? Yes No
dashort 62 on at

Like (1)

Report
Copy link

Link copied!

Brilliant! Thank you for getting this sorted. I appreciate your persistence!

Was this reply helpful? Yes No