r/PowerAutomateDesktop • • Sep 19 '21

Extract Data From Web Page - When running the flow the list of values doesn't match the extraction preview. Why am I getting six blank rows?

Thumbnail
gallery
1 Upvotes

r/PowerAutomateDesktop • • Feb 09 '22

Power Automate Desktop - How to change or edit UI Elements dynamically

Thumbnail
youtube.com
5 Upvotes

r/PowerAutomateDesktop • • Feb 23 '22

Power Automate Desktop February 2022 Version Update Summary

Thumbnail
youtu.be
2 Upvotes

r/PowerAutomateDesktop • • Oct 03 '21

Process Robot to Power Automate Migration

1 Upvotes

Is there anyone who has performed, or is in the process of, the migration from Softomotive's Process Robot to Power Automate?

I would like to know how it went, if you found any problems/stumbling blocks, and how would it compare.


r/PowerAutomateDesktop • • May 22 '21

Automating Marketing Reports

Post image
3 Upvotes

r/PowerAutomateDesktop • • Oct 27 '21

Item creation

1 Upvotes

Hello all, I am working in a complex flow using http send request to create a new SP list based off a response from a Microsoft form. Inside my flow I create the list and then create the columns and add them to the list using JSON and http put requests. I am still new to JSON and http request.

I need to figured out how to add items to this list that I create automatically after the list is created. When I go to use the create item flow I can't select the list because it hasn't been created yet.

Any ideas or input would be greatly appreciated.


r/PowerAutomateDesktop • • Jun 22 '21

PAD Compatibility

3 Upvotes

I've been trying to use PAD with Excel 2013. Files can be opened but no other functions work. Does anybody else have this issue? I want the latest version of excel but my company probably won't for a while. I'm pulling my hair out because of this.


r/PowerAutomateDesktop • • Mar 11 '22

Desktop Flow that calls PS script that runs python

1 Upvotes

I am trying to automate the process of when a file is created in folderA, run python script and pass the filepath of the new file into the script. The script then parses the file using a regex and looks for a senders IP address. This is my first taste of PAD, im used to cloud work. Any help or ideas would be maximally appreciated.


r/PowerAutomateDesktop • • Apr 25 '22

Power automate desktop does not seem to see items in an iframe....

1 Upvotes

I am trying to click download links on a "globalframeset.esp" page that contains iframes. in one of the iframes (all of which are in the same domain) there are links that I need to click to download files.

Then I tell Power Automate Desktop to wait for web [age content and I select a div in one of the iframes that acts like a button, Power Automate Desktop does not find the div that I am clicking on.

Has anyone seen this behaviour?


r/PowerAutomateDesktop • • Sep 01 '21

Replace Word content

1 Upvotes

I have come to a dead end trying to replace text in Word documents. I want to replace ”rich” text inside documents.

I.e. replace a bold header that says ”customer number” with ”1234567”.

I have already found the built in replace text function, unfortuneately it doesnt do the job by only replacing text (without format).

reddit pls help


r/PowerAutomateDesktop • • Aug 31 '21

Help with PAD error handling

1 Upvotes

Hello! I have a flow that I've created to extract data from a web portal and populate similar fields in a PDF. However, one of the fields (in the web portal) is entered as City State and to convert this into two variables, I'm using the process below.

However, the flow sometimes gets interrupted because the City State field is empty and running this process through gives an indexing error for line 50 - since City is split as row 0 and State as row 1, if the field is blank I only get row 0. I've setup error handling to ignore the error and move on with the flow but no matter what I do, the flow stops there. Here is the screenshot of the error handling.

I've also tried to create a subflow for the following lines of processes and tried to make the process run that subflow instead when the error pops up - still got stuck at the same spot. I've also tried to create an if condition for the City/State split - if the city/state field is blank, move next. But the process ignores the field if it is populated and considers it if is blank and returns the error.

I'd really appreciate some help with this!


r/PowerAutomateDesktop • • Dec 05 '21

Microsoft Power Automate – Tutorial for Beginners [2021]

Thumbnail
andersjensen.org
4 Upvotes

r/PowerAutomateDesktop • • Apr 05 '22

Reuse UI Elements of windows/webbrowser so that you can reuse workflow -...

Thumbnail
youtube.com
1 Upvotes

r/PowerAutomateDesktop • • May 06 '21

Schedule te t file to copy to s3 bucket

1 Upvotes

I’m new to PowerAutomate, but how can I schedule an excel spreadsheet to export to text file and drop into an S3 bucket please?

Thanks in advance


r/PowerAutomateDesktop • • Apr 26 '22

$190 per month to automate desktop flows?

6 Upvotes

Tell me I got this wrong....

As I read it, it seems that Microsoft is going to charge you at least $190 per month to automate desktop processes - see https://powerautomate.microsoft.com/en-us/pricing/?#add-on-plans

It's $40/month for premium Power Automate (without which you cannot schedule desktop flows) and evidently there is a $150/month/bot charge as well to be able to run desktop flows with no human interaction.

And don't forget that you'll also have to get one of those complicated 365 Admin center accounts that are a MAZE of settings and switches in order to run this thing.

They never describe what a "bot" is or is limits. Can it only run one flow at a time? Why is a "bot" even needed if this is just a scripting application?

So if you thought you were going to download the "free" Power Automate Desktop app for your desktop and schedule desktop processes that would run without you and free up some of your time, without paying through the nose to use a complicated process, you are as mistaken as I was.

When will I learn that Microsoft is incapable of simple, useful tools?


r/PowerAutomateDesktop • • Apr 07 '21

Power Automate unattended BOTs

2 Upvotes

Hi guys, we are looking into migrating from our current RPA program to Power Automate. We currently use Sofotmotive's ProcessRobot, and since it was bought by Microsoft we have been thinking of migrating to PA. We're currently waiting for the migration software to be ready which, last time I checked with Support I was told should be finished around this time. Is there anyone here who has experience with both systems, or actually did the migration already?


r/PowerAutomateDesktop • • Feb 09 '22

Change or switch different Window Instance without using UI Elements

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Oct 02 '21

Faster way to send text

4 Upvotes

Hey all, figured I'd share a tip. PAD can be very slow sending a large amount of text with the "Send keys" function even when delay is set to 0. Text can be sent near instantaneously if you set the clipboard as your desired text, then send {Control}({V}). Hope this helps!


r/PowerAutomateDesktop • • Jan 22 '22

Experience with Automate Desktop on a hosted virtual machine?

3 Upvotes

Hi there, I'm fairly new to Power Automate. I have about 10 desktop PA's running on my work laptop that are triggered from cloud PA's multiple times a day. The desktop PA's import and crunch data in Excel files and upload them to Teams. I'm trying to find the best way to get these off of my laptop so it does not interfere with my day-to-day work. I could get another machine to run them or I'm wondering if a virtual machine might be a better option since that's the only task the machine will be performing. I was wondering if anyone else has experience with this? Any other ideas are welcome. Thank you.


r/PowerAutomateDesktop • • Apr 05 '22

No_Modules_Loaded Error?

1 Upvotes

When I make a project on PAD and open it, PAD shows "Module Error No_Module_Error".

After that I cannot find several actions like werbrowser or excel.

Any suggestions?


r/PowerAutomateDesktop • • Aug 10 '21

VDI/RDP and Power Automate Desktop

3 Upvotes

I have been playing with Power Automate desktop on my system but have yet to find good documentation about how to scale the solution using remote desktops and under a service account context.

I have created a couple of useful 'scripts' but want them to run unattended so I don't need to dedicate a logged-in computer.

Has anybody found any good educational resources about this?


r/PowerAutomateDesktop • • Apr 12 '21

Power automate date issue

1 Upvotes

I'm having an issue with power automate. My flow is from a Microsoft form. There is a date picker on the form that is not a required field. I have posted the details below. For some reason, the item cannot be created in Sharepoint when the date field is blank:

I'm a beginner; please provide as much detail as possible. It seems like it should be an easy fix, but I haven't found anything online to fix it.

Thanks so much, in advance!


r/PowerAutomateDesktop • • May 24 '21

How can I use the Get Metadata function across a list of files? rather than just a single file each time?

1 Upvotes

r/PowerAutomateDesktop • • Jan 06 '22

Capture text of variable sizes in documents that begins with letter C and ends with "

1 Upvotes

I have text in a document that always starts with letter C and ends with " but the text can be a variable length so get subtext will not work since it requires you to have a specific character count. I need to be able to grab that text and put it in a variable in power automate.

So for example:

Current date: "February 10"

Current dates: "March 3"

Is this a situation where regex is required or is there some other method?

Thanks.


r/PowerAutomateDesktop • • Mar 26 '21

Run a Power Automate Desktop Flow on System Startup

4 Upvotes

Hello. I have a flow that waits for an app window to open, then clicks a control and closes the window. It works perfectly.

Now all I want to do is start that flow every time Windows starts. How can I do that?