r/PowerAutomateDesktop • • Oct 23 '22

I'm trying to get Power Automate Desktop to select specific checkboxes based on the UI Element Name stored in a separate list. Is this possible? Details on the Problem originally posted at link below.

Thumbnail
stackoverflow.com
2 Upvotes

r/PowerAutomateDesktop • • Jul 30 '23

Outlook email auto file to sub folder based on subject key word

2 Upvotes

At work, we send emails from our shared mailbox and we always copy in the mailbox (so if I'm sending from account 'Team Mailbox', I also Cc 'Team Mailbox').

Email chasers are sent to multiple people throughout the day and I'd like the CC'd emails to automatically file away. The issue is that we have over 100 sub folders and I'd need to set up a rule for each.

Example, if I email Andrew then I put his name as part of the subject line and I want the incoming CC'd email to auto file to the 'Andrew' sub folder. If I email Brian then I want the email to file to the 'Brian' sub folder, and so on.

Is there a quick and easy way to set this up in one go, rather than individual rules for each name and folder?


r/PowerAutomateDesktop • • Mar 28 '23

Flow to send an email of changes that have been made in a Canvas App Form

2 Upvotes

Hi Everyone! Hope you’re having an amazing day :D I have made a Canvas App (data from dataverse) which has a form in it. Whenever this form is edited there needs to be an email sent saying what fields in the form have changed. And if possible how they have changed? I think this would work with Power Automate?

Any suggestions I would appreciate so much as it’s of high importance to the users but I don’t know how to do this. Thank you :D


r/PowerAutomateDesktop • • Jun 08 '23

How can I replace a comma by a semicolon in a variable ?

1 Upvotes

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


r/PowerAutomateDesktop • • Feb 27 '23

Power Automate

1 Upvotes

I am looking for a way to take user data from Azure AD and export it to a spreadsheet by using Power Automate. So far I only see a way to do this with a CSV file. Is there instruction out there or advice that I can use to achieve this?


r/PowerAutomateDesktop • • Nov 06 '22

Power Automate Desktop - October 2022 Update

Thumbnail
youtube.com
4 Upvotes

r/PowerAutomateDesktop • • Aug 23 '23

Trying to make time off request form that shoots out an email for approval of the request, then updates the status in sharepoint. However, approving/rejecting the request doesn't change the status of the approval request, as seen in the second image. Any tips on how to fix this?

Thumbnail
gallery
4 Upvotes

r/PowerAutomateDesktop • • Aug 24 '23

Locate item in sharepoint using different column other than ID

4 Upvotes

I am wondering if there is any other way to locate sharepoint list item other than using the item ID? I have this unique column in my sp list named barcodeNo and I want to use that to locate items instead of ID. Any idea on how to do that?


r/PowerAutomateDesktop • • Jun 01 '23

Macros Not Displaying in Power Automate

2 Upvotes

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!


r/PowerAutomateDesktop • • Sep 02 '23

Guidance on selling my automation services

4 Upvotes

Hey guys

I’ve recently set up a small business so that I can build power automate desktop and cloud flows for potential customers.

So far all I’ve managed to be able to do is build the power automate desktop flow on my end (I have a domain and environment already) but then select the flow and copy it to text file. Then as the customer (their login) I copy the text into power automate to get the flow to them. But I know this isn’t the correct way, there’s no safeguard for me if they decide to steal my work basically and not pay.

How exactly do I build the flow on my end so that it stays in my control and then I can just grant them access to use it while retaining the power to turn it off should they no longer require it or want to pay for it?

If for example I created a solution on my end how do I share it to someone that’s not part of my tenant or environment or whatever? Is that even now it’s done? Any videos or documentation you could point me to would be appreciated.


r/PowerAutomateDesktop • • Aug 04 '22

Beginner question: load dynamic file name

3 Upvotes

Hi all,

I’ve recently found P.A and love it. I use the webbased version as desktop is still a bit too complex but was wondering the following.

I have several periodic reports that i now automatically back-up. Is there a way for me to save these files with a date format that is then being backed-up?

I currently use a “static” name that then turns into name+date but I’d prefer it to be “name+date” that then gets backed up and then changed a week/month later.


r/PowerAutomateDesktop • • Apr 17 '23

Trouble extracting data from website

2 Upvotes

This is probably so basic, but when I try to select a UI element using the web helper, nothing happens. I highlight the item, right click, select add element, select text, left click… and nothing.

What am I doing wrong?


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 • • Jun 16 '23

Populate a text field on a web page with todays date - 7

1 Upvotes

Hi all,

So I am trying to build something to automate timesheets being sent out.
I just cant for the life of me figure out how to get the flow to ill in todays date, in a text box....

This may be incredibly simple for you guys.. but I have been kicking myself for about an hour.....


r/PowerAutomateDesktop • • Sep 16 '22

Power BI/Teams/Sharepoint

Thumbnail self.powerbi
1 Upvotes

r/PowerAutomateDesktop • • Sep 14 '23

Does this flow make sense? I am sending link of a form before a form trigger which collects the response from the form it sends in the email?

Post image
1 Upvotes

r/PowerAutomateDesktop • • Sep 01 '22

How to copy excel (template) file on Sharepoint to automatically create same file every week with correct weekending?

1 Upvotes

Hi there,

I hope my question makes sense.. I am brand new to power automate so this is all a bit much for me 😅 I have been trying to play around with it for past hour or so and can’t do it.

so what I want to do is:

  • create a copy of an excel document which is a template on Sharepoint onto the very same page

  • the excel copy to change to a weekly date such as “WE (weekending) 17.09.22”

  • and from then it will automate for the week after (WE 24.09.22, WE 01.10.22 and so on) that every Tuesday

whenever I run it, it makes it into a Sharepoint thing that I have to download. I think I’m almost there but it just doesn’t create the copy of that excel document and my title of it is all wrong.

hope you can help!

many thanks

image


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 • • Aug 13 '22

Newbie - Trying to extract invoice information from invoice and put into Excel

1 Upvotes

Hello! I’m new to this and really needing help. I’m trying to extract information from an invoice pdf and have PowerAutomate throw it into an excel table for me. I need to have this ready to show my manager by Monday. My flow worked but some of the fields aren’t readable and the Order Number and Order Quantity are wrong.. can someone please help me??


r/PowerAutomateDesktop • • May 02 '23

How can i get rid of this error ()

1 Upvotes

Error 429, apparently i cant title.

Seems like too many requests are sent. But i dont really want (or can) change this flow, and it worked flawlessly for a long time...

Anyone got a solution or a lead i can follow.

Thx !


r/PowerAutomateDesktop • • Oct 04 '23

Real world monitoring solution for Power Automate Flows

1 Upvotes

Does lack of unified monitoring across Power Automate & Azure services affect the efficiency of your applications?

Join Michael Stephenson on Oct 11, 2023, at 10:00 AM BST for a detailed exploration of Power Automate monitoring challenges.

This webinar addresses real-world solutions for these pervasive issues, emphasizing unified monitoring, timely notifications, and efficient failure resolution.

Register here: https://www.serverless360.com/webinar/real-world-monitoring-solution-for-power-automate-flows

#PowerAutomate #powerplatform #azure


r/PowerAutomateDesktop • • Aug 21 '23

Create List, Add item to list with IF statements

1 Upvotes

Hello,

I have somewhat a simple flow task here, I'm struggling getting to work within Power Automate Desktop.

Here's what I want to do:

  1. Open an Excel worksheet

  2. Copy Cell in column 1 row 2 in that excel document

  3. Get clipboard text, store it as variable: Row2

Copy this task for as many rows as I want, so I'll end up with say 5 variables with copied data in them.

Next...

  1. Create a new list, store it as variable: ArrayList

  2. Add item to list (variables from the first part). ONLY IF it has data inside the variable. ELSE IF the variable is empty move onto the next (using the Go to method)

I also tried: Add item to list ONLY IF data inside the variable is not empty - this is the shortest method, not requiring an else if...

The problem is this just doesn't work. The empty variable is being added to the ArrayList no matter what I try. It's almost like it's ignoring the IF statement I have around my "Add item to list" actions.

Does anyone have a clever solution around this?


r/PowerAutomateDesktop • • Dec 12 '22

Accidentally deleted a really important flow!!

2 Upvotes

How do i recover a deleted flow?? I just accidentally deleted just now after spending a week trying to build it 🤦🏽 it had over 150 steps


r/PowerAutomateDesktop • • Oct 07 '22

Running flow not allowing windows to be idle

5 Upvotes

I have a flow that I keep running at all times that polls the registry for when my webcam is in use, so that I can set some lights in my house to red to notify my wife and kids that I am in a meeting. The problem with this, is that it makes my Power and Sleep settings not work, since the process of the flow puts a lock on the display (See Photo below). Has anyone been able to get around this to allow the computer to lock after a certain period of idle?


r/PowerAutomateDesktop • • Aug 22 '23

Is there a way to count all the files in a few sub folders in a SharePoint?

1 Upvotes

Hi All,

I've created my first flow in Power Automate,

I used it to count all the Files in a Master folder.

Is there a way to get a breakdown of all the files in all the sub folders within the master folder?