SAP Automation with Power Automate Desktop (Full Tutorial)

No video

SAP Automation with Power Automate Desktop (Full Tutorial)

Рет қаралды 14,685

Marcelo Cruz

Күн бұрын

Пікірлер: 52

@dorotas7095 Ай бұрын

Very clear explanations! Thank you.

@marcelocruzrpa Ай бұрын

Thank you for the feedback :)

@CideeTV 6 күн бұрын

Many thanks

@marcelocruzrpa 6 күн бұрын

You're welcome :)

@paulskelton8799 2 ай бұрын

Many thanx for sharing your knowledge

@marcelocruzrpa Ай бұрын

It's a pleasure :)

@simonefadd1457 10 сағат бұрын

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!

@matheusklein8207 6 ай бұрын

Great tutorial Marcelo!🤙🏻

@marcelocruzrpa 6 ай бұрын

Thanks for the feedback Matheus! 😃

@zhimabukaimen 5 ай бұрын

Thank you very much for the settings of launch SAP panel.

@zhimabukaimen 5 ай бұрын

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.

@VICTOR-cc2ux 24 күн бұрын

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?

@marcelocruzrpa 20 күн бұрын

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 :/

@elvin2290 13 күн бұрын

Could you please tell us or upload video explain with several vendors and Also several purchasing orders?

@marcelocruzrpa 3 күн бұрын

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.

@mandyvlogs4039 5 ай бұрын

Thanks Marcelo

@marcelocruzrpa 5 ай бұрын

You're welcome!

@josejavierbarrantesjimenez245 2 ай бұрын

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???

@user-xf8ih8ei5g 5 ай бұрын

Thank you for so helpful vedio. it's any possibile to set the variable in sap vbscript

@marcelocruzrpa 5 ай бұрын

You're welcome! Not sure if understood well your question, but you can run VBScript with the action "Run VBScript".

@lil_ice93 4 ай бұрын

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!

@toniserrano6167 3 ай бұрын

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

@marcelocruzrpa 20 күн бұрын

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".

@AlexisGordon-Martin Ай бұрын

Hi Marcelo, what SAP Connector are you using for Power Automate?

@marcelocruzrpa Ай бұрын

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.

@suraj_singh321 6 ай бұрын

Hi sir example i had 3 different regex can i use to one variable rather than defining 3 times differently

@Clock1129 2 ай бұрын

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?

@marcelocruzrpa 2 ай бұрын

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.

@Clock1129 2 ай бұрын

I will try and let you know what happened 😅,thanks for responding quickly.

@matiasteti3344 Ай бұрын

Hi! Does this flow work with SAP Logon 770? I tried, but it throws an error when trying to log in

@marcelocruzrpa 20 күн бұрын

Hello! Yes I think it should work, which error are you getting?

@bottomofmyheart7744 5 ай бұрын

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 ?

@vivssaura 4 ай бұрын

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!

@vitizinx 5 күн бұрын

My case is similar @marcelocruzrpa awnser you?

@andonii46 5 ай бұрын

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

@marcelocruzrpa 5 ай бұрын

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.

@andonii46 5 ай бұрын

@@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...

@marcelocruzrpa 20 күн бұрын

You're welcome :) Yes, it is unfortunately, at least never found free dummy one until now :/

@visheshsethiya7032 3 ай бұрын

Please make a video on RDP automation

@marcelocruzrpa 20 күн бұрын

Thanks for the suggestion, I will add on the tutorials ideas list :)

@JoseOmarSanchezAvila 2 ай бұрын

Do i need Power Auotmate premium to get SAP connector?

@marcelocruzrpa 20 күн бұрын

No, it's available by default on Power Automate Desktop, no need for premium license :)

@michaelamartinez9751 5 ай бұрын

Just new here and exploring power automate ~ but somehow I cant see the actions for SAP in my Power Automate Desktop

@nikhilmehta8128 5 ай бұрын

You get it based on whether your organisation or yourself have paid for the SAP connector

@LokeshReddyLoki 2 ай бұрын

How to capture bottom SAP status bar?

@marcelocruzrpa 20 күн бұрын

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

@DipendraShekhawat 6 ай бұрын

How to get sap access to practice this?

@marcelocruzrpa 6 ай бұрын

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.

@mathijs9365 2 ай бұрын

I just would use vba. Much more simple. Tbh dont know what Power automate would add.

@leonelortega9824 Ай бұрын

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 24 күн бұрын

hola, pudiste soluionar este error?

@robbertvleugels1878 9 күн бұрын

@@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