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 Platform Community / Forums / Power Automate / Want to loop through E...
Power Automate
Unanswered

Want to loop through Excel Online Table Rows, using values in certain column as input for action

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

So I have a Table in an Online Excel file, with a single column, called "Column1" - what I want to do:

- for each row in the table

- read the value in column 0 of the row

- if it is empty, do nothing

- if it is non-empty, send it as the subject of an email

 

So if a Table has 5 rows where column 0 is non-empty, I should get 5 emails, each one with the subject as one of the column 0 cell contents.

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    Could you please show a bit more about your Excel table?

    Where are your Excel file stored?

    Further, could you please share a bit more about the column 0 within the following statement?


    @Anonymous wrote:

     

    - read the value in column 0 of the row

     


     

    I suppose that you want to read the value in Column1 of each row, is it true? I have created a Excel file (whose data formatted as a table) in my OneDrive for Business folder.

     

    I have made a test on my side and please take a try with the following workaround:

    • Add a proper trigger, here I use Flow Button trigger.
    • Add a "Get rows" action, specify File Name and Table Name.
    • Add a "Apply to each" action, input parameter set to output of "Get rows" action.
    • Within "Apply to each" action, add a Condition, click "Edit in advanced mode", type the following formula:
    @empty(items('Apply_to_each')?['Column1'])

    Within "If/no" branch of Condition, add a "Send an email" action, Subject field set to Column1 dynamic content of "Get rows" action.

     

    Image reference:2.JPG

    The flow works successfully as below:3.JPG

     

    Best regards,

    Kris

     

     

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Briliant, this worked, thanks - I was using "List All Rows" instead of "Get Rows" - what is the difference?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Okay, so the next thing I need to get right. I want this to run every 4 hours:

     - read each row from the Excel table (working)

     - each non-empty row is the address of an RSS Feed

     - watch each of those feeds for new items

     - email each new item link as an email

     

    I've got it working once-off (i.e. read the excel rows once, then continuously scan for new items) - but I need to refresh the read of the Excel file every 4 hours, so that any news feeds added to it will be updated. What makes it tricky for me is that the "When a Feed Item is Published" action is a continuous action that never terminates and moves onto the next step?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @v-xida-msft. I don't see GET ROWS for Excel Online. Only GET A ROW. 

    How does one loop through an Excel Online sheet when it wants a Key and Key ID for a single row? I can't seem to find a way to put For Each in there.

     

    Thanks

  • DAGEM Profile Picture
    30 on at

    There's an Action you can search for called Recurrence. This allows you to determine a time frequency for triggering the flow (make sure Recurrence is at the top of your flow). 

  • cfh4030 Profile Picture
    6 on at

    Hello,

    I see you have a "Get rows" action. I only have "Get a row" available. Is "Get rows" a premium feature?

  • RomanTech Profile Picture
    2 on at

    EDITED: Accidental thread jack, I meant to create a new post. My problem is similar: https://powerusers.microsoft.com/t5/Building-Flows/Excel-Read-cells-that-contain-usernames-and-passwords-Log-into/m-p/1795769**

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

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard