I have a process that extracts data for 29 locations from a SharePoint List, puts that data into an excel spreadsheet and send that data to a supplier. Each spreadsheet must be individual based on the location so I do a for each on the same sheet that builds the spreadsheet each time, attaches to an email and sends. To this enad I have multiple flows that do the same thing for other reasons
I have had issues where the supplier denies they get some of the orders. I can see that it was sent but obviously cannot dispute unless I have a read receipt. Read Receipt in problematic as it can be turned off as well as the supplier might not use outlook.
So I tried an emal with options which i thought would do the trick. The problem now is the for each does not repeat until the mail is actioned by receiptient, then it does the next This not practical as this relies on an intervention of which i have no control in time and space. I cannot add a parrellel branch as there would be 29 and they all access the same excel sheet so I belive would not work.
Does anyone have ideas how this can be achieved?
