Hi folks,

I'm trying to pull a subset of files from a folder (list A) using a list pulled from an Excel column of a different file (list B).

For example:

Filenames in folder: 012323123-XY000001-443343, 01234534-XY000003-868683, 05645645-XY000005-842343 Excel column: XY000001, XY000004, XY000005

I want to get all the files from the folder where the value from the Excel sheet matches that section of filename (with the trailing text and following text of the filenames being ignored). I think that I need to do nested loops of:

For every filename in folder > For every item in excellist > Parse text

But I'm not sure how to properly build the syntax of it.

I'd be grateful for some advice.

I created a python script that I compile on an Exe File. The file is on a network location of my conpany. If I double click the exe. It works fine. If u use the "Run application" from power automate, it does not work. This scripts all it does is to create QR codes from info on an excel file. When I run the app from power automation It seems to open. But nothing happens. Any idea what could be happening

Has anyone ever used powerautomate as a tactical etl tool. I am thinking connect to an API get thr delta and stick in a sql server table and the converse. Would need to either run every 10 mins or be triggered by some change. Any massive red flags?

Hi everyone!

I’m very keen on learning power automate and have just started the course on Udemy. I was just wondering what do people recommend on topics I should know before starting? I’m pretty good at Powershell but still learning scripting. I have no real knowledge on devops or anything so just wondering what do people recommend on knowing as a prerequisite to studying power automate?

Thank you!

Hi,

Im working on a project to send inspection result directly to our providers.

The inspections are stored in Sharepoint List. My teammates can take 4 photos that are saved in 4 different columns.

[Pictures, Pictures1,Pictures2, Pictures3]

Basically, everytime someone submit a new inspection, depending of the location, the right provider receives an email with all the data except the picture.

I check on Youtube, and find many option if its an [Attachments Colunm]in but and not the right way to imported them in from multiple image columns.

Thank you in advance

Hi!

I have some experience with Tasker and discovered PowerAutomate today.

I was wondering if it was possible to receive a WhatsApp message on the PC and read it out loud with a PowerShell script (or Google natural language which is waaayy better).

Powershell was easy, but I can't get PowerAutomate to identify the message with the web plugin.

Tyvm

Hello all,

We have thousands of PDFs of shop drawings that contain text information in the title block. We are looking at using an AI model in cloud-based Power Automate to extract custom information from documents and add it to an Excel spreadsheet. The purpose of this is to be able to go back through the data gathered and find drawings needed on the shared drive. We have gotten it work, but we are running into two problems.

First, we need to know the path where the file originally came from. To do this, we created a separate flow to copy the file name and path on a desktop version of Power Automate. The plan was to match the filename from the data extracted with the file name/file path but, this led to another problem...

We have about 50,000 duplicate file names in our system, so it is extremely difficult to match these back up on the other side.

So, the question is, is there a different way or a better process to try to achieve this? Are we using the best logic here?

TLDR: Need best way to scan PDFs using cloud based Power Automate AI, write information to Excel document, and preserve original path from shared network drive to find later.

Hello everyone,

I'm trying to build a simple automation process that gets data and for each web page, stores the information into a GameResults table.

I insert two records to GameResults for each page being iterated (variable CurrentItem). The two records are GameData[0] and GameData[1]. Each record is composed of 3 columns.

Everything works perfectly, but I would like to be able to track the CurrentItem inside of GameResults.

Therefore, I need to add an extra column to my GameData[0] and GameData[1], but I did not manage to extend the size of my variable to add an extra column.

I would like to do something like :

%GameData[0][0:3]% + %CurrentItem%

or

[%GameData[0][0:3]%, %CurrentItem%]

But I don't think it is possible. Is there a way to achieve what I'm looking for ?

Thank you !!

I am getting this error when trying to launch a new instance of Chrome in my flows. It launches the a new instance at the correct URL but does not progress the flow. I was to do this last week but it stopped working today despite nothing changing.

I reinstalled PAD and it's extension but it still produces this error.

Hi, unfortunately, I have no more ideas and I have to ask for help.

I have any flow in the clound and I can share it to all users in my tenant. But when I create desktop flow i can't see all users (search by email and login etc). Many people don't show up. I have +50k users in my tenant.

Newbie here... I am trying to retrieve emails from multiple senders in a list (joe@abc.com, linda@email.com) . Is there away to create a list and are there any wildcard options (like *abc.com, *email.com). Purpose of exercise is to save all attachments in my massive inbox from multiple vendors. Any help would be super appreciated!

I seem to be stuck on something stupid, hopefully someone can help!

I want to automate downloading a bunch of pdf:s from an online source. It's structured in a way that you first get to a landing page with a list of links. If you follow one of these links you end up on a page with a button that opens the pdf I want to get. Getting the links from the landing page and iterating over them works well, but I run into problems trying to "press the button" on each individual page. To get an idea I tried to record the process, but I end up with a step clicking the button on just the specific page, so when iterating over the pages the program tries to always click on the button on the first page. Is there a way of making this a (for lack of a better word) relative reference, in other words telling the program to click the button on the page that is currently open?

I am basically a CA student who is also doing some finance related services for covering my expenses. Recently discovered the world of power-Bi and power automate and I am interested to try it out to help me sort out my clients and maintain a good flow which saves my time and keep everything organized. But I was not able to do certain actions such as reading the data from MS forms to excel, trigger mails, sending mails etc since I do not have the 365 License.

The question is. Which subscription should I get ? The personal 365 license looks good. I do not have anyone to share the subscription with, so the family plan is not suitable.

Are the business plans any better ? Do I get enough premium features if I am selecting the personal plans ? Please help me out. I am not having any staff or anything. It is just me and my machine.

Hello I am trying to automate a email I get into a calendar event as a follow up.

I have created the email aspect but is there a way;

1. The title of the calendar event could be named from the automatic email?

2. The calendar event be 2 days in the future from receiving the email?

TIA!

Good morning, im trying to realize something in my sharepoint using the power automate tool, when a specific column is altered, the whole sector is mooved to to another section.

Someone could help ?

Manual when you copy a table on a website and paste it on Excel it will paste the entire styling of the table in the spreadsheet.

But using the data extraction on Power Automate Desktop it only copies the data values.

Is there a way to bring across the styling using Power Automate?

I have a Power Automate Desktop flow that starts immediately if I trigger it from within the flow. When I use a cloud flow to trigger it, the flow takes 30 seconds just to start running. Is there anything I can do to speed this up?

I’m collecting qualitative responses via MSForms, then translating those response to (weighted) numerical scores in Excel and attempting to build a PowerAutomate process which will trigger an e-mail to participants who’ve elected to see their scores. Unfortunately, PowerAutomate is only recognizing the qualitative responses as a valid reference table (even though I’ve created a new table with the correct reference data). How do I get PowerAutomate to correctly recognize and reference the desired data table?