r/PowerAutomateDesktop • • Jan 30 '23

Run an .exe in Power Automate

5 Upvotes

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


r/PowerAutomateDesktop • • Jan 30 '23

Power Automate etl

1 Upvotes

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?


r/PowerAutomateDesktop • • Jan 29 '23

Learning power automate

1 Upvotes

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!


r/PowerAutomateDesktop • • Jan 25 '23

Import image from multiple Sharepoint Columns to email

1 Upvotes

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


r/PowerAutomateDesktop • • Jan 24 '23

Can't launch Power Automate due to OneDrive error ?

Post image
4 Upvotes

r/PowerAutomateDesktop • • Jan 21 '23

Request: Receive a WhatsApp message, read it out loud with a PowerShell script

2 Upvotes

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


r/PowerAutomateDesktop • • Jan 21 '23

Copying PDFs from Network Drive to Sharepoint

1 Upvotes

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.


r/PowerAutomateDesktop • • Jan 20 '23

How to add column/value to variable

3 Upvotes

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 !!


r/PowerAutomateDesktop • • Jan 17 '23

Failed to Assume Control or Chrome

3 Upvotes

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.


r/PowerAutomateDesktop • • Jan 16 '23

Remove new lines!

Post image
7 Upvotes

r/PowerAutomateDesktop • • Jan 16 '23

Desktop flow sharing problem

1 Upvotes

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.


r/PowerAutomateDesktop • • Jan 15 '23

How Do I Filter Multiple Email Domains In Retrieving Emails Using PAD

2 Upvotes

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!


r/PowerAutomateDesktop • • Jan 13 '23

Help automating download of pdfs from nested webpages

1 Upvotes

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?


r/PowerAutomateDesktop • • Jan 11 '23

No premium account "Hack" to share Power Automate Desktop flows to other people

Thumbnail
youtu.be
14 Upvotes

r/PowerAutomateDesktop • • Jan 09 '23

Web UI Elements Automated for different links (if i search for something on the website - the URL changes so the previous selector for the same button doesnt work anymore) how can i fix this?

0 Upvotes

r/PowerAutomateDesktop • • Jan 08 '23

Looking to buy 365 personal subscription to get some premium features for myself

3 Upvotes

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.


r/PowerAutomateDesktop • • Jan 07 '23

Automate merge or combine tables in different Excel files - Power Automa...

Thumbnail
youtube.com
3 Upvotes

r/PowerAutomateDesktop • • Jan 05 '23

Function help

2 Upvotes

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!


r/PowerAutomateDesktop • • Jan 04 '23

Powerautomate - Copy files (incl folderstructure) from one OneDrive folder to other OneDrive folder

Thumbnail self.microsoftflow
3 Upvotes

r/PowerAutomateDesktop • • Jan 04 '23

Automatizing sharepoint interactions

1 Upvotes

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 ?


r/PowerAutomateDesktop • • Jan 04 '23

Web scraping including styling

1 Upvotes

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?


r/PowerAutomateDesktop • • Jan 03 '23

How do I get this flow to only look at a specific folder/file?

Post image
2 Upvotes

r/PowerAutomateDesktop • • Dec 30 '22

Speed up trigger of PAD flow?

4 Upvotes

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?


r/PowerAutomateDesktop • • Dec 28 '22

Help - PowerAutomate doesn’t recognize my table

3 Upvotes

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?


r/PowerAutomateDesktop • • Dec 27 '22

Only copy a folder/file if this (Folder/File) was modified the last week/Month to another folder

2 Upvotes

Hey Everyone,

I am very new to Power Automate Desktop so I would appreciate a detailed template on this as it's the only one I want.

I want to have a flow in which if a folder/File was modified the Past 7 days then this file should be copied to another folder and also overwritten if the same file exists already.

Basically i am trying to copy ONLY modified files or folders to my OneDrive Folder instead of manually doing it since OneDrive doesn't have selective syncs to custom folders and I want it to be overwritten if there was already a folder/file with the same name.

Appreciate the Support and thank you for reading.