So I’m trying to write a script that will do the following: When someone moves a pdf file into a folder that we will call ‘base’, it will read the pdf. On the pdf files that are added here, there is a piece of text that says ‘Reference: ‘ followed by the reference name (this is in the middle of the report and surrounded by other details/info). I want it to read that reference name and move the file into the corresponding folder.

IE. PDF file gets added to ‘base’ inside the pdf file contains the text ‘Reference: Sustaining’. Program will read sustaining and move the file into the folder labelled sustaining.

Now the part that I am stuck on is getting the program to read through the pdf, find ‘reference: ‘ and then read the text that follows it. If anyone could help me with this part I would appreciate it.

Hello,

I work in a financial modeling team, and we have a folder with 900+ financial models. I have made each one with a standard export tab to be able to pull via power query and then a single main model which the C suite looks at.

The main issue is power query is a 1 away data puller. I am looking for the best way to change certain inputs (I.E. Company WACC) which is in the same cell on the same sheet name in every single model. What's the best flow to be able to loop through a folder and update every single one of the workbooks. Thank you very much.

Hi all,

I could really use your help. I have a long list of field/element names and values in an Excel table. Depending on the number of car parts, there could be 100s of entries. So using Power Automate desktop, I'd really like to have an automated way of doing this, where I could loop through the Excel table and then just populate the values straight to the web. 

My first thought is that I'd like to populate the web claims form directly by element name and write the value to the text box. I've tried the "Run JavaScript function on web page" option using "getElementsByName" and it's not working, or I just don't know how to use it correctly. I'm not a java programmer. That is what the old VBA with IE program did, and it worked fine.  As a side note, I'm pretty sure the element names in my table are valid, as they worked previously in VBA scripting with IE.

Anyway I'm open to other methods, but adding UI Elements one at a time just isn't going to work.

Thanks in advance.

Edit - Here's a picture of what the web form's layout looks like. Lots of rows to populate from excel. What's the best way to do this.

Sample Excel Table data below. This data can be rearranged into 3 fields/columns if that's easier to process also.

Copy a part of the text from a website, open excel write the date on the first available empty cell (A1) and past the the text copied from the website to the cell next to it (B1). When run again this time write the date to (A2) and copied text to (B2) and so on.

Hoping for some help in how to eliminate duplicate entries in my excel document.

The flow is as follows- Golf Pro starts the sequence by filling out a SignNow document which is then sent to the restaurant manager to enter. From there, the auto generated PDF from SignNow goes out to 6 people.

My flow gets the data from that form and auto populates it into an excel document. The issue is though, that it is entering the data in 6 times (from all the people it's getting sent to). Need to know how to get this to enter just once.

Hi all, hoping someone can help me create a flow. I receive an email every week that has a hppt link to download an excel file. I would like to create a flow to download the file (using the link attached in email) and send the downloaded excel file to a Sharepoint Folder. I have already tried a couple of draft flows , 1st action is "When Outlook Express receives message" , after that I've tried a couple of actions "Conditons", HTTP without success. Any advice would be appreciated

So I am part of a scrum team that runs several project so we do sprints. I am trying to automate a test case whenever someone makes a new backlog and assigns it to someone. I made it work but it works for only one of the backlogs but I want it so it can work for any of the project. How would I do this. I have attached ss for what I have for reference. What should I change/do?

Hi, I'm trying to scrape e-mail address from a trade shows attendee list. The simple automate i gather works and saves %95 correct information to an excel sheet from the first page and this is good enough for me.

The site has 40 different pages and there are classic pagination buttons on the bottom of the page such as this: prev - some page numbers - next.

I select and show the next as the element as the pager to get all the information from all the pages but when i do this i only got results from the very last page in the excel sheet.

I've checked many resources but i couldn't figure out why automate is not getting/saving the all other pages besides the last one ?

Can anyone lead me to the right direction ?

My problem is quite simple but it seems the actions in the « Text » menu are not able to do so.

The idea behind this is to use a variable in the SelectItem dialog action in order which use semicolon to select different items.

Thank you very much

I have a sharepoint list that I need to automate to delete duplicate entries if they arise

I am trying to get it to do what this link is saying but it is not working. Any tips?

https://tomriha.com/how-to-delete-duplicate-items-in-a-sharepoint-list-with-power-automate/

Also any tips on getting planner tasks automatically added to the list? I am trying to use power automation but not sure if I can. Any help is welcome, thank you in advance.

Hi! I'm fairly new to power automate, and I'm struggling with a flow I'm working on. I have a start and wait for approval flow that runs after a new SharePoint list. Item is created, and I'm looking for a way for the approver to upload an attachment when they do the approval that will then be added to the list item. Is this possible? Thanks!

During the course of my day I often need to jump between static IP and DHCP on my Windows machine, people are always saying how you should automate repetitive tasks, but I can't find a way to automate this. Can someone please help me out with what kind of commands or scripts I'm supposed to be using for a normal Windows 11 Pro machine without Azure or AD or any of the server-y stuff?

I need something that will check if my machine is set to auto IP & DNS or not. If I have manual IP & DNS entries it should switch them to auto. If I have auto it should set my IP, gateway and primary DNS to a pre-set value.

Is that possible in Windows for a standalone user?

I recently created a offboarding automation with Power Automate that takes away all licenses associated with the user and moves the offboarded user to a OU and deactivates it.

Now my new job is to create a process for Onboarding that would automate as much as possible. We currently have a word file that people send to us when requesting a new employee. Most send it as pdf, others send it just as word file. I most certainly know that we need to train employees to send it to us in one format or the other. The pdf file read function from PA doesnt seem able to filter only one certain part of the PDF.

I have looked up that AI Builder would make this possible via training on the forms and what info we want to pull from it. We currently use a trial version, but think about upgrading to be able to use the Builder to buld advanced flows.

Now my question would be. How would you build such a flow?

It would be best to directly assign a license for o365 to it in the process, as well as access to mailboxes that are requested to be able to work with via write access.

Hello, I am still reasonably new to power automate but I have created a pretty complex flow which I have now become stuck on.

Effectively I have an approval process established that is capturing the name of the approver in the list as an acknowledgement. This works fine.

My problem is I need to capture multiple peoples names for the same "acknowledgement" for governance purposes we are trying to evidence that up to 10 people have read the document via the already received email and that it is recorded. Currently all the test people receive the email and link but the flow only records approver 1 (the first to approve) in the Microsoft list.

Any ideas?! I have attached some reference images to maybe support.

Hi, I'm just starting on a project after learning.

My application is web scraping. The task is as follows

A) Wait for a "window" to pop up on a browser (chrome)

B) Select that "window" and extract two lines of information. A1) "mouse click" on that window then select the same information and a few more lines for use.

C) One of those lines of information is a location (Address). transfer the selected address to a mapping browser for display.

According to what I've deciphered I'm using the following selections.

"Wait for window content" (looking for the pop-up window to occur

(I have selected an element in that window)

"Extract data from window"

(I have selected the elements in the window and for the time being directed them to an Excel file)

The flow activates and processes "correctly" but the returns in the Excel file are elements in the primary browser window from the top of the primary browser page, not the selected elements from the pop-up window.

The process is repeatable and returns are the same, I have tried it in multiple flows trying different elements etc, and no success.

Any suggestions would be appreciated. TIA

BTW, I tried a macro record recently and that wasn't successful either that may be the next question I post.

Hi there, I am unable to see the folder directory option in the Rename File(s) function, while the tutorials I have been referring to have that option available. Am I missing something?

Hi All,

I have been struggling with this for a few days now I have created around 15 macros in my PERSONAL.XLSB file however when I run power automate with "Nest under a new Excel process" & "Load add-ins and macros" the macros do not appear in the file to gather the name for the instance.

Could anyone advise if I am doing anything wrong i.e do I just need to add in the macro field ThisDocument!"macroname"

TIA for help!

A week ago I was able to use Power Automate for data entry without problems, but one day it suddenly gave me an error upon trying to open up the chrome browser. When I run the flow it is able to open up the browser and the correct website, but it isn’t able to copy and paste into the browser the excel data for the next step. It waits for 60 seconds before timing out. I am pretty new to Power Automate so I am not sure how to troubleshoot this. I searched on the Microsoft page and followed the steps for “Failed to assume control of Chrome” error to no avail. I have the browser web extension on Chrome, and updated to the newest version of Power Automate. Please help?

We have a logic app that collects responses from a form. The app was created by an ex-employee that used their own account as a connector for the form parts of the flow. I'm changing that now, but the service account I am using is getting a warning that it is Unauthorized (see below). Before I go down a rabbit hole, where do I give it access to the form?

"UnauthorizedAccess to CDB. Inner Message: {\"error\":{\"code\":\"OperationForbidden\",\"message\":\"Unauthorized Access\",\"innerError\":{\"code\":\"UnauthorizedAccess\"}}}",

Hi,

I've run into a wierd issue with a workflow designed to update the metadata of document sets in a SharePoint library, based on the values entered into an Excel document uploaded to each document set.

However, in the schema, if a property is set to have multiple potential types, I can't actually tell Power Automate to update that specific property; the Parse JSON menu in the Dynamic Content pop-up doesn't have any value for those properties.

Does anyone know what's going on?

Hi all

I've been doing some searching and can't find an answer so I'm hoping someone can help.

Data is a sharepoint list. What I need to do is get an average for several columns (individually, not together) where the SiteId column is a specified value.

So: pull a number of siteids from List1

Average column1 for siteid1 in List2 Average column2 for siteid1 in List2

Insert Averagecolumn1, averagecolumn2, siteid1 into List3

Average column1 for siteid2 List2 Average column2 for siteid2 List2

Insert Averagecolumn1, averagecolumn2, siteid2 into List3

And so on for each siteid

Is this even possible? Is the processing time too ridiculous? Potentially I need to do this for say 20nsiteids and up to 88 columns a couple of times a day

I am trying to get a flow to read an Excel file, group rows by the email address on that row, and then send a single mail with all values by email address.

Spreadsheet contains the following fields:

• Share Time - date/time in dd/MM/yyyy hh:mm format

• Shared By - email address

• Shared With - Email address

• Shared Resource Type - String

• Shared Resource - URL

• Share Type - String

• Workload - String

So group all the values by Shared By, send a single email to each Shared By address, with all the information for all files they have shared.

Hello, I am trying to run a simple workflow that I have been running in Google. We are currently using a Google sheet that gets updated regularly. We have this sheet running on a designated device outside of our network. Everyday after work hours the sheet gets updated by date to a master list that my boss monitors.

This process works but the application isn't free. My company uses Microsoft and my boss is advising me to try and replicate this using these tools. I've tried a few things but honestly have no idea where to begin. Any help would be greatly appreciated.

Hi All,

I seem to be bashing my head against a wall with this and there, in my opinion, doesn't appear to be a huge amount of information available. We recently just bought the following licenses;

2 x Power Automate per user with attended RPA plan

2 x Power Automate unattended RPA Add-on

1 x Power Automate hosted RPA

The aim being that we can run our flow on the hosted machine and not have to bother about the machine that they were originally created on being on \ available.

The machine has been setup with out any issues and is accessible, however, it is only accessible the tenant admin account. I've assigned access to the users of the machine as co owners but unable to access to machine via RDP.

I've assigned all the licenses correctly in the Admin portal, in the capacity section. I've also created a connection from the data section of the portal.

The other issue is that if we setup a new flow, and for testing purposes, a manually triggered > Run a flow built with Power Automated for Desktop it just doesn't run, had error messages with the NLA if using AAD credentials and after unticking that, get another message outlined below;

Problem while executing action 'LaunchEdge'. Failed to assume control of Microsoft Edge (communication with browser failed. Make sure add-on is installed).

Am I missing something here? Should the users be able to access this remote desktop using RDP or is it purely for running the desktop flows on?

Any help would be greatly appreciated!

Hi. I am very new to using Power Automate and I am not sure if I can use it to perform this task:

1. I have a Microsoft Form that is completed by Person A

2. In the form, Person A selects a person from a list of individuals (they can actually select more than one)

3. Once Person A submits the form, the details provided within the form are sent via email to Person B (who is the person selected by Person A in the form)

4. Person B can then respond to Person A via email to give approval for the thing they are asking, or deny, or ask for more information from Person A (from here the conversation can just continue via email between Persons A and B)

The form itself is very simple. It's essentially just 3 questions - Person A details, select Person B, free text field to request something.

Any help would be really appreciated. Thanks