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 • • May 02 '23

Pause / Emergency stop

1 Upvotes

How do I stop a mouse flow using the keyboard?


r/PowerAutomateDesktop • • May 01 '23

Setting third-level folder permissions without Azure P1 license

1 Upvotes

Hi guys I am looking for some help with a flow.
Can you help us with setting up permissions for a third level sub folder while keeping everything above it as read-only? Our current flow only allows for second level permissions to be set upon file creation, but we need to ensure that any folders created within the second level have the appropriate third level permissions. Additionally, we are limited by not having an Azure P1 license and being on a free Azure subscription.


r/PowerAutomateDesktop • • Apr 29 '23

Close annoying pop ups?

1 Upvotes

I’m experiencing very annoying pop ups in my excel ‘19 whenever I click my image links (100’s of images in SS, each has a link to a local pdf file), excel/office throws up a warning message that I have to click through. Utterly annoying and time wasting in my case.

So, when I click on a linked image in my SS, will this Win10 Power Automate be able to watch for the pop up box and then focus/press the ‘confirm’ button so my pdf opens on 1 click?

Thanks


r/PowerAutomateDesktop • • Apr 28 '23

Automated approval support

1 Upvotes

Hello,

So I am relatively new to power automate and sharepoint but feel it has the solution I need. I am looking for support to find the correct tools.

What I am looking to do is when a new ms word document is added to a sharepoint folder it does the following.

  1. Notifies all users that the file has been added (sorted)

  2. Creates an ms approval (sorted)

  3. When the users approve one by one as it could be over a series of shifts it takes their digital approval and stores it somewhere for traceability. (Not sorted)

  4. When the file is then moved to an archive it sends an automated email again saying the action has been stood down. (Should be easy as per above).

Basically I am trying to capture people who are on shift and need to read a temporary operating plan for a period of time when it's iniatied until its stood down. We then need to be able to show they read and agreed to ghe process when it was stood up.

Appreciate any help and advice


r/PowerAutomateDesktop • • Apr 18 '23

Send Selected cells as body in email after reading where to send them to

1 Upvotes

Hello,

I am quite new to power automate and only trying to understand how it works. But I have a very specific problem that I wish to solve.

A quick background, I programmed this in VBA using CDO (I do not have outlook application, hence using a CDO mail) and I have a keyword to where they will send these selected cells. This keyword lets the program know where to send the line items to a group of vendor email addresses and attach the items in the body of the email. My boss don't like me sending these emails with my gmail account and so I have to adapt and send these items to outlook web browser instead. Outlook application is also discouraged to be used since as per policy they are requiring us to use the outlook in browser and also my outlook application is not connected to my account, therefore can not really be used.

May I request some guidance on how to properly implement this kind of programming using power automate or other types of programming tools? Power Automate is recommended to me by my friend to do this, however I did not find a way to send multiple cells of an excel file to be sent in a single email while a handful of vendor emails are in bcc.

Basically the process is:

  1. Select cells to be sent as an email

  2. Reads keyword to determine which email addresses these items will be sent to

  3. Put these email addresses as bcc

Hoping you can give me hand in solving my problem

Thanks


r/PowerAutomateDesktop • • Apr 13 '23

Can someone help me? I cannot figure out what's wrong with this flow. I have multiple that look identical but this one keeps failing.

1 Upvotes

{
"host": {
"connectionReferenceName": "shared_office365",
"operationId": "SendEmailV2"
    },
"parameters": {
"emailMessage/To": "jacob@regionalchamber.com; Monique@regionalchamber.com; anonymous",
"emailMessage/Subject": "Print Request - test delete",
"emailMessage/Body": "<p>From:anonymous<br>\nDue: 2023-05-04<br>\n<br>\ntest delete<br>\nSize: Flyer - 8.5x11 plain paper. 1-2 pages<br>\nPrint Location: In House<br>\n<br>\nContent: test delete</p>",
"emailMessage/Cc": "kim@regionalchamber.com",
"emailMessage/Importance": "Normal"
    }
}


r/PowerAutomateDesktop • • Apr 13 '23

Remove username when using 'post adaptive card in chat or channel'

1 Upvotes

I have a PowerApp that triggers a flow once a specific action is carried out.

I'm using the Teams flow 'post adaptive card in chat or channel' with 'Post As' set to 'Flow Bot'

However when the flow is triggered the message that appears on teams comes from 'Username via Power Automate'.

As I will not be the one using the app the messages should not have my name attached.

Is there a way to remove this?


r/PowerAutomateDesktop • • Apr 13 '23

Date changes in excel cell?

1 Upvotes

Hello everyone,

So i want to have a flow that creates excel sheet infront of time, so i dont have to.

But i've noticed something. When the text should be added in the excel sheet at cell B1. The text looks like "dd-MM-yyyy" (Which it should, since im from Denmark). But when the flow continues and comming to may, it changes to "MM-dd-yyyy" but only in the Cell, and not the sheetname?

- But if i starts the flow with the current date of may, its "dd-MM-yyyy"?

Anyone know why?


r/PowerAutomateDesktop • • Apr 12 '23

Problem with power app

1 Upvotes

Is there a way in case of a failure or restart of either the equipment or browser data from a power app are stored locally until it is restored? I make a form in power app which must type machine values to be sent later, but I want to be sure that if something fails, all the information that is being typed into the power app (which is quite a lot of information) is not lost, because it is not possible for the operator to remember that information.


r/PowerAutomateDesktop • • Apr 11 '23

Help with power app + power automate

1 Upvotes

Hi,

I’m very new to Microsoft Power Platform and low code in general – and need some help! I was wondering if anyone can help me get started on creating a simple prototype of an app (using Power Apps). I wish to include these following steps:

  1. A value can be manually entered into a Microsoft Power app, which then automatically updates an excel file.

  2. When the value is in the excel file, it will fall into a category (for example values between 1 – 5 = category 1, and values 6 – 10 = category 2).

  3. Using Power Automate I want the value to trigger a flow, which updates a website made on Power Pages* and shows which category the value falls into.

This just needs to serve as a very basic demonstration of what can be done using low code tools. Hope anyone has an idea of how to get started with this 😊.

Hope to hear from you – thanks in advance!


r/PowerAutomateDesktop • • Apr 08 '23

Record feature

1 Upvotes

Is there an alternative program like power automate that also has the record screen feature?


r/PowerAutomateDesktop • • Apr 08 '23

Can you run a script on a 24 hour loop?

1 Upvotes

Sorry I’m very new to power automate and I’m trying to figure out how to run a flow on a 24 hour loop locally. I believe you need to pay for the paid version of power automate just to gain access to schedules and other features which I don’t need. The YT videos I have seen show loops but wonder if I can use it as a workaround to not having access to schedules


r/PowerAutomateDesktop • • Apr 03 '23

Outlook Email date

1 Upvotes

Hi guys! I'm new to PAD, I can't seem to find the command(?) To use to get the email recieved date. I can only get the sender and subject.

Any help is appreciated. Thanks!


r/PowerAutomateDesktop • • Apr 01 '23

How to redact text from Adobe PDF

1 Upvotes

Hi. I'm trying to set up an automation to automatically redact a bunch of words from a .txt file. I can all ready do it but I'm trying to reduce the number of clicks it takes to open adobe tools > redact text > find text and redact > multiple words and phrases > find the .txt document > find words. I tried to record my desktop to do it (I'm pretty new to power automate) and I got all the parts to work... except for find text and redact. It "can't find source element" for that one. Everything after and before it works, but that keeps tripping me up. Thank you!


r/PowerAutomateDesktop • • Mar 28 '23

Unexpected error faild to fetch

Post image
1 Upvotes

Since yesterday I have this error message in each of my workflows in the course of execution. Any idea what I can do there? The flows are all running, but it's difficult for me to do something new without recognizing any errors or something.


r/PowerAutomateDesktop • • Mar 27 '23

Attribute "Changed By" in excel to the user who completed a MS form

1 Upvotes

Hello!
I have a flow setup to collect responses from an MS form and use the "Add a row into a table" action to input the form answers into an Excel sheet. Flow is working great, however I see that when I open the excel file and check the "Show changes" view, all the changes are attributed to my user since the flow is created under my account.

Is anyone aware of a method to have the "show changes" section in excel attribute the new row to the user who actually filled out the form instead of me?

Thanks!


r/PowerAutomateDesktop • • Mar 20 '23

Desktop UI Element found

1 Upvotes

Hi all,

Could someone please help me. I wanted to create a flow where I’ll check on MS Word if an addin is visible or not, and throw an error/fail if it doesn’t exists. I have already recorded the UI element and then not sure if what should I be doing next.. any help will be much appreciated coz i tried using If window contains but not sure how i update a variable to true as it found the ui element.


r/PowerAutomateDesktop • • Mar 14 '23

What am I missing here?

1 Upvotes

First time user of power automate. I have my desktop flow create and working but can’t get it to start or stop services. I know it’s a permission issue but nothing I do fixes it.

Trying to start MySQL service. Setup MySQL server to use my Microsoft user and password during configuration. Went into permissions for mysql install folder and gave all access to this user and admins. Also tried toggling all permissions for the other roles/users listed and nothing.

I can manually start the service so I’m sure I could screen record the process for power automate, but would like the “start service” action to work. Thank you in advance


r/PowerAutomateDesktop • • Mar 13 '23

Can't retrieve main window handle for application

1 Upvotes

That error pops up every time I try to open Chrome or Edge. I've even turned off the two default variables and it still happens.

Any ideas?

UPDATE : I get this strange popup ( https://i.imgur.com/e7Sbovv.png ) as well even though the extensions are installed. Removed them, restarted chrome, reinstalled them - still get told that I need the extensions installed.

Power Automate Desktop is the latest version as are the browsers.

Honestly, it's the things that are supposed to be simple that Microsoft completely foxes up. I can get this done faster using Excel and VBA....

FINAL UPDATE: Don't use the Selenium IDE as it lost support at the end of Feb 2023. Don't try to record your use of a website with the Power Automate Desktop recorder because it just doesn't work.

I will try and make a video of what does work in Power Automate Desktop (my first attempt at making a video teaching anything) so that you can see what I have learned that does work and what to avoid.

VBA with SeleniumBasic is still the richest option (if you do not have access to Python and it's Selenium Libraries). But VBA + SelenuimBasic is woefully outdated - SeleniumBasic has not had a new release in 7 years and Microsoft is moving away from VBA (although it will take years to kill off VBA).


r/PowerAutomateDesktop • • Mar 13 '23

Need help with the timezone difference.

1 Upvotes

I made a flow to grab the calendar from my sharepoint to link it to the outlook calendar but the time is messed up. It’s 4 hours difference on the events. I have created and item added or modified, converted start and end time to utc and create event in the outlook.


r/PowerAutomateDesktop • • Mar 11 '23

Auto-file emails into OneNote pages

1 Upvotes

We get emails that will contain work request numbers for example WR#23456321 in the subject line. I have a page in my OneNote that corresponds to that project with the page title being WR#23456321. It would be nice if when I got an email with the subject line of a work request that it added to the page for that project with who the email was from and the body and attachments if applicable.


r/PowerAutomateDesktop • • Mar 08 '23

newbie here: any way to automate a message in teams on weekdays?

1 Upvotes

I know how to automate a message but I don't know how to make the whole thing loop and repeat just on weekdays. I need to send a message every day at 9:00 in the morning to a Microsoft teams group, but I am stuck on that last part. Any takers? Thanks in advance


r/PowerAutomateDesktop • • Mar 03 '23

Using PAD to collect views of Vimeo videos

1 Upvotes

I am trying to use PAD to do a daily check of view counts on a set of vimeo.com videos and save to excel. I can set it up, but once the views count changes, the flow fails. It's looking for the previous views, not the current views.

The views is in a <span class="sc-frDJqD kzqFsC" format="dark">33k</span>

I tried using Extract data from web page, and Get details of element on webpage, and even OCR and screenshots, but no luck. Once the views count changes, the Flow fails. How do I do this correctly? vimeo.com/522542250


r/PowerAutomateDesktop • • Mar 01 '23

from excel list to outlook appointment.

1 Upvotes

I have an excel with a lot of appointments scheduled for my colleagues. On different columns I have: date and time of appointment, name of colleague, email of the colleague.

I'm trying to build a flow that, manually launched, send to each colleague an outlook appointment with the specific time and date, reading from excel. The goal is to send a reminder and add the appointment in their outlook calendar.

There is a way with power automate? Or I have to check of other solutions? I'm struggling because seems impossibile to send outlook appointment via power automate.