'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Power Automate Flow Not Copying Files to SharePoint
Question details
The user needs to configure Power Automate to successfully copy files from both a desktop and a laptop to the same SharePoint folder.
- Product
- Power Automate / SharePoint
- Device & OS
- not provided
- Scenario
- Automating file transfers from multiple local computers to a centralized SharePoint Online folder using the on-premises data gateway.
- Observed behavior
- The flow works consistently on the desktop but fails or acts inconsistently on the laptop, despite both having the on-premises data gateway installed.
Ensure that both your desktop and laptop are powered on, connected to the internet, and that the on-premises data gateway service is actively running and signed in on each machine before testing your flows.
Verify Gateway Connections and Flow Configurations
Ensure that each flow is configured with the correct specific gateway and connection credentials for its respective machine.
Multiple Power Automate flows can seamlessly use the same SharePoint Online folder. When a flow fails on a specific device, it usually indicates a mismatch in connection settings, permissions, or the active status of the local gateway.
Open the On-premises data gateway app on the laptop and verify that it is signed in, online, and displays a 'Ready' status.
Go to Power Automate, navigate to Data > Connections, and ensure the connection for the laptop's flow is explicitly bound to the laptop's gateway, not the desktop's.
Ensure the source folder path configured in the laptop's flow trigger matches the exact local directory structure of the laptop.
Confirm that the Windows account running the gateway service on the laptop has full read permissions for the local folder and write permissions for the destination SharePoint folder.
Boost Your Document Productivity with WPS Office
While you troubleshoot advanced Microsoft Power Automate and SharePoint gateway issues, consider using WPS Office for your daily document needs. It offers a lightweight, fast, and highly compatible alternative to Microsoft Office.
- 1. Visit the Official Site: Go to the official WPS website to download the latest version of WPS Office.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up the software on your desktop or laptop.
- 3. Open and Edit: Launch WPS Office to instantly open, edit, and save your Microsoft Office formatted documents.
Frequently Asked Questions
Can multiple Power Automate flows copy files to the same SharePoint folder?
Yes, multiple flows can target the same SharePoint Online folder without conflict, provided they are configured with the correct source paths and active gateway connections.
Why does my on-premises data gateway work on one PC but not the other?
This often happens due to incorrect connection credentials in the flow, local firewall restrictions blocking the service on the second PC, or the laptop entering sleep mode, which temporarily disconnects the gateway.
Do I need a separate connection for each on-premises data gateway?
Yes, each physical machine running an on-premises data gateway requires its own distinct connection configuration in Power Automate to securely authenticate and access local files.
