Desktop - Extract specific row and column values from Excel

[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!

[yasunm02 · Accepted solution]

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

[dashort]

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

[dashort]

 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.

[yasunm02]

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

[dashort]

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. 

[yasunm02]

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

[dashort]

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

[yasunm02 · Accepted solution]

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.

[Ahammad_Riyaz]

Hi @dashort 

Please check on this

%ExcelData[Row][Column]%

[dashort]

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

[MarioOne]

Hey All, I found this topic relevant to the use case I am investigating here on this community.

Can you suggest how to structure the query in this flow?