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
Community Support
Community Support

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,656)