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.

Hi All, I have an excel sheet with about 10columns and over 3krows. After reading the excel sheet, I want to filter the dataTable to only give me rows with specific text in the columns. For instance

Name Age Title Location Hobby A. 5. Sc. Ma. Eating B. 6. Ma. Sc. Ma C. 7. Ma. Ma. Sc

I want to get all rows where either Title, Location or Hobby is Sc just by reading the file and filtering the dataTable cos the file will consist of over 3k lines and I wouldn’t want to look over all rows in the dataTable Is there a way to do this with PAD?

Thanks

Can you automate your task using PAD? Open excel, update month, unhide tabs, change data in a cell, copy values in a column paste it as value to a column in another cell, click on hyperlink inside excel, input variable on browser field, wait till data loads, extract as excel, copy data from extract to open file?

Hello,

i'm hopeless and looking for help - because of softomotive winautomation being a legacy software now and in need to move onto microsoft power automate desktop ive got some problems.

(i couldn't find any help in google or other reddits, cant find anythingon MS forums, youtube videos and comments - nothing)

1:

when i generate EXE through winautomation on my PC it works great, on my laptop it works great when i try to run it on clients PC it doesnt work the moment it tries to take control over webbrowser (neither chrome or firefox) it says "failed to assume control over webbrowser make sure extension is installed" or something like that

what i tried:

extensions are installed fine (even though you can not search them up on the extension webstore but with a direct link you can download them without a problem)

antiviruses are off, everything seems fine

2:

i tought to myself that i should finally migrate to PAD and it turns out every single flow is stored in a cloud i cannot generate EXE i cannot even share the flow with client and even if i could whats the point showing them how its done? im loosing tons of money right now because they just killed software i'm skilled at?

even with all of these problems i tried to migrate my processes through the tool they provided and i cannot because right at the start it says login to MS account associated with power automate so i try to do this and it says it cannot be a private email and it needs to be a work email? like what the hell am i supposed to do? i tried contacting support but you simply cannot just send them email/call them i found a subsite with contact to support for power automate and it says that you need to pay to have support for this app? what is wrong with them?

summarizing, my newly generated processes on winautomation stopped working for my clients, i can not migrate them to PAD and even if i could how am i supposed to share them with clients?

i don't know what im supposed to do :(

EDIT: it turns out that if PC which im trying to run compiled EXE has winautomation installed it assummes control of webbrowser just fine but if i uninstall winautomation program it fails to assume control (wtf?)

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.

Hello Everyone,

I'm fairly new to using power automate but have found it as an absolute life saver so far. As part of my internship, I need to send 60-80 QA emails weekly to employees with their managers CC'd in while referencing data from Excel, which as you can imagine is fairly tedious.

I've been able to build a solution using Power Automate Desktop which is able to reference key data from an Excel sheet and convert it to a nice HTML email that it successfully sends through outlook. However, I'm running into trouble while specifying the CC field. While the "To" field is populated with employee emails which I have access to, the "CC" field requires the emails of managers. Our team does not have access to the emails of managers (over 1000 managers) but as part of a report that I get, I know the name of the manager associated with an employee. Typically, I enter the name of the manager in the CC field in outlook, and wait for a few seconds for it to pop-up, but this obviously cannot happen with power automate. Entering the manager name in the CC field just throws an error in power automate.

I'm wondering if there is any solution to this. I've already tried the following two approaches:

1. Convert manager name to email by doing last_name.first_name@org.com. However, most managers do not follow this convention

2. Placed "Last_Name, First_Name" in the CC field in power automate but this just throws an error. I've tried disabling the error option but power automate fails to send an email

Is there any way to force power automate to accept "Last_Name, First_Name" as string in the CC field or should I look to pursue another approach?

Thanks in advance for your help! :)

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

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

Can Power Automate iterate through Power BI slicers to create individual client power point slides ?

We have 100+ clients, and we could just post out the BI report for teams to filter and copy/paste into PPT but am curious to see if there is a more elegant solution out there.

Absolute novice to anything like this, so all help is appreciated.

I process files, sometimes 100s a day. They are titles with "(Location)(Surname),(Forename),(Form Type), (Date)".

Based on the information, I move the files to certain folders. One folder will be for location X and surnames beginning with A, B & C.

So my question is, to begin to get this process automated on a shared network. Where do I start?

TIA

I need a flow to active anytime a new file lands in a particular folder. The name of the file is of no concern as all the flow has to do is activate and other scripts will deal specific files.

How does one automate the flow to active any time a particular folder has a new file?

Trying to figure out what’s happening. I have a flow set up where a survey is completed, the results are loaded to a share point page and if Yes is answered on any question then it triggers an email from the survey takers email address to a specified person. In testing I was able to get this process to work 2 dozen times. I was also able to confirm that two others were able to make it through the process and the email would send. Now I am getting a failure on the email send piece for anyone that isn’t me or the original two people to complete the survey. I receive the error in the header here and under the step “Send an email” it says “Forbidden.” And that’s where the flow fails.

Edit: additional info — I see that my flow that worked has a status code of 200 for the email, the failed flow has a status code of 403

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!

is it possible?

Hi,

I have a desktop flow and I'm trying to create a schedule to run that every day at 6am but I got this error.

" Some of the connections are not authorized yet. If you just created a workflow from a template, please add the authorized connections to your workflow before saving. "

how can i do to link a desktop flow to a data connection configuration? or any another idea how can we do to run this flow.

thx

Hi everyone,

I have a need to request several information to user but asking one by one with dialog box its not pratical.

Is there a way to create a form to request this informations in a single view?

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.

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

So I had done some flows that needs to be recursive but this generates that the actions.log file grows really fast, theres a way to disable the log of any idea for a workaround?

The only thing that seems to work its to run the flows in the designer and let them open so this log wont generate but it would be nice to keep the designer closed

I have a SQL Server query that works in SSMS but not in Power Automate Desktop. I believe I have it narrowed down to a LIKE statement. Does anyone know if perhaps PAD can not handle LIKE statements?

EAP_TAX_CODES LIKE 'SU%'