If you're interested on being aware of when I release SAP automation courses with RPA tools like Power Automate Desktop, subscribe for updates here → bit.ly/47qaMa9
However SAP 800 has pane, MS PAD cannot capture any elements of the pane. On the other hand, if SAP is already logined, perhaps we need check if the sapinstance is there, and then run T-codes.
Hi! How does one get data populated as well in the item overview . In my case every PO is linked to a different service code that’s linked to Capex and Opex on our system. How would I input the data in excel for power automate to read and populate that info in the item overview correctly. In what structure or way do I add it to excel. Thanks!
great tutorial! is there a way around this warning message when i try to download the SAP GUI? “you are signed in with a P-user ID. Visitors with an S-user ID will benefit from more tools and enhanced functionality. If you are a SAP customer, contact a user administrator in your company to request such an ID” i am an individual trying to explore and learn about SAP system. is it not possible to have the software installed on my machine?
Thank you :) Never faced that message, but seems is something related to have access to SAP server... you might be able to install it for free on you're machine, but if you don't have access to SAP instance, you can't do much unfortunately...as far as I know there isn't any free/trial access to SAP :/
Marcelo, thank you for the tutorial. My SAP opens through a link, downloading a file and opening SAP already in the window to start the work. How should I proceed with the tutorial in this way? tks!
Hi Marcelo, thank you so much for the tutorial! However, I'm having issues on the login, power automate displays "error: 80040154 Clase no registrada". Do you have any idea why this error is being prompted by the program? Thanks!
Great tutorial Marcelo! How could I copy the purchase order number (45XXXXXXXX) that SAP generates to excel? I am developing this very same case right now and it is the only step I still need to do. Thank you very much
Thanks a lot for the feedback :) Now there is some new actions, and I think the appropriate one for that now (didn't try it yet) is the "Get details of SAP UI Element".
Hi Marcelo, Very good video. I just have a question. How can I do if I have 4 different vendors in the same sheet? I want to do it massively not just one vendor. Can you help?
Hello 👋🏻 Thanks a lot for the feedback. Yes sure, one way can be to get distinct list of vendors from the sheet, and then for each one, filter the sheet to get the cells related to the vendor, and do the needed filling.
Hi Marcelo! thanks a lot for the video. Sorry, would you mind telling me where have you downloaded the SAP GUI client? I am not SAP partner but I want to learn to do it
Hello! It's a pleasure :) . I just was able to record this video because a friend which manages SAP gave me the access so I could record this tutorial...unfortunately it isn't enough to have the client, you need to really have access to some SAP instance where you have login, and as far as I know, there is no free way to get it unless you know someone that manages SAP.
@@marcelocruzrpa Thanks a lot for the info! I've managed to install the gui client but as you say, it's very hard to find a free dummy SAP server out there...
As far as I know, to use SAP you will need access to the SAP server, necessary to indicate in the installation, so basically to practice/use SAP you have to know someone who has access to SAP server available for practice.
The logic it's almost the same, the difference is that you will need to encapsulate the logic on PO creation that we did on this tutorial inside a For Each loop, that goes through each vendor present on something like a list. Or, you can also use Power Automate Queues, create a dispatcher process that add queue item with the vendor and the data needed to create the PO, and then you would have the Performer that consumes queue item and creates PO with the data from it.
There is some new action "Get details of SAP UI Element" and I think might be the appropriate one for that now (didn't try it yet). I would say to give it a try
Hello Marcelo for share this video I am trying to connect, but it opens the sap but it cans not acces i have that error d. de correlación: df691de2-0ed4-4d38-98e7-77e6b01fb65e No se pudo recuperar el generador de clases COM para el componente con CLSID {62341062-29BC-4DCE-A87A-DC0CB19BF230} debido al siguiente error: 80040154 Clase no registrada (Excepción de HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Error de la acción. ---> System.Runtime.InteropServices.COMException: No se pudo recuperar el generador de clases COM para el componente con CLSID {62341062-29BC-4DCE-A87A-DC0CB19BF230} debido al siguiente error: 80040154 Clase no registrada (Excepción de HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). en System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) en System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) en System.Activator.CreateInstance(Type type, Boolean nonPublic) en System.Activator.CreateInstance(Type type) en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapGuiProxy.GetGuiApplication() en Microsoft.Flow.RPA.Desktop.UIAutomation.Core.Utilities.Clock.Execute[T](TimeSpan timeout, TimeSpan period, Func`1 action, Func`2 successCondition) en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapGuiProxy.get_GuiApplication() en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapGuiProxy.OpenConnection(String connectionString) en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapLogin.CreateConnectionToSapServer(ConnectionMode connectionMode) en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapLogin.Execute(ActionContext context) --- Fin del seguimiento de la pila de la excepción interna --- en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapLogin.Execute(ActionContext context) en Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
@@ramirosilvapedreros6059 I'm getting the same error, please help. Looks like it's not picking up my login credentials although indicated in the initial screen
If you're interested on being aware of when I release SAP automation courses with RPA tools like Power Automate Desktop, subscribe for updates here → bit.ly/47qaMa9
Excellent tutorial on SAP automation with Power Automate Desktop! Super clear and very didactic. Huge thanks!
Thanks a lot for the kind words and feedback! :D
Very clear explanations! Thank you.
Thank you for the feedback :)
Great tutorial Marcelo!🤙🏻
Thanks for the feedback Matheus! 😃
Thank you very much for the settings of launch SAP panel.
However SAP 800 has pane, MS PAD cannot capture any elements of the pane. On the other hand, if SAP is already logined, perhaps we need check if the sapinstance is there, and then run T-codes.
Hi sir example i had 3 different regex can i use to one variable rather than defining 3 times differently
Many thanx for sharing your knowledge
It's a pleasure :)
Hi! How does one get data populated as well in the item overview . In my case every PO is linked to a different service code that’s linked to Capex and Opex on our system. How would I input the data in excel for power automate to read and populate that info in the item overview correctly. In what structure or way do I add it to excel. Thanks!
Thank you for so helpful vedio.
it's any possibile to set the variable in sap vbscript
You're welcome!
Not sure if understood well your question, but you can run VBScript with the action "Run VBScript".
Thanks Marcelo
You're welcome!
great tutorial!
is there a way around this warning message when i try to download the SAP GUI?
“you are signed in with a P-user ID. Visitors with an S-user ID will benefit from more tools and enhanced functionality. If you are a SAP customer, contact a user administrator in your company to request such an ID”
i am an individual trying to explore and learn about SAP system. is it not possible to have the software installed on my machine?
Thank you :) Never faced that message, but seems is something related to have access to SAP server... you might be able to install it for free on you're machine, but if you don't have access to SAP instance, you can't do much unfortunately...as far as I know there isn't any free/trial access to SAP :/
I am getting the below error while trying to connect the SAP using credentials.
Error: "Object reference not set to an instance of an object."
Hi , when I try to define the ui elements, the application just mark the entire panel and no cell by cell, do you have a special configuration???
Hi Marcelo, what SAP Connector are you using for Power Automate?
Hi Alexis, on this tutorial we are using Power Automate Desktop, so no need for any specific connector, the SAP activities are available by default.
Marcelo, thank you for the tutorial. My SAP opens through a link, downloading a file and opening SAP already in the window to start the work. How should I proceed with the tutorial in this way? tks!
My case is similar @marcelocruzrpa awnser you?
Hi! Does this flow work with SAP Logon 770? I tried, but it throws an error when trying to log in
Hello! Yes I think it should work, which error are you getting?
Hi Marcelo, thank you so much for the tutorial! However, I'm having issues on the login, power automate displays "error: 80040154 Clase no registrada". Do you have any idea why this error is being prompted by the program? Thanks!
Its not working for me ,, its says action failed -- I have a instance DCP in place of SAP i tried ,, its getting error as action failed why ?
Many thanks
You're welcome :)
Great tutorial Marcelo! How could I copy the purchase order number (45XXXXXXXX) that SAP generates to excel? I am developing this very same case right now and it is the only step I still need to do. Thank you very much
Thanks a lot for the feedback :) Now there is some new actions, and I think the appropriate one for that now (didn't try it yet) is the "Get details of SAP UI Element".
Hi Marcelo, Very good video. I just have a question. How can I do if I have 4 different vendors in the same sheet? I want to do it massively not just one vendor. Can you help?
Hello 👋🏻 Thanks a lot for the feedback. Yes sure, one way can be to get distinct list of vendors from the sheet, and then for each one, filter the sheet to get the cells related to the vendor, and do the needed filling.
I will try and let you know what happened 😅,thanks for responding quickly.
Hi Marcelo! thanks a lot for the video. Sorry, would you mind telling me where have you downloaded the SAP GUI client? I am not SAP partner but I want to learn to do it
Hello! It's a pleasure :) . I just was able to record this video because a friend which manages SAP gave me the access so I could record this tutorial...unfortunately it isn't enough to have the client, you need to really have access to some SAP instance where you have login, and as far as I know, there is no free way to get it unless you know someone that manages SAP.
@@marcelocruzrpa Thanks a lot for the info! I've managed to install the gui client but as you say, it's very hard to find a free dummy SAP server out there...
You're welcome :) Yes, it is unfortunately, at least never found free dummy one until now :/
How to get sap access to practice this?
As far as I know, to use SAP you will need access to the SAP server, necessary to indicate in the installation, so basically to practice/use SAP you have to know someone who has access to SAP server available for practice.
Could you please tell us or upload video explain with several vendors and Also several purchasing orders?
The logic it's almost the same, the difference is that you will need to encapsulate the logic on PO creation that we did on this tutorial inside a For Each loop, that goes through each vendor present on something like a list. Or, you can also use Power Automate Queues, create a dispatcher process that add queue item with the vendor and the data needed to create the PO, and then you would have the Performer that consumes queue item and creates PO with the data from it.
@@marcelocruzrpa i will Try this way and i get back with comments! Many thanks.
Do i need Power Auotmate premium to get SAP connector?
No, it's available by default on Power Automate Desktop, no need for premium license :)
How to capture bottom SAP status bar?
There is some new action "Get details of SAP UI Element" and I think might be the appropriate one for that now (didn't try it yet). I would say to give it a try
Just new here and exploring power automate ~ but somehow I cant see the actions for SAP in my Power Automate Desktop
You get it based on whether your organisation or yourself have paid for the SAP connector
Please make a video on RDP automation
Thanks for the suggestion, I will add on the tutorials ideas list :)
I just would use vba. Much more simple.
Tbh dont know what Power automate would add.
Hello Marcelo for share this video I am trying to connect, but it opens the sap but it cans not acces i have that error
d. de correlación: df691de2-0ed4-4d38-98e7-77e6b01fb65e
No se pudo recuperar el generador de clases COM para el componente con CLSID {62341062-29BC-4DCE-A87A-DC0CB19BF230} debido al siguiente error: 80040154 Clase no registrada (Excepción de HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Error de la acción. ---> System.Runtime.InteropServices.COMException: No se pudo recuperar el generador de clases COM para el componente con CLSID {62341062-29BC-4DCE-A87A-DC0CB19BF230} debido al siguiente error: 80040154 Clase no registrada (Excepción de HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
en System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
en System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
en System.Activator.CreateInstance(Type type, Boolean nonPublic)
en System.Activator.CreateInstance(Type type)
en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapGuiProxy.GetGuiApplication()
en Microsoft.Flow.RPA.Desktop.UIAutomation.Core.Utilities.Clock.Execute[T](TimeSpan timeout, TimeSpan period, Func`1 action, Func`2 successCondition)
en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapGuiProxy.get_GuiApplication()
en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapGuiProxy.OpenConnection(String connectionString)
en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapLogin.CreateConnectionToSapServer(ConnectionMode connectionMode)
en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapLogin.Execute(ActionContext context)
--- Fin del seguimiento de la pila de la excepción interna ---
en Microsoft.Flow.RPA.Desktop.Modules.SAP.Actions.SapLogin.Execute(ActionContext context)
en Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
hola, pudiste soluionar este error?
@@ramirosilvapedreros6059 I'm getting the same error, please help. Looks like it's not picking up my login credentials although indicated in the initial screen