Send an e-mail at x5 roll-up column

[SergeP]

Hello,

for a solution, I need to build an automated e-mail send.
This on the contact entity, each time, when a roll-up column hits 5.
So when it adds up to 5, the e-mail needs to be sent.
But also at 10, 15, 20, ...

The e-mail template will always be the same, only do I need put that Roll Up column on the template

Any suggestions?

[AJ_Z · Accepted solution]

So realistically this is a power automate solution. Scheduled flow run once per day is what i am thinking
Then use list rows to list the rows then a conditon to see if the roll up column is not null/blank or equal to 0 then check if it is divisible by 5 with no remainder. I am guessing the best way to check that is with the Mod function e.g. Mod(Columnname1,5) is equal to 0 if all true use the send email action insert email template and list rows should put this into an apply to each which will allow you to populate the column into the email template. 

I really do not think this should be a power app as it will require someone going into the app on a regular basis whereas you could just automate this with a power automate. 

let me know if you have further questions or need me to go into further detail but if you still want the instructions for how to do this as a powerapp instead of automating this i can still give you that just reply to this 🙂

[SergeP]

Thank you.

Indeed it is better at the Power Automate community. Sorry I'm new here.
But you described it correctly what they suggested as a solution over there 😀

[AJ_Z]

No worries at all @SergeP there is always a bit of crossover now and then and everyone is new at one point :). I am always hap to help. Good luck with your solution and take care