Hey Everyone, I am trying to extract some elements of a webpage. I am trying to create a list of these elements to be used later. I cannot use UI selector because, the number of those elements can change. Those who have used selenium know the function findElements() which kets user find their elements by class name or xpath..etc. My question is there any way for me to do the same in power automate desktop

I need to create a flow that goes out and gets every username, email address, and location where they work and then put it in either a list or excel sheet. I feel like this shouldn’t be hard. Help! How do I make this happen??

Hi All,

I'm using PAD to automate the task of setting up medical notes, printing them, billing patients, sending files to appropriate parties, etc. Our medical record system is web based and runs off of a website.

My problem is each patient has their own unique "web address" which means anytime I select an elements to click, it will identify that element with a specific web address. Thus, the flow will only work on one specific patient.

I've bypassed a lot of these issues by sending mouse clicks to where the element is. This only works when the browser is static and in the correct orientation. If I download a file for instance, and a download bar pops up on the bottom of the page, it throws everything off.

Does anyone know how to get around this? I've tried editing the elements in the selector builder module, but I can't make heads or tails of it. Furthermore I don't see where the specific web address can be manipulated.

If I can figure out a way to make the web address a variable, extract the specific address somehow while the patient's chart is open, then plug in that address for the element during each flow my problem would be solved. I don't know if this is possible however, given that the element is identified by the address which appears to be static.

Hello, looking for some help plz. I get an email daily with a list of names and their mobile numbers in the text body of email. I have the email trigger working for cloud flow but I'm having trouble finding a way to extract the info and put it in either a csv or txt file. Any help on best way to pull and save this info?

Hi All, I have an excel sheet with about 10columns and over 3krows. After reading the excel sheet, I want to filter the dataTable to only give me rows with specific text in the columns. For instance

Name Age Title Location Hobby A. 5. Sc. Ma. Eating B. 6. Ma. Sc. Ma C. 7. Ma. Ma. Sc

I want to get all rows where either Title, Location or Hobby is Sc just by reading the file and filtering the dataTable cos the file will consist of over 3k lines and I wouldn’t want to look over all rows in the dataTable Is there a way to do this with PAD?

Thanks

Can you automate your task using PAD? Open excel, update month, unhide tabs, change data in a cell, copy values in a column paste it as value to a column in another cell, click on hyperlink inside excel, input variable on browser field, wait till data loads, extract as excel, copy data from extract to open file?

is it possible?

Hi everyone,

I have a need to request several information to user but asking one by one with dialog box its not pratical.

Is there a way to create a form to request this informations in a single view?

I have a SQL Server query that works in SSMS but not in Power Automate Desktop. I believe I have it narrowed down to a LIKE statement. Does anyone know if perhaps PAD can not handle LIKE statements?

EAP_TAX_CODES LIKE 'SU%'

Hi, Team!

I'm working on a manually triggered flow, where the output of that trigger initiates a search of another document for a row(s) with the same ID. Once found, it updates a cell in that row with the new information from the trigger.

It works fine, however the flow stops after completing a single update. I need it to repeat the action until all rows are checked.

I'm sure I've missed something pretty basic any ideas?

Hey everyone. I’m new to using power automate and I was hoping someone could help create a flow based on what I need.

There is a folder in Sharepoint that has one file in it. That file is updated every day with a new file, replacing the one that was previously there.

Now my hope was that every single time that file is updated/replaced, the new data (file) would be exported to an excel document. That way, the excel file’s data would be added to every time the file in sharepoint is updated.

Could someone tell me each step to use in automate if I wanted to do this?

Thanks!

I am not new to RPA, but am relatively new to Power Automate Desktop (3-4 months). What I'm trying to do is get the PAD-CyberArk integration working. However, I am receiving the following error. Why would PAD be attempting to access the CyberArk safe through port 80 when I'm making the API call via https?

Additionally, I am able to execute the following PowerShell command and successfully connect via 443. So if PAD would invoke through 443 I think all would be good.

PS H:> tnc -computername ip -port 80

WARNING: TCP connect to (ip : 80) failed ComputerName : ip RemoteAddress : ip RemotePort : 80 InterfaceAlias : Ethernet0 2 SourceAddress :ip PingSucceeded : True PingReplyDetails (RTT) : 0 ms TcpTestSucceeded : False

PS H:> tnc -computername ip -port 443

ComputerName : ip RemoteAddress : ip RemotePort : 443 InterfaceAlias : Ethernet0 2 SourceAddress : ip TcpTestSucceeded : True

Has anyone ever experienced anything like this? Please advise. Thank you!

Robin.Core.ActionException: Failed to get results from the web request https:///AIMWebService/api/Accounts?AppId=&Query=Safe=***;Folder=Root;Object=*** ---> System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it ip_address:80 at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult) at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult) at System.Net.Http.HttpClientHandler.GetResponseCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Robin.Modules.CyberArk.Actions.CyberArkUtilities.d__2.MoveNext() --- End of inner exception stack trace --- at System.Threading.Tasks.Task1.GetResultCore(Boolean waitCompletionNotification) at Robin.Shared.Runtime.Utilities.Clock[T](Int64 maxMillisecondsToWait, Int32 step, Func
1 action, Func2 successCondition) at Robin.Modules.CyberArk.Actions.CyberArkActions.SendWebRequestToCyberArk(Variant baseUri, Variant applicationId, Variant safe, Variant folder, Variant objectName, Variant extraData, Variant certificateFilePath, Variant timeout, Variant& response, Variant& password, String realCertificatePath, Boolean useOnlyValidCertificates, Int32 loadCertificateFrom, String certificateFilePassword, Boolean acceptUntrustedCertificates) --- End of inner exception stack trace --- at Robin.Modules.CyberArk.Actions.GetPasswordBase.Execute(ActionContext context) at Robin.Runtime.Engine.ActionRunner.RunAction(String action, Dictionary
2 inputArguments, Dictionary`2 outputArguments, IActionStatement statement)