Process emails

[baessa]

Hello,

I am new in Power Automate. I need some support on processing emails.

I would like to process the emails sent from Veeam once a day (once the backup window has finished) and ensure we have 2 success emails for each job (one for the main backup job and one for the replication job.

We want o get an email daily that will query at certain time to find out whether the jobs have been completed and its status.

EX. I have 12 jobs and from those 12 jobs I would need to have one email stating those 12 jobs and saying that those jobs have been completed successfully, have warnings or some critical. this is for the backup and replication jobs.

job 1 = back successfuly completed  or warning or critical

job 2 = back successfuly completed or warning or critical

job 3 = back successfuly completed or warning or critical

job 4 = back successfuly completed or warning or critical

job 5 = back successfuly completed or warning or critical

job 6 = back successfuly completed or warning or critical

job 7 = back successfuly completed or warning or critical

job 8 = back successfuly completed or warning or critical

job 9 = back successfuly completed or warning or critical

job 10 = back successfuly completed or warning or critical

job 11 = back successfuly completed or warning or critical

job 12 = back successfuly completed or warning or critical

This is for the backup and replication jobs.

Could I have some support on how to create this automation in power automation please and what steps to take?

Thank you,

[baessa]

Could someone supports me on this please?
I have tried to setup but it has been very dificult

[Pstork1]

Yes, this is possible.  But if you don't provide us with the work you've done so far and problems you've encountered, then you are basically asking for someone to do free consulting work and build your flow for you.  Please show us what you have tried and ask for help on issues you are facing.  Don't just give us a scenario and ask for someone to help you build it.

From a high level here's what your solution would look like

1) use a recurrence trigger set to run once a day at the time you specify

2) Get all the emails that were sent from Veeam in the last 24 hours

3) process those emails and keep a count for each of the 12 jobs on successful outcome

4) Send the results of the counts by email.

[baessa]

Hi @Pstork1 ,

This is what I have done so far.

One of the problems is that the subject would contain different jobs names. And I do not know how I can get the message from the body for each job..

The action I know as I want to receive an email with its status but the flows I am really struggling

[Pstork1]

First, I would create 12 integer variables at the top of the flow.  One for each of the12 jobs you want to track.  Then inside the loop you will check the body of the email to see if that email is a succeed or fail.  Then if it succeeded use a switch based on the Subject to decide which counter variable to increment.  After you exit the loop create an email that reports out the counts of each variable.  (You could also put logic in to check the counts and change them to a succeeded or failed text, but that's more work and not really necessary if you report out the counts by job.)

[baessa]

Hi @Pstork1 ,

I will give a try. And let you know the outcome.

Thank you for your support.

[Pstork1]

Reply back when you have more issues to work through.

[baessa]

HI @Pstork1 

Apologises for my late reply. Being busy with other priority tasks.

I have created the variables and add the values in the variables, add also the loop but I am struggling to use a switch based on the Subject to decide which counter variable to increment.

[Pstork1]

What do the subject lines for the emails look like?  The key to using a switch is to get a value that is equal to a string.  Each string match leads to a different path.

[baessa]

Hi @Pstork1 

This is what I have:

Variable

name: myvariablename
Type: String
value: Backup job: servers

The subject in the emails is like

[Success] servers...

This is the info from the body of the email

Backup job: servers...                              Success

I have the loop to check if the subject contains [Success].

If yes then I do not how to use a switch based on the Subject to decide which counter variable to increment.

[Pstork1]

If the Subject line starts with [Success] are there more than one server listed in the Subject?  If not then you need to process the Subject line to isolate just that server name.  That is what the switch then runs on.  If there are more than one, then you need to isolate each server name into an array, probably by using a Split() based on whatever separates the server names.  Then use a loop with the switch inside to process each server name separately.

[baessa]

Hi @Pstork1 ,

I have other jobs and all starts with [success] with different job names.

In that case the loop can filter for all jobs or do I have to isolate each email subject that is from the jobs.?

[Pstork1]

Are the counters you are incrementing based on the job names or the server names?  You'll isolate whatever is in the subject line that will let you increment the correct counter.

[baessa]

It is base on job names... The one I gave above is just an example. whithin the job it does states the details which includes the server names.

[Pstork1]

Then do what I said before, but you will be working to isolate the individual Job Name(s) in the Subject and switch based on those names.

[baessa]

Not sure what is failing but after testing this it gives this error

This is my switch:

What I am doing wrong.
The variable is like this:

Variable

name: myvariablename
Type: String
value: Backup job: servers

[Pstork1]

Your condition can't have three different target phrases in one box.  You need to use Add three separate lines where Subject Contains and then each of the three phrases.  Set the connector for OR.

[baessa]

Okey it seems that using [Success] works but it sends me a lot of emails.

So if I add more values then it will send multiple emails right or how can I do it to receive only one email after the flow has checked all 12 or more emails to check the status of the backup jobs.

This is an example if my veeam notifications. I did not have 3 targets, only the subject name

 

[Pstork1]

If you add more values into the condition and set the connector to and it will send fewer emails because it will only send an email if all conditions are met.