I've created a flow to filter branch names from an Excel sheet and select corresponding data. Then, I use the "Send an email with options" action to email users based on the filtered data. I've included a "Filter array" action and "Send an email with options" action within an "Apply to each" loop to handle each branch name individually.
However, when I add the "For loop" action and disable concurrency control, emails are sent sequentially. When I enable concurrency control and set it to 50, the flow remains pending because the number of sent emails is less than 50. Unfortunately, I can't specify the number of emails since it's tied to dynamic data in the Excel sheet, which changes unpredictably.
Thank you.
