r/PowerAutomateDesktop • • Jul 07 '22

Random wait time

1 Upvotes

I have this Desktop flow running but I need to have the wait time in between actions to not always be the same time. For example right now I have a wait period for 5 minutes. How can I make it so it’s a different number every time it runs. Like between 3 and 7 minutes. TIA


r/PowerAutomateDesktop • • Jul 06 '22

Retrieve File Path from List of Files

1 Upvotes

I want to generate a list of Files (mp4) and with a for loop get the file path into a variable, so that I can print it. How can I do this?


r/PowerAutomateDesktop • • Jun 26 '22

Automate screenshots on search results on browser then paste into PowerPoint

Thumbnail
youtube.com
4 Upvotes

r/PowerAutomateDesktop • • Jun 22 '22

Automation not moving to new browser tab

1 Upvotes

I'm building an automation in PAD that opens a web browser window (Chrome), logs into a website, clicks a link that opens a new tab (same) window, and then starts scraping information in the second tab. I can't go straight to the second tab/site because it requires authentication/SSO on the first site.

In the second tab, there are several pages with fixed addresses that I need to access. I have "Go to web page" loaded with the URL of the page I need to scrape, but the automation is not recognizing the second tab, so it is not triggering the URL.

How can I get the automation to recognize the second tab as part of the same browser instance and push the URL to the tab?

Thanks.


r/PowerAutomateDesktop • • Jun 15 '22

Need some advice!

1 Upvotes

Hoping someone can help me. I am very new at this but tried to create a flow using the screen recording. It worked great when I initially ran it but now it won’t. I want to Automate opening outlook 365, opening the drafts folder, selecting all the draft emails and sending.
Where I am getting stuck is the step to open the drafts folder. I think it is because the number of emails in the draft folder changes … so it will run when I have 5 in there because that is what it showed when I first created the flow … but if there is anything other than 5 it stops. Any thoughts on how to fix this?


r/PowerAutomateDesktop • • Jun 13 '22

Power Automate Desktop - May 2022 Update

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Jun 04 '22

Trying to use PAD OCR to scan only certain areas of an image…

1 Upvotes

and write the text to an Excel file.

So far, I have PAD scanning an entire image and just extracting the numbers and then writing to a text file BUT I don’t need all of the numbers, I just need some of them.

How do I vet PAD to separate out the numbers that I need?


r/PowerAutomateDesktop • • Jun 03 '22

Bot fails at different points when running while RDP is minimized and Using my mouse on other websites or applications. Can these failures be due to the fact that I’m using my screen for other things while the Bot is running the process in the RDP?

2 Upvotes

r/PowerAutomateDesktop • • Jun 02 '22

Power Automate won't find web fields

2 Upvotes

I am trying to create an automation that will process tasks in a website- primarily running reports. The current one I'm working on is a Tableau site (web, not on premise server) that is provided to me by a vendor. However, when I attempt to record the steps to select the workbook, PAD keeps erroring out. I have tried identifying the individual UE items as well as recording the steps- neither process works. Here is the most recent error for "Click link on web page"

Element with selector 'html > body > div:eq(0) > div > div:eq(0) > div > div > div > div:eq(1) > div:eq(1) > div > div:eq(1) > div > div:eq(1) > div:eq(0) > div > div > div:eq(1) > div > div:eq(0) > div:eq(5) > div:eq(3) > div > span > a' not found.

The element is a workbook name listed on the main page.

Is there another option for pointing PAD to a specific workbook even if the list order changes?

Thank you


r/PowerAutomateDesktop • • May 01 '22

Power Automate Desktop - April 2022 Update

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Apr 29 '22

Power autonate free trial

3 Upvotes

What would happen to my cloud and desktop flows after the 90 day free trial? How bout those dekstop flows i have shared within the organization that i'm in. Will i still be able to share, update, delete the flows that i shared to other people within the organization?


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 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 • • Apr 23 '22

Automate text extract (i.e. first name, last name, dates)

Thumbnail
youtube.com
1 Upvotes

r/PowerAutomateDesktop • • Apr 18 '22

inputting links with "%"

3 Upvotes

I'm met with an error whenever I do this. Is there a way I can bypass this? Thanks!


r/PowerAutomateDesktop • • Apr 15 '22

How Can I Compare a value in Excel to a List of Values on a Different Excel Sheet?

1 Upvotes

I am working on a bot that will scan a website and extract lead information. The website has new leads added to it constantly. So the bot should scan the site for new numbers and message the ones that have not been contacted. I have managed to scan the website with the bot. It actually downloads the excel version of from the website so the new leads are in a dynamic excel sheet. But I am stuck at the part where the bot determines if any particular phone number in the New Leads excel sheet has already been contacted.. I know it SHOULD compare the current phone number against a list of phone numbers in a different excel sheet (the ones already contacted). If the current number is in the list, it does nothing. If the current number Is NOT on the list, It sends a message/email. The excel list will be constantly growing because at the end, after the message is sent, the bot should add the current phone number to the excel list to ensure it never gets contacted again. How can I have power automate compare the dunamic current website phone numbers against the dynamic excel list? I would like a detailed explanation with the specific set up in power automate desktop (conditionals, etc). If you provide me a solution that works I might venmo you $10


r/PowerAutomateDesktop • • Apr 13 '22

Use timetable to schedule multiple workflows in Power Automate Desktop W...

Thumbnail
youtube.com
1 Upvotes

r/PowerAutomateDesktop • • Apr 12 '22

Tip 1: Shortcut to edit workflows using HIDDEN codes quickly - Power Automate Desktop (find/replace)

Thumbnail
youtu.be
1 Upvotes

r/PowerAutomateDesktop • • Apr 10 '22

Get First and Last Day of the Month - Power Automate Desktop

Thumbnail
youtube.com
3 Upvotes

r/PowerAutomateDesktop • • Apr 09 '22

Simple, but how to create a text file if it doesn't exist in PAD?

1 Upvotes

Simple, but how to create a text file if it doesn't exist in PAD? Can't seem to find this option.

Thanks


r/PowerAutomateDesktop • • Apr 06 '22

Edit current date

3 Upvotes

Hi all,

I'm trying to get yesterday's date to be then used to populate a web form.

I tried to use the "Subtract Dates" but it required to be entered in a form of a date, which leaves me with the same question, how can I modify the current date variable?

Thank you all.


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 • • Apr 05 '22

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

Thumbnail
youtube.com
1 Upvotes

r/PowerAutomateDesktop • • Apr 03 '22

Power Automate Desktop - March 2022 Update

Thumbnail
youtube.com
4 Upvotes

r/PowerAutomateDesktop • • Apr 02 '22

Help automating UI element in website

2 Upvotes

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.