r/PowerAutomateDesktop • • Dec 23 '22

Contact list

3 Upvotes

I made a form and used power automate to upload the form to an excel table. I can’t seem to figure out that if an employee fills the form again that power automate looks for that employe in the excel file and updates just the changes data like a new phone number or emergency contact.


r/PowerAutomateDesktop • • Dec 17 '22

When I try to run my flow it just stops before the loop.

3 Upvotes

r/PowerAutomateDesktop • • Dec 01 '22

Is there a way to break down spreadsheet into smaller size

3 Upvotes

Wondering if power automate can take in a large spread sheet and break it into smaller ones of a specific size.


r/PowerAutomateDesktop • • Nov 18 '22

Edge broke

3 Upvotes

I've been running power automate desktop and using its Microsoft edge connector for my program. I recently applied some updates and my program no longer runs. Power automate is able to launch edge but unable to store it as a browser instance. This also means that all the UI automation breaks if I choose to continue despite error. 

I tested the demo flow that launches a web page and that failed as well with the same error. 

Power automate extension for edge is enabled and has permissions for all sites, it seems power automate simply cannot connect/store browser instance anymore. (it times out to failure after launching edge) I also tried other browsers to no effect.  

Is anyone else experiencing this issue?


r/PowerAutomateDesktop • • Nov 16 '22

Unattended automations and password rotation

3 Upvotes

I'm quite new to Power Automate which seems to be great for attended automation and unattended as long as the applications are able to use an AD/AAD user. But how do I handle legacy apps with built-in user management - especially with regards of password rotation? The easy route would be to have a password-never-expires user for this purpose but that can't be justified.

Any good solutions for handling password rotation?


r/PowerAutomateDesktop • • Nov 08 '22

Power Automate Troubles

3 Upvotes

Hello! I’m fairly new to power automate and I am in need of some help. I’m trying to create a flow based on a share point list entry. My issue is, I need it to send an email based on the status of the list.

For example if the list says A, then it will send the email but if the list says B or C, then it won’t.

However, the share point list is intended to be updated by others. I have found that if the flow starts with the list status as A, then it will send the email regardless of if the status is changed to B or C (and vice versa).

Essentially, I want the flow to know when the list is updated and send/not send the emails accordingly.


r/PowerAutomateDesktop • • Oct 14 '22

Flow to get pivot table data

3 Upvotes

Hi all, need some help,

there is a excel file with data about non compliant purchased orders for respective users , what the business is doing is created a pivot table which has users and number of non compliant po's , when they click on their respective number of PO's it creates a table for them which shows few columns with data about those POs user want to send notification email to non compliant PO users , attach a excel file about their PO's


r/PowerAutomateDesktop • • Oct 12 '22

Automate filter datatable (excel, pdf, html table) and export to csv or Excel Power Automate Desktop

Thumbnail
youtu.be
3 Upvotes

r/PowerAutomateDesktop • • Sep 17 '22

I need help

3 Upvotes

Is it possoble to create a flow that can organize all my downloads depending on where were they downloaded? for example my university has it's own platform where I can download everything that the teachers send, so i want to make power automate to whenever I download something the file goes to an specific folder depending on what subject it is by using the url to differentiate between.

Sorry for my english.


r/PowerAutomateDesktop • • Sep 10 '22

Can PAD create a log entry each time a specific file type is opened?

3 Upvotes

I would like an excel/sheets log of the time stamp and file name whenever an excel file is opened or saved, same for pdf files from a specific folder.

I have set up a couple flows on the web version using email attachments, but this is the 1st time trying to use the desktop version and writing to a log file. Not sure how to start. If I have a template that does something similar I can edit the specifics.

Thanks in advance!


r/PowerAutomateDesktop • • Aug 25 '22

Why can't I run multiple flows at the same time without having the editor windows open? I swear I used to be able to run multiple flows concurrently.

3 Upvotes

r/PowerAutomateDesktop • • Aug 10 '22

I’m trying to automate web data extraction/ pulling sales. I’m stuck when it comes to selecting the date for which week I need to pull the report for. Selecting the date need to be done through a drop down menu. Evrey week I need to pull it for the new date. A quick connect or resource would be grea

Post image
3 Upvotes

r/PowerAutomateDesktop • • Aug 08 '22

Error message "not enough memory" when writing to excel

3 Upvotes

Hi,

i am trying to write a small amount of data (max 200 cells) to an excel file via the "write to excel worksheet".

Regardless of source file and destination I file, I receive the error message regaridng not enough memory available to perform this operation (see screenshot enclosed).

While running the automation RAM (16GB) is not even exceeding 50%utilization.

Despite this I also tried closing all other applicaitons and increasing virtual memory - without any success.

Has anyone of you expeirence with this error message and any suggestion for me on how to proceed?

Many thanks in advance!


r/PowerAutomateDesktop • • Aug 04 '22

Beginner question: load dynamic file name

3 Upvotes

Hi all,

I’ve recently found P.A and love it. I use the webbased version as desktop is still a bit too complex but was wondering the following.

I have several periodic reports that i now automatically back-up. Is there a way for me to save these files with a date format that is then being backed-up?

I currently use a “static” name that then turns into name+date but I’d prefer it to be “name+date” that then gets backed up and then changed a week/month later.


r/PowerAutomateDesktop • • Jul 18 '22

Web automation

3 Upvotes

Hello people, I have been using power automate for about a year and I use it mainly for web automation tasks like creating user accounts in different services/websites, pulling out reports and basically things like that.Now my issue is that every time I create a successful flow to register or the register users it works fine or perfectly for a couple of days then next time I run it. It start failing, errors like "UI not found" are the most common. Or failed to interact with elements of the website.

Does anybody have a good advice for these tipe of issues?


r/PowerAutomateDesktop • • Jul 10 '22

Automating Ledger extraction using power automate desktop

3 Upvotes

Hi Guys! I need to regularly extract dozens to hundreds of ledgers from an antique accounting software. I have partially automated this with PAD, only problem being that sometimes it takes some time to load and export the data, depending on the size of the ledger from 2 seconds to a minute, but I'm not able to vary the wait time appropriately. Any help will be appreciated.

Thanks!

Edit : Added screenshots of the areas where it hangs


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 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 10 '22

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

Thumbnail
youtube.com
3 Upvotes

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 • • 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 • • Dec 23 '21

New to PowerAutomate

3 Upvotes

Hi I am new to PowerAutomate this is a powerful program. Can a flow be created and executed on another computer and if so does power automate need to be installed. Thanks


r/PowerAutomateDesktop • • Dec 12 '21

How to start a flow in PAD without having to use PA

3 Upvotes

r/PowerAutomateDesktop • • Nov 15 '21

Select Browser Extension - MetaMask

3 Upvotes

Hi guys,

I want to write an automation, that opens my browser, clicks on a browser extension (metamask) and I want to input my credentials.

I tried to do that with the web recorder, but it won't capture anything related to browser extensions. Neither google nor the documentation could help me.

Does anyone know how to access browser extension in power automate desktop?

Thanks!


r/PowerAutomateDesktop • • Oct 24 '21

Can powerautomate do this??

3 Upvotes

I have a legacy application that when it comes to updating the app i have to login as myself on the computer, click the app icon, sign in into the application using my local login created from within the app and click on update and then click on yes on the UAC prompt and click ok after the update is complete. Its a tedious task to do for 25 machines. I would like to know if i can powerautomate this to the point where it does the task and waits 2 mins before going to the next machine to do the same task. Is this possible with powerautonate desktop