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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 237 Super User 2026 Season 2
David_MA 227 Super User 2026 Season 2
Mohsin Ali 194
