web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get cell data as variable
Power Automate
Answered

Get cell data as variable

(1) ShareShare
ReportReport
Posted on by nick9one1 353
I have a flow where I'm extracting two tables from a PDF. the first table contains some basic account information. 
 
I need to extract the account number and save it as a variable to use elsewhere. It is always in the same cell in the table (column 2 row 2). How do I extract this? 

Categories:
Power Automate Desktop
I have the same question (0)
  • Suggested answer
    eetuRobo Profile Picture
    eetuRobo 4,522 Super User 2026 Season 1 on at
    In regular Power Automate Desktop flow its very straight forward.  You just use %DataTable[1][1]% to read the second column in second row (its zero index so first row and column is 0). So I think in your case %CurrentTable.DataTable[1][1]%
    Or if you loop it then in currently looped datarow you access the second column like so: %CurrentRow[1]%

    But if you know that the table is always lets say second table then you can remove the for each loop and just extract the value with single set variable:
    %ExtractedPDFTables[1].DataTable[1][1]%
    So thats second tables second rows second column value.

    In Power Fx enabled dekstop flow would use: =ReadCell(DataTable, 2, 2) to read second row and second column (power fx read cell is not zero based index)

     
  • nick9one1 Profile Picture
    nick9one1 353 on at
    thank you. That's exactly what I wanted to know. I can make the flow a lot more simple and remove the loops.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans