Announcements
I need to upload data from excel in SharePoint folder to SAP system using power automate desktop. How to achieve this? Using Ui Automation or should I be using connectors. Which is best and effective way to go about it.
The most effective way is usually to use VBScript. In SAP there is script recording feature.https://learn.microsoft.com/en-us/power-automate/guidance/rpa-sap-playbook/recording-vbscript-using-sap-gui-automation-engineYou can then record the steps and give that script to Power Automate Desktop to use Run VBScript -action.
Hey,
If you have/have to disable script option due to security reason then you can go with UiAutomation and use actions like press key and click under UiAutomation else as suggested by eetuRobo, go with script.
Please mark this as solution if it helps you solve issue. Happy to help you more.
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 594
Valantis 328
David_MA 281 Super User 2026 Season 1