Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 525 Super User 2025 Season 2
Tomac 324 Moderator
abm abm 232 Most Valuable Professional