Skip to main content

Notifications

Power Automate - Using Connectors
Answered

looping through data from an excel sheet

(0) ShareShare
ReportReport
Posted on by

Hello,

I have an excel sheet with multiple tabs that I want to loop through data and based on whether a cell is empty.  My thought was that I could grab the data in a tab and then use a "for each" loop to go line by line.  I set an index for the specific cell I am looking at and have a display message to show me the values as a way to check the information.  I checked to make sure I am grabbing the data from each tab but I dont know if there is a way to step through and identify where I am at in the sheet because my message keeps coming up as blank.  

ryanBourbon_0-1625767189794.png

Above is my subflow where I loop through the data.

ryanBourbon_1-1625767293797.png

Here is the message that I am using to make sure I am pulling my data from the correct sheet.

ryanBourbon_2-1625767410397.png

This is the message where I am trying to display the specific row information based on the current item in my loop.

 

I do not believe I am looking through the right data because I can watch it loop through and not capture rows that it should based on a count.  

Any help is appreciated.

 

Thanks!

 

  • v-LilyW-msft Profile Picture
    v-LilyW-msft on at
    Re: looping through data from an excel sheet

    Hi @Anonymous 

    Thanks for your posting here and sharing the resolution in the forum as it would be helpful to anyone who encounters similar issues.

    Best Regards

  • Verified answer
    Re: looping through data from an excel sheet

    Due to the data validation in excel the cell is not actually blank so I adjusted to check for a dash in the cell as a start of the cell content.  This corrected the issue.

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics