Hello Power Automate community! I need a bit of help on a flow I’m trying to work out. We have a new starter spreadsheet where new starters are assigned to specific staff members depending on which department they’re in. All I want to do is have a flow that will send an email to that particular staff member to let them know that they have been assigned a new starter.
So far I have been able to get it to send the email to the specific staff member, but the flow kept repeating. After some digging around I found that I needed a second “processed” column, which could show as processed once the email has been sent. The flow then would only trigger if the processed column states “no”. The problem I have now is that this only runs for the first row, so if it sees a row with processed in it won’t run on any of the rows below even if they are marked as a “no”. Has anyone been able to make a flow work for multiple rows?
