Skip to main content

Notifications

Community site session details

Community site session details

Session Id : fw0bojw3kUoeAdAdv1hcg0
Power Automate - Power Automate Desktop
Answered

Desktop - Extract specific row and column values from Excel

Like (0) ShareShare
ReportReport
Posted on 26 Jun 2021 18:45:08 by 62

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!

  • Stratusit1 Profile Picture
    6 on 25 Mar 2024 at 11:13:16
    Re: Desktop - Extract specific row and column values from Excel

    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 

  • YeuHarng Profile Picture
    48 on 11 Aug 2023 at 09:00:46
    Re: Desktop - Extract specific row and column values from Excel

    if i want write 2 data in specific column how can i do ,cuz my step too much

    YeuHarng_0-1691744423594.png

     

  • MarioOne Profile Picture
    67 on 14 Oct 2021 at 20:41:09
    Re: Desktop - Extract specific row and column values from Excel

    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?

    MarioOne_2-1634244000808.png

     

  • dashort Profile Picture
    62 on 27 Jun 2021 at 18:00:31
    Re: Desktop - Extract specific row and column values from Excel

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

  • Riyaz_riz11 Profile Picture
    2,666 Super User 2025 Season 1 on 27 Jun 2021 at 06:57:56
    Re: Desktop - Extract specific row and column values from Excel

    Hi @dashort 

     

    Please check on this

     

    %ExcelData[Row][Column]%

  • Verified answer
    Community Power Platform Member Profile Picture
    on 27 Jun 2021 at 06:50:02
    Re: Desktop - Extract specific row and column values from Excel

    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.

  • dashort Profile Picture
    62 on 27 Jun 2021 at 04:42:11
    Re: Desktop - Extract specific row and column values from Excel

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

  • Community Power Platform Member Profile Picture
    on 27 Jun 2021 at 00:42:15
    Re: Desktop - Extract specific row and column values from Excel

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

  • dashort Profile Picture
    62 on 27 Jun 2021 at 00:16:44
    Re: Desktop - Extract specific row and column values from Excel

    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. 

  • Community Power Platform Member Profile Picture
    on 26 Jun 2021 at 22:48:44
    Re: Desktop - Extract specific row and column values from Excel

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 11 Super User 2025 Season 1

#2
KO-05050229-0 Profile Picture

KO-05050229-0 4

#2
Brad Darragh Profile Picture

Brad Darragh 4

Overall leaderboard