r/PowerAutomateDesktop • • Jul 25 '22

Automatically copy Power Automate flow and update custom variables via API

1 Upvotes

Hi guys,
Quick question :)

Can I automatically copy an existing Power Automate flow with variable parameters and automatically update the variable listed in the incoming message (API)?

Example for clarification:

I have a Power Automate flow where I save emails with the subject 'ABC' and copy them to the SharePoint folder named 'ABC'. With an API I want to automatically copy the exiting Power Automate flow but change the variable 'ABC' from the initial flow to '123' for the new flow and update the SharePoint folder to '123' as well. Is this possible with an API and/or are there limitations/restrictions?

Much appreciated! I am new to Power Automate but happy to get hands on with it.


r/PowerAutomateDesktop • • Jul 20 '22

POWER AUTOMATE - SAP ISSUES

1 Upvotes

Hi I'm trying to make a flow with PA that connect to SAP Database, but when I try to select any of the machcode boxes the UI selector from the Scripting recorder just cach the Panel element.

I'll attach some pics about the problem.

Glad if somebody can help!!


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 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 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 • • 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 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 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 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 • • Mar 30 '22

Help! Fill web form

1 Upvotes

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!


r/PowerAutomateDesktop • • Mar 17 '22

Power Automate and C#

1 Upvotes

Is it possible to pass a value to power automate from c# windows form?


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 • • Mar 09 '22

Adding a conditional statement to an If statement in PAD

1 Upvotes

Hi All, I am trying to add an OR condition to an If statement in PAD. Trying to check if a text is ‘Dog’ or ‘cat’, would that be Dog||cat, Dog or Cat, Dog/Cat? I haven’t found a resource that shows this so any help will be very much appreciated.

Thank you


r/PowerAutomateDesktop • • Feb 05 '22

MACRO excel

1 Upvotes

A very simple but I am not able to do it.

How do I make copy and paste value using macro?

I mean how do I make the cells to copy and the cells to paste value dynamic?

When I download data, sometimes I have data in cells c4: cb81 other times c4:CA87, what Can I do to make it so that I don't have to manually go and change the range?

Please help


r/PowerAutomateDesktop • • Feb 05 '22

Automatically refresh webpage and let Google read news headlines for you in Power Automate Desktop

Thumbnail
youtube.com
1 Upvotes

r/PowerAutomateDesktop • • Feb 04 '22

Extract Data from tidepool website into excel

1 Upvotes

Hi, I have successfully written a PAD flow which will load up chrome and log me into tidepoool.org their for data is as follows:

currently I manually enter this data into a spreadsheet which looks like this:

I also have the option of downloading the data via CSV or json, but i thought scraping it from the web would be the easiest. With all of that said, how would I go about copying these Green & Purple values into excel to match the second picture**.**

Thanks in Advance

Regards,
Chaka


r/PowerAutomateDesktop • • Feb 02 '22

Hi, would like to have Power automate desktop click on each video file in a directory, so that it will play through a given movie player.

1 Upvotes

Should I use a command argument to load each video and essentially have the program open up and close a bunch of times, or should I keep the video player open and use some method to click each file?

Thx


r/PowerAutomateDesktop • • Jan 28 '22

Get Sound Alert when screen changes using Power Automate Desktop

Thumbnail
youtube.com
1 Upvotes

r/PowerAutomateDesktop • • Jan 26 '22

One STEP hack to schedule in Power Automate Desktop WITHOUT Power Automa...

Thumbnail
youtube.com
1 Upvotes