cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nils259
New Member

Update an Excel with new data from my sFTP-Server

Hi Community!

 

I need some advice about the flow i want to build.

 

We receive data on a sFTP-Server from several customers into the folder /INCOMING, every customer has it´s own entry to the server, so we have several /INCOMING folders. I already build a flow, that sends me an E-Mail when data was placed into the folder. 

 

Now I want to build an Excel sheet, which will be automatically updated every day at 11:00AM, which customer has send us their data (YES/NO).

Nils259_0-1600259705190.png

We have about 15 customers, which I will add with their number to my table. They should delivery their data on a daily basis, so I can monitor with this table if someone forgot to deliver. 

 

How can i build a flow around this? As I have the part where I refer to the information from the sFTP-Server, I need to get the information to Excel and the update in the table...

 

Look forward to any advice, I hope i could explain it well enough 🙂

 

1 REPLY 1
pagonza
Microsoft
Microsoft

Hello @Nils259 

 

I hope this can help you, I have some ideas that mat help you to implement this flow.

 

First on the flow that send you an email when someone placed data on the folder. you can check with a switch different update on your excel, putting a condition of the sender of the email.

 

May this article can help you:

https://d365demystified.com/2020/04/29/switch-case-in-a-flow-power-automate/

 

Then on your daily flow of  11:00AM, you can create a Reset the excel, with all the values "No" as default. before do this, you can send an email with the information of the last day.

 

I hope this make sense for your business requirements.

 

Best regards, Pablo.

 

 

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (27,172)