I have a Flow which gets excel data from a spreadsheet saved in Sharepoint, groups the data by recipient and sends it in a table to the recipient via Teams once a week. There is typically anywhere between 300 and 500 rows which are grouped and sent to up to 240 different recipients. Unfortunately however, every week the Flow fails to a number of these recipients, it is a different number of people every week. I then have to go through the failed Flow, identify the people it failed to, update the spreadsheet with only these people and rerun the Flow, the subsequent Flow then always succeeds to these. Is there a work around for this so that all messages go out to all people the first time?
