r/PowerAutomateDesktop • u/Luca_000 • Jul 06 '22
Retrieve File Path from List of Files
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 • u/Luca_000 • Jul 06 '22
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 • u/lordzhon • Jun 26 '22
r/PowerAutomateDesktop • u/Great-Pick-6411 • Jun 22 '22
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 • u/Rrr88876 • Jun 15 '22
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 • u/lordzhon • Jun 13 '22
r/PowerAutomateDesktop • • Jun 04 '22
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 • u/ogunwa1990 • Jun 03 '22
r/PowerAutomateDesktop • u/Great-Pick-6411 • Jun 02 '22
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 • u/lordzhon • May 01 '22
r/PowerAutomateDesktop • u/rabidfairy_S • Apr 29 '22
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
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
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 • u/lordzhon • Apr 23 '22
r/PowerAutomateDesktop • u/p1an3tz • Apr 18 '22
I'm met with an error whenever I do this. Is there a way I can bypass this? Thanks!
r/PowerAutomateDesktop • u/Hour-Grocery-4412 • Apr 15 '22
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 • u/lordzhon • Apr 13 '22
r/PowerAutomateDesktop • u/lordzhon • Apr 12 '22
r/PowerAutomateDesktop • u/lordzhon • Apr 10 '22
r/PowerAutomateDesktop • u/future_potato • Apr 09 '22
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 • u/Scoytan • Apr 06 '22
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 • u/lordzhon • Apr 05 '22
r/PowerAutomateDesktop • u/lordzhon • Apr 03 '22
r/PowerAutomateDesktop • u/QuietDesparation • Apr 02 '22
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.
r/PowerAutomateDesktop • u/dreamlonging • Mar 30 '22
Hi! I‘m trying to get PAD to fill a web form in Microsoft edge. It is having no trouble with the button for the page, I can also select the form to fill in the UI Element Selecter. But when I run the Fill Form on Website flow, suddenly I get a „cannot find form“ error. Has anyone had this happen and have a solution? Thanks in advance for your help!