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!
In case its of any use to people I created a similar flow to this and documented it here - https://www.cloudbliss.net/post/integrating-excel-with-hubspot-using-power-automate
if i want write 2 data in specific column how can i do ,cuz my step too much
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?
Brilliant! Thank you for getting this sorted. I appreciate your persistence!
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.
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....
Correct syntax is %ExcelData[RowVariable][2]% in this case.
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.
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]%.
eetuRobo
11
Super User 2025 Season 1
KO-05050229-0
4
Brad Darragh
4