So i have been building a flow for an approval process for new hires thats salary is over budget. The structure of it is that it starts in Finance then to HR, but if either finance or HR rejects it, it gets routed to the CEO to approve. I have all of this working but now my issue is if there are multiple people on the excel table that are over budget, it only grabs the first one. I want it to where it sends out a separate approval for each person.
I have it bulit if there is only one person who is over budget on that sheet. I am thinking what needs to change is that i use "Get a Row" from excel, but i couldnt find an alternative. Below is what my current flow looks like and the excel table i am using. On the excel table, the column is a yes or no, "yes" if it is over budget.