cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smcb10
Frequent Visitor

Copy Files from Sharepoint to PC- no flow error but not saving file

I am using the Power Automate template - Copy files from Sharepoint to PC- and am having issues getting the file to save. It is currently running "successfully" but the file is not getting moved into the local folder. I'm using a admin account credentials, have a gateway that is actively used in Power BI, so I'm not sure where I'm going wrong. 

 

smcb10_0-1633353049134.png

I used the folder path picker to enter the folder path into the flow. 

For the connection, my username is domain\username verified by whoami in cmd.

Currently I have the root folder at a higher level than the destination folder, but I've tried having the root folder match the destination folder with the same results.

smcb10_1-1633353225696.png

 

Please help!

9 REPLIES 9
ekarim2020
Community Champion
Community Champion

Does the flow work if you try and the "List files in folder" action?

Strange how you aren't getting any errors.

 

See also: https://powerusers.microsoft.com/t5/Building-Flows/The-credentials-for-this-connection-do-not-have-a...

Ellis

A simple manually triggered flow with 'list files in folder' was successful.

smcb10_0-1633357893239.png

 

ekarim2020
Community Champion
Community Champion

What type of On-Premise data gateway has been installed?

On-premises data gateway (personal mode): Allows one user to connect to data sources and can’t be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI.

 

ekarim2020_0-1633359985703.png

https://powerbi.microsoft.com/en-us/gateway/

 

"Currently, Microsoft actively supports only the last six releases of the on-premises data gateway. We release a new update for data gateways every month."

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot

 

Ellis

We have a Standard mode gateway installed, and I'm able to select it from the dropdown.

ekarim2020
Community Champion
Community Champion

Can you perform a simple operation like Rename File, Delete File and Copy File action in that folder?

This is to check that create (through a copy action), read, write, and delete operations work on that folder, if not we want to generate an error response of some type.

Ellis

smcb10
Frequent Visitor

When setting up a 'rename file' action, the files that I've tried to move over and can't see are appearing in the file list! 

smcb10_0-1633360826433.png

Do you know why I can't see them on my PC?

ekarim2020
Community Champion
Community Champion

Can you post the Output of these actions.

Do the file create and file rename actions complete successfully?

Ellis

smcb10
Frequent Visitor

I did a 'rename' and it completed successfully, but I still see nothing in that file folder.

smcb10_0-1633610950757.pngsmcb10_1-1633610989799.png

 

smcb10_2-1633611034629.png

 

ekarim2020
Community Champion
Community Champion

As you have shown, the flow is successful, but you do not see the files in Windows Explorer. It's as if the files are being saved somewhere else?

I can only suggest creating a new connection pointing to a different folder location and testing.

 

ekarim2020_0-1633642995490.png

ekarim2020_1-1633643491441.png

 

Ellis

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,895)