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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Excel Rows as List

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

I have a flow where I need to read from Excel and do data entry into a company program. Each row represents one data entry with 6 columns. Basically in the program: 1. Create new record. 2. Enter the 6 columns into the respective data entry boxes within the program. 3. Click an 'Add' button. 4. Move to the next row in the Excel sheet and repeat. 

 

I am struggling to figure out the read as a list function to where PAD will read the whole row and fill in the data boxes and move onto the next row. Does anyone know how to achieve this?

I have the same question (0)
  • Henrik_M Profile Picture
    2,021 Super User 2024 Season 1 on at

    Read from Excel worksheet ('All available values' will probably work) and then a For each loop on the %ExcelData% variable.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you for your suggestion! I'm slightly new to PAD development so how would I get the loop to move through the columns on by one per row entry and get/copy A1 and write to a text box, then B1 and write to a text box, then C1... and so on. I'm guessing I would need to set and increase the variable within the loop?

    kirabray_0-1657122343502.png

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    If you want to move through columns within a row, you can use the column name or column index for that

     like u can use %CurrentRow[0]% to get the row first column value, %CurrentRow[1]% to get the second column row value etc.

     

     

  • AS-06081019-0 Profile Picture
    1,738 Super User 2024 Season 1 on at

    @Anonymous  In addition to the suggestions provided above, please refer this video: https://www.youtube.com/watch?v=NmSCxexNItE

    It should solve your purpose.

     

    Hope it helps!!

     

    Cheers,

    Ankesh

    --------------------------------

    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 238 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 225

#3
Haque Profile Picture

Haque 181

Last 30 days Overall leaderboard