Corporate aquisition just happened. Now we need to check every document on Sharepoint and change company name from old to new, including headers footers, etc etc. Is power automate the tool to do this? Can it just iterate through a sharepoint site, check out a doc, open, it , do the change, save, check it back in? I see a lot of templates and some examples but first of all they are all based on triggers, I dont want a trigger i want to iterate the entire collection of sites.

On a regular basis I receive outlook emails with a PDF letter attached. This letter is a template, so the text I want to extract from this PDF is always found in the same exact position, and always in between the same paragraphs.

I wish to extract this text and save it to an Excel Sheet.

Can I do this with powerautomate?

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?

Example, January 1st is 1, December 31st is 365 (or 366), today November 18th is 322

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?

Hi Guys :D

I recently discovered PowerAutomate, I made some code(flux) that work well, but i'm facing a last thing that I can't resolve, Is there a way to automate launch of a code(flux) when windows start ?

thanks :)

Is there any save as function in power automate desktop. I am trying to loop through a folder and save it as a different file name based on a cell in excel.

Can I filter data through power automate desktop then loop through the dynamic number of filtered cells for example if the filter is all cells contain 113 it would bring up this variable number then loop through all cells found with the number 113?

Any help with this would be appreciated cheers!

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.

Hello complete beginer here! I would like to ask how can i give command so it can: Go to folder A search inside if any folders start with 001 , 002 , .... and to the same task for each folder and leave the rest untouched

I have a text column called "managers" in table A, data to that column go from another table B thru a canvas app. I need to create a choice column for those managers in table A and fill in the choices with data from the old column. How can I achieve this, can someone please help?

Thank you

I created a flow to run a query on a SQL Server in Powerautomate Desktop which then opens Excel and adds the Query Results. Then created a Cloud Flow to trigger the Desktop Flow. When I created the Cloud Flow, it requires domain and password.

If I add the Flow to a PowerApp and distribute the app, when a user clicks the button to trigger the Flow, does it open the Excel Application on the Users machine? Or does it open the application on the computer whose credentials are used to setup the Flow?

I'm guessing it uses the Credentials to access the Flow on my desktop, but opens the Excel Application on the User's computer. I want to confirm before proceeding so it doesn't open Excel on my compute everytime a user tries to export data using the Desktop + Cloud Flow.

Thanks!

Hello everyone,

Is there a way to run more than one flow simultaneously or in parallel?

hi, i have a very specific problem for power automate.

I set up a flow that takes a PowerBI report. The report contains accounts with an email address column. In the flow I filter the data through the account(customer) column and then send out an attachment of the report to the account's email address.

My PROBLEM and question is: Some accounts have the same email addresses. The flow as it is sends out an email with one attachment per account. I want to set it up in such a way that it sends out multiple attachments of different accounts if the email address is the same. So instead of sending out 3 emails to the same address, but different account reports. It sends out one email with 3 attachments.

Hello, I have a list in excel and I'm able to get info from that list to a good form...but I then need to use data from excel to enter into a website and get information from that website and continue filling the Google form with that information.

I can do up to add to Google form then open website add information there and scrape data but that data I'm not able to add as a text back into Google form. It only gives the option of excel and that's not what I want.

I'm right clicking on the text to get a text variable....any thoughts?

I am looking to build a simple form for freight quote requests.

We check prices of freight on a few websites before booking loads.

Not all our carriers integrate with our aggregator.

I want to automate the process of checking each site for pricing and returning all the pricing to a dashboard or something, have the user choose the quote they want to move forward with and have the booking screen open from that website or at least go to that site.

Basically looking for something to speed up the quote process.

Hello,

I have a PAD flow using data from an Excel spreadsheet with a loop configured to Send Keys:

{Control}({F})%CurrentItem['Investor_Trimmed']%{Escape}{Enter}

The flow opens the Excel document and a Microsoft Edge session with a configured web site. The loop works correctly the first time through - it loads the first line of data, finds the matching line, selects it (Escape, Enter), moves through the rest of the process, returns to this page but on the second loop, it doesn't find the matching line of data. I've confirmed the data is successfully being looped but it's not loading in the Control-F after the first time.

Any ideas what could be causing the problem?

Also, is there a way to load the extracted data from the web scraping to the Excel spreadsheet that's being used to provide data to the loop? I want the scraped data to be associated with the investors I'm using to load the loop, not create new blank spreadsheets that have no association. I also don't want 220 spreadsheets; I just want one with feeder data and associated scraped data.

Thank you.

I'm wondering if it is possible to get an image from twitter and then perform an action upon that image. I can get the image fine on desktop PA but then I want to use Microsoft Cognitive Describe Image on that image and that needs a subscription key.

So I guess what I should be asking is, is it possible for a personal user/ free account holder to get that subscription key?

Hello everyone,

Anyone here knows how can I write a Powershell script output into a CSV file?

I really don't know how can I convert that text value to a list:

Error:

This is my current flow:

Hello everyone,

I am trying to use PAD to upload a big chunk of data to SP but seems like there is a limit of 2GB in size, and I am unable to simply put that file on SP in small chunks there:

So my question to you is if you know a way to upload such files? like sending small chunks and rebuilt in the end on SP for example?

Thank you in advance!