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 🙂