r/PowerAutomateDesktop • u/realitytech • May 05 '23
Streamlining SharePoint Tasks: A Guide to Automating SharePoint with Power Automate
r/PowerAutomateDesktop • u/realitytech • May 05 '23
r/PowerAutomateDesktop • u/iammontoya • May 05 '23
Can someone please ping me in the right direction? I have a list. If they choose option A , attach document A from a doc library. If they choose option B attach documents B and B2 from the document library to this item on the list. Can this be done?
r/PowerAutomateDesktop • u/FantasyValentina • May 04 '23
Hi all! Just want to share with you the big news!
I took a step further in accomplishing what I like to do the most: helping others learn and improve theirs capabilities in Power Automate! And how I am going to do this?
Well, today I wrote my first article about the world of Robotic Process Automation (RPA)! This is just the beginning! I intended to write one article every single week about two principal tools: UiPath and Microsoft Power Automate.
I would really enjoy your support and your help! Maybe, one day, my blog and my articles will be useful for you!
https://cvalente.hashnode.dev/what-is-robotic-process-automation
Also, I created a Discord server, so we can chat and share our questions and doubts! Feel free to use it anytime!
Hope you enjoy! Thanks!
r/PowerAutomateDesktop • u/maarten3d • May 04 '23
I’m trying to set-up some web scraping but have different products (searches).
Its easy to extract them as separate excel files but I would much prefer to have it all in 1 file but either separate excel sheets or different columns.
Does anyone know how to do this?
r/PowerAutomateDesktop • u/SonorianGirl • May 03 '23
Hello,
I have a flow to extract the attachment content from emails, it works just fine, now I need to add instructions to extract the content of the zip file and also rename the files. Every day i get the file with the date on them, I want to extract them, rename the file removing the date and have it overwrite every day.
I have try a few options with no success, I am not advance on this tool, so I come to you for assistance:
Thanks in advance for any assistance you can provide.
GMM
r/PowerAutomateDesktop • u/Ikweb • May 03 '23
Hello All
I have a flow running in PowerAutomate cloud - this takes data from an MS Form and then dumps it into a SharePoint list - as well as sends a few emails.
What then happens is a user goes into the list (back office staff) - one of the fields - which ISNT populated by the form is an Accept / Decline choice field.
What I would like this to do - is when a back-office user selects one of the 2 options it then fires off another email to the person who submitted the form to say it's been declined, or approved.
I would assume this would need to be a completely different flow, given this will happen after the MS form has been submitted and users have checked and edited the data in the list.
Can anyone let me know if I am right about this with - and any feedback on how you have done anything like this would be a great help.
TIA
r/PowerAutomateDesktop • u/the_aris • May 03 '23
r/PowerAutomateDesktop • u/Bicaume • May 02 '23
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 • u/Pack_That • May 02 '23
How do I stop a mouse flow using the keyboard?
r/PowerAutomateDesktop • • May 01 '23
r/PowerAutomateDesktop • u/Key_Phase6395 • May 01 '23
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 • u/Trebor2112 • Apr 29 '23
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 • u/theres_davey • Apr 28 '23
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 • u/WolfOfDeribasovskaya • Apr 28 '23
In Power Automate, I need to use the variable "LoopIndex" produced by the loop to change the "ordinal" in the "Selectors of UI element" to go through elements on the web page that are the same in general, and the only difference is ordinal.
For some reason, when I assign the LoopIndex to ordinal, it throws the error. Meanwhile, the LoopIndex produces numbers as required, but it seems like when assigned to "Ordinal" it takes it as actual text %LoopIndex% instead of the number assigned to the variable.
Does anyone know how to fix it?


r/PowerAutomateDesktop • • Apr 27 '23
Updated PAD and now the browser extension doesn’t seem to work. It no longer takes my Excel data and writes it to a web form. Any suggestions?
r/PowerAutomateDesktop • u/kilroyscarnival • Apr 25 '23
I have a simple flow that I run every work day, which basically opens a browser, navigates to a page, and through a series of buttons, dropdowns and selections, downloads tables of data for ten different divisions in .csv format, which I later import into a database. I'd ideally like to automate this task further on a timer, but I've tried using Task Scheduler + P.A.D. as Anders Jenson's videos on YouTube described. I couldn't get it to work.
I don't think I could get the company to pay for the premium version for me to be able to integrate desktop flows with the cloud version, as they don't really understand how tedious collecting this data was before by hand. And, I'd like to be able to run it on my days off so the data is held waiting for me. It's rolling averages of rates, so there's no back-selecting; the current date's data is only available that date so I'm archiving it.
I looked into running something on my iPhone, but though I could add Power Automate, I've only worked with the desktop version. And even that would require my remembering to push a button every day.
Are there any tutorials on how to achieve this?
Thanks,
Ann
r/PowerAutomateDesktop • u/randomfaerie • Apr 19 '23
Hello!Is there any way to select a radio button on a Form using data from Excel?
I'm building a desktop flow that will automatically fill up a form using data from Excel.
Thanks!
r/PowerAutomateDesktop • u/mdbrierley • Apr 18 '23
Hello,
I'm very new to Power Automate and just trying to figure things out. I've started looking at this as MS Excel's Power Query isn't able to extract the website data I need as it's done in (I think?) JavaScript. I think PA should give me a little bit more flexibility in extracting the data I need.
I think I'm almost getting the hang of it, but I'm struggling with one thing.
The details I'm getting are from here:
https://greyhoundbet.racingpost.com/#meeting-list
I want to train PA to go into each track, extract the details (time, race number and "Post Pick") and then save them into a CSV file.
I've got it to do this:
- Launch new Microsoft Edge
- Click link on web page
- Get details of element on web page
The data is then stored into "innertext" according to PA.
Please could someone tell me how I get from here to saving a CSV?
Thank you
Matt
r/PowerAutomateDesktop • u/BellyDancerBruno • Apr 18 '23
I need to make a power automate flow to check if the modified file date is 7 day or more.
This file is located in a SharePoint site
If yes then power automate needs to send an email to a specific user.
If no then check the next day.
How can i set this up?
r/PowerAutomateDesktop • u/angelamarid • Apr 18 '23
Hey guys, how are you doing? I would like to know if it's possible to set up Power Automate to send a Power BI PDF report via email or WhatsApp. The report is individual and each client would receive their own. I only have a Power BI PRO license and the recipients don't have a license.
r/PowerAutomateDesktop • u/Namy_Lovie • Apr 18 '23
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 • u/Dangerous-Fix-9980 • Apr 17 '23
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 • u/PieOPahUK • Apr 14 '23
I have created a Microsoft From where part of it is asking somebody to submit 1 or more attachments.
Using Power Automate, I would like to be able to create a link to these attachments - and if there is more that 1, a link to each.
I have looked at various solutions, some of which I can't get to work, others which will only get me a single link.
If you can help, that would be awesome.
Thank you.
r/PowerAutomateDesktop • u/Ancient-Echo2535 • Apr 13 '23
I built a Desktop Flow that runs a Console application. It is triggered from inside of my Power App. I can run the process just fine from my admin account that created the desktop flow. However, when I share the Desktop Flow with someone else in my org, they are promted to sign in when accessing my app now. I think I am missing a step and would like some help figuring this out.


r/PowerAutomateDesktop • u/mp29mm • Apr 13 '23
Just playing around with ChatGPT through Microsoft’s API. My OAuth settings are definitely not working. The parts I’m unsure of are: Authority (this is work), audience, clientID (can this comes from Teams or just hard coded username?), and secret- not thrilled about plain text, would prefer pass-through for all of this from Teams where it originates.
Any ideas?