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.
Above is my subflow where I loop through the data.
Here is the message that I am using to make sure I am pulling my data from the correct sheet.
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!
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
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.