cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fraz121180
Level: Power Up

Server Backups

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

4 REPLIES 4
Community Support Team
Community Support Team

Re: Server Backups

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.

1.PNG

 

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fraz121180
Level: Power Up

Re: Server Backups

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

Community Support Team
Community Support Team

Re: Server Backups

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Fraz121180
Level: Power Up

Re: Server Backups

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

 

ThanksFlow Screenshot.jpg

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,789)