Update an Excel with new data from my sFTP-Server

(0) Share

Report

Posted on by Nils259

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).

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 🙂

I have the same question (0)

All responses (1)

Answers (0)

Pablo Carceller on at

Like (0)

Report

Re: Update an Excel with new data from my sFTP-Server

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.

Was this reply helpful? Yes No