Server Backups

[Fraz121180]

Good afternoon

New to Flow, this is the first I am looking at it, so please bear with me.

We have a client base of around 40 companies.

Each company has a server that runs backups each night using a variety of applications (Azure, Server Backup, Backup Assist, GFI etc etc)

On each server we have a little program called cmail which based on a Windows event ID will email our backups email address to tell me the backup on that server has been successful or failed.

I then go through the emails and manually input this data into a spreadsheet each morning so that management can have a quick look at the sheet to see whats passed and failed (if any).

I'm now wondering, in an effort to save me some time each morning if Flow is able to automate this process somewhat for me?

Is it even possible that flow could complete the columns of the spreadsheet based on a keyword in the backup emails?

Does anyone else use Flow for reporting on their server backups?

If we use flow would it be better to setup a new way of doing this rather than using a spreadsheet and daily emails?

As I said, totally new to Flow so any suggestions/help would be appreciated.

Thanks

[v-yamao-msft]

Hi @Fraz121180 ,

From your description, it seems that you would like to get information from emails then input the data into a spreadsheet.

I am not familiar the program cmail, but if we could connect to Outlook.com or Office 365 Outlook from flow to get data.

To complete the columns of the spreadsheet based on a keyword in the backup emails, please check if the following configuration will work for you.

When an email arrives, here I am using connector Office 365 Outlook.

Then add a Condition to check if the Subject contains certain keyword.

If yes, add a row into an existing Excel table on OneDrive or SharePoint, etc.

An image for your reference.

More reference documentations:

https://flow.microsoft.com/en-us/blog/build-more-powerful-conditions-in-flows-and-more/

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/

Best regards,

Mabel

[Fraz121180]

This has been a great help Mabel, thanks very much,

Here's my next part I can't seem to quite get working

The emails go to our backups inbox, in the Flow, how do I get it setup that when an email comes into that particular box?

RIght now it won't let me change to another inbox that's not my own one

[v-yamao-msft]

Hi @Fraz121180 ,

If you want to use the backups inbox, you need to create a connection to it using its account and credentials info.

Then switch the connection to the backups, setting up the flow.

Best regards,

Mabel

[Fraz121180]

Apologies for lack of updates, this was put oon back bruner for a few weeks.

I've picked it back up again today and I am making good headway.

One question though, I am setting up Flow to update a row in an Excel spreadsheet that is stored on Sharepoint, however it keeps reporting a fault that there is no row found with ID (xx)

My question is, what is the key Value and what is it supposed to be?

I thought it was a unique identifier that I wanted added to the row to show it was completed, but I have tried all variations with no success.

As you can hopefully see from the screenshot attached, an email comes into our shared mailbox, I want it to update a row in my Excel sheet stored in our Sharepoint site.

I've completed the details for the sheet in Sharepoint, I've selected the column, but this Key Value is the sticking point. No matter what I put in there it returns an error saying no row found.

When I click into the Key Value, it brings up the Dynamic Box but only has options relating to the email, such as Subject contains, Time/Date etc

Thanks