cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChienTrinh
Frequent Visitor

Power Automate desktop with SAP Click on UI element failed and change date format

Hi everyone,

 

I am a newbie with Power Automate and this is the greatest app I have ever used. 

My first try is on SAP Netweaver and I have 2 problems like below. Pls help me to solve it.

1.  After run SAP, on the screen I set a Click on UI element to choose a System connection but it always error:

              Double click failed (failed to get UI element)

              Robin.Core.ActionException: Double click failed (failed to get UI element)
at Robin.Modules.UIAutomation.Actions.ClickElementInWindow.Execute(ActionContext context)
at Robin.Runtime.Engine.ActionRunner.RunAction(String action, Dictionary`2 inputArguments, Dictionary`2 outputArguments, IActionStatement statement)

 

2. I skip the step 1 and using manual log on. I want to export data from period of time (choosing date to date)

I add the action "Display select date dialog" for from first date to end. Its format default is m/dd/yyyy (eg. 2/24/2021). 

then I add "Convert text to datetime" with custom format: dd.mm.yyyy (because SAP only get that format)

The resutl could not like my want. 

 

Please help me for this. I am very grateful to you!

Thanks,

 

1 ACCEPTED SOLUTION

Accepted Solutions
miketran13
Solution Specialist
Solution Specialist

Hello,

 

1. Power Automate Desktop is just a re-invented UI version of WinAutomation. I don't have experiences in SAP but please have a look at this since you have to have some Settings in SAP to make it works with your flows.

Interaction with SAP 

2. Converting text to Datetime is just converting your text to a Datetime object, it can't change your format, the option in this action for "Date is represented in custom format" is just helping you to specify the custom format if your original text had. It is not the target format of the action. So, if you want to convert to another format. Then you have to have a new action "Convert datetime to text" with your format: dd.MM.yyyy

converttext.png

convertdate.png

Thanks and hope it can help you. 

Mike

---------------------------------

Did I answer your question? Please consider to Mark my post as a solution! to guide others

View solution in original post

2 REPLIES 2
miketran13
Solution Specialist
Solution Specialist

Hello,

 

1. Power Automate Desktop is just a re-invented UI version of WinAutomation. I don't have experiences in SAP but please have a look at this since you have to have some Settings in SAP to make it works with your flows.

Interaction with SAP 

2. Converting text to Datetime is just converting your text to a Datetime object, it can't change your format, the option in this action for "Date is represented in custom format" is just helping you to specify the custom format if your original text had. It is not the target format of the action. So, if you want to convert to another format. Then you have to have a new action "Convert datetime to text" with your format: dd.MM.yyyy

converttext.png

convertdate.png

Thanks and hope it can help you. 

Mike

---------------------------------

Did I answer your question? Please consider to Mark my post as a solution! to guide others

Thanks @miketran13 for your help.

 

1. I am not authorized to use that transaction but I can log on right now by using many steps like: filter the connection field, write exactly text.....

 

2. I think my mistake is use "Display select date dialog" => "Date range (2 Dates)" 

If I use "Single date" then "Convert to text", It works.

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,447)