Skip to main content

Notifications

Power Automate - Power Automate Desktop
Answered

Get cell data as variable

(1) ShareShare
ReportReport
Posted on by 259
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:
  • nick9one1 Profile Picture
    nick9one1 259 on at
    Get cell data as variable
    thank you. That's exactly what I wanted to know. I can make the flow a lot more simple and remove the loops.
  • Verified answer
    eetuRobo Profile Picture
    eetuRobo 2,687 on at
    Get cell data as variable
    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)

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard