Send an e-mail at x5 roll-up column

(0) Share

Report

Posted on by 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?

All responses (6)

Answers (2)

Suggested answer

Bipin D365 28,959 Super User 2024 Season 1 on at

Like (1)

Report

RE: Send an e-mail at x5 roll-up column

Hi,

Again same issue, you have modified your variable name to 'Count Initialize Variable' but in your expression you are still using 'Initialize Variable'.

Please modify your expression as below-

Mod(Variable('Count_Initialize_Variable'),5)

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/
SergeP 52 on at

Like (0)

Report

RE: Send an e-mail at x5 roll-up column

OK, we are slowly getting there.

Error details:

Unable to process template language expressions for action 'Condition' at line '1' and column '17312': 'The template function 'Variable' is not defined or not valid.'.
SergeP 52 on at

Like (0)

Report

RE: Send an e-mail at x5 roll-up column

Thank you Bipin.

First point OK.

Second point: of course, why was I thinking of a Switch, where you can just use a second condition and the Yes/No path.

You helped me as well.
Verified answer

Bipin D365 28,959 Super User 2024 Season 1 on at

Like (1)

Report

RE: Send an e-mail at x5 roll-up column

Hi,

For the first issue you would need to modify the expression -

Mod(Variable('Initialize_Variable'),5)

because your variable name is different than given in example by Nya.

For the second question - you can achieve using Two Condition expression.

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/
SergeP 52 on at

Like (0)

Report

RE: Send an e-mail at x5 roll-up column

Hello Nya,

Already a big thumbs up for your fast and great answer. Helped me already a lot. You are great.

Now I have been building and have a couple questions left.

I got an error, given the variable isn't initialized. But this is done in the previous step.

Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidVariableOperation' and message 'The inputs of workflow run action 'Condition' of type 'If' are not valid. The variable 'Get Number of Games Played' must be initialized before it can be used inside action 'Condition'.'."}}". Code: 0x80060467 InnerError: '.

Then I had one final question.

I would need to send 2 emails, based on the Age of the contact.
So a switch would be in order. One if he is <= 15, the other version >15 years.
We have a calculated field to get the age in years.
Verified answer

Nya 29,058 on at

Like (2)

Report

RE: Send an e-mail at x5 roll-up column

Hi Serge Pilaet,

First of all, a rollup field cannot be used to trigger a flow or workflow.

So you need to create a new field and set a business rule for it to pass the value of the rollup field to it.

For example, there is a rollup field to count the number of the contacts named as "Count of contacts"/ "new_countofcontacts".

The new field is named as "Count of contacts1"/ "new_countofcontacts1", whose value equals to the value of the rollup field.

Then create a flow triggered when the new field is modified.

Initialize it as a variable.

Add a condition to send an email if this variable is divisible by 5. The variable can be inserted into the content of the email directly.

Then when the count of the contacts hits 5, the email address of the account will receive a notification email.