Save excel file to sharepoint folder

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I am new to power automate desktop and learning a lot about it every minute.

I have found a video how to export data from SAP to an excel file and save it to my desktop.

Next step is to save this file to a sharepoint folder (which I can not sync to my computer)

searching the in other topics didn't gave me a solution.

Can someone please help me.

Regards

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
Try a flow with these generic steps:
1. Capture the full name of the file you want to load
2. 'Launch new Edge' (or you preferred browser) and navigate to the page with your SharePoint's folder
3. 'Press button on web page' to hit 'Load' button
4. 'Click link on web page', click on 'Files'
5. In the window to select file, fill 'Name' field with file's name (use 'Populate text field in window')
6. Click Open button (use 'Press button in window')

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Thank you for your answer.
I tried your solution, but I get stuck at the point 4 "Click link on web page", click on Files.

For some reason power automate doesn't see the link 'Files'.
therefore I can't select the file in de window.

I switched to the classic version of sharepoint. After that I get to the screen for selecting a file.
And I can also select the file and close the window.
But when I run the flow I get an error message
Any idea?

Marc

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
Try this instead of step 4 (tested):
4.1. 'Get windows', foreground window
4.2. 'Focus windows', instance = %AutomationWindow%
4.3. 'Send keys': down, up, Enter
Steps 4.1-4.2 to assure 'Send Keys' will work

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Perfect this worked! Thank you @Anonymous

Was this reply helpful? Yes No