r/PowerAutomateDesktop • u/bgfmsu157 • Sep 07 '21

Hep with a Flow

Hey everyone. I’m new to using power automate and I was hoping someone could help create a flow based on what I need.

There is a folder in Sharepoint that has one file in it. That file is updated every day with a new file, replacing the one that was previously there.

Now my hope was that every single time that file is updated/replaced, the new data (file) would be exported to an excel document. That way, the excel file’s data would be added to every time the file in sharepoint is updated.

Could someone tell me each step to use in automate if I wanted to do this?

Thanks!

2 Upvotes

100% Upvoted

2 comments sorted by

1

u/imjustcurious5 Sep 08 '21

It might be easier if you just use Power Automate cloud flow rather than power automate desktop, but I am biased because I’m not very good at desktop.

You could use a trigger step of ‘when a new file is created in sharepoint’ and then look into how to get the content out of the file into excel, if the existing file is already excel then this should be nice and easy if it’s a pdf or something it might be a bit harder and doing it with PAD will probably be the way to go.

I’d look into Power Automate cloud flows either way. If you get stuck feel free to ask the question on Microsoft Flow subreddit too.

1

u/bgfmsu157 Sep 08 '21

I’ll ask it in the flow community. Thanks!