I built a flow that looks at a SharePoint list column (Contract Ending Soon). If the value is No, then the flow sends a customized email matching specific criterion. For example, if the contract is not ending soon and the date value in one of the fields matches a certain date, then the email sends. That. part works fine The issue I'm having is that when all of that applies, it is sending the email 3 times. I saw some other posts about initializing a variable, but I'm not sure how to modify that to my situation.
Solved! Go to Solution.
Hello @wilson16 ,
I'd guess the issue is in the in the 'Apply to each' parallel branches after the 'Compose 2' action. You're already looping through all the results from 'Get items' in the first 'Apply to each', you don't need to loop through them again inside the loop, that is sending the multiple emails.
After the 'Compose 2' I'd remove all the 'Apply to each' actions and use 'Switch' action based on the specific criteria and send a corresponding email.
Hello @wilson16 ,
I'd guess the issue is in the in the 'Apply to each' parallel branches after the 'Compose 2' action. You're already looping through all the results from 'Get items' in the first 'Apply to each', you don't need to loop through them again inside the loop, that is sending the multiple emails.
After the 'Compose 2' I'd remove all the 'Apply to each' actions and use 'Switch' action based on the specific criteria and send a corresponding email.
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
136 | |
55 | |
47 | |
36 | |
25 |