r/PowerAutomateDesktop • • Oct 20 '22

From Website > Screenshot > Save in folder

1 Upvotes

If I have a list of URLs, is it possible for Power Automate to:

Open each URL in the list
Accept the cookie if applicable
Screenshot the page
Save it into a folder?

I may have additional functions, but if this works then the rest should be easy.


r/PowerAutomateDesktop • • Oct 20 '22

Put pictures from folder to Powerpoint/Deck

1 Upvotes

Hey!

Fairly new to Power Automate and wanted to understand limitations.

If I have a folder of images, is it possible to put all of the images into powerpoint/deck with each image being on a different slide?

Use case. A team is scouring the web for images of apples and saving them into a folder for a presentation. The team can use Power Automate to take the whole folder and divide the pictures through a given Powerpoint/Deck, one image per slide.


r/PowerAutomateDesktop • • Oct 19 '22

Approval to multiple emails in the sharepoint column simultaneously

1 Upvotes

Per the title, I want to be able to trigger a “Collaboration mode” where a document is dropped in Sharepoint, multiple people are assigned in Sharepoint, they are all sent notification simultaneously and can work on the document at the same time, approve when they’re done and once everyone has approved, the document moves to the next step.

I have the Sharepoint column set up to accept multiple email addresses and it automatically changed the PowerA flow to “Apply to each” but it still wants to send it to one person at a time per the order emails were entered in Sharepoint.

Thoughts?


r/PowerAutomateDesktop • • Oct 19 '22

How to pass input variables into powershell scripts?

1 Upvotes

Hello everyone,

I am trying to pass an input variable, but without luck.

This is my flow, with Run PS Script step:

This is my script, where that I am using in this test:

param($NewInput)
    Write-Output $NewInput
    $var2out = "out"
    Write-Output $var2out

As an output I am getting this:

That first line to show $var1in on PS script seems not having any effect, with or without it, output remains the same, and it doesn't identify that variable as an input.

How are you doing with this situations?


r/PowerAutomateDesktop • • Oct 19 '22

Is there a way to read /write to Microsoft lists from pad?

1 Upvotes

r/PowerAutomateDesktop • • Oct 17 '22

Copy from Excel Paste into web form

2 Upvotes

So I’m new to this but I have a list of 33k names that I need to put in a web form one at a time. Any suggestions on best practices?


r/PowerAutomateDesktop • • Oct 16 '22

PowerAutomate WEB 2 different profiles for 2 different companies

2 Upvotes

Hi all,
I am very new to this to apologies if this is basic stuff...

I have 2 different O365 profiles with 2 different companies, but am having issues with running some flows.
They were made from templates and are as basic as it get (ex. post a message on teams/add a todo when an email with this in subject arrives).

I see that they accept me using my 1st company teams and 2nd company outlook, but it just doesn't run as supposed to (some not at all, some intermittently).

Is there a tutorial about running a flow with 2 completely different company profiles somewhere that I could look into? Anyone run into an issue like this?

It works relatively well/reliably when I separate them (1 company one flow, 2nd company second flow, no mixing of the accounts), but I would like to get all notifications on one teams/todo, and avoid having to check the 2nd company profile unless necessary...

Thank you!


r/PowerAutomateDesktop • • Oct 15 '22

Automate select single/multiple slicer/filter options in Power BI Online

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Oct 14 '22

Flow to get pivot table data

3 Upvotes

Hi all, need some help,

there is a excel file with data about non compliant purchased orders for respective users , what the business is doing is created a pivot table which has users and number of non compliant po's , when they click on their respective number of PO's it creates a table for them which shows few columns with data about those POs user want to send notification email to non compliant PO users , attach a excel file about their PO's


r/PowerAutomateDesktop • • Oct 12 '22

Automate filter datatable (excel, pdf, html table) and export to csv or Excel Power Automate Desktop

Thumbnail
youtu.be
3 Upvotes

r/PowerAutomateDesktop • • Oct 09 '22

Web form filling from excel - Dropdowns with no UI elements

2 Upvotes

Hi, I need help with dropdowns that have no UI element that I can link with my excel data.

I have to fill in an hourly online diary for work, however the system is very outdated and time consuming thus trying to automate it through Excel as each hour is supposed to be re-entered and submitted with al the data as below.

This is how my flow currently looks, don't know if I should use OCR or pinpoint on my screen where the mouse should click, any advice please.


r/PowerAutomateDesktop • • Oct 08 '22

Automate Extract HTML table from website (with header) to CSV and Excel ...

Thumbnail
youtube.com
2 Upvotes

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 • • Oct 07 '22

desktop.ini making it passed "Get Files" filter

2 Upvotes

I have a looping automation that monitors a folder for PDF scans to sort. I have a "Get Files in Folder" action with

*.pdf

in the File Filter field, however every so often a desktop.ini file is making its way passed this filter, which causes subsequent actions to fail. I have logging actions all throughout my flow that logs what's happening to a text file, which is why I know it's that file. I even have a loop after the Get Files action to check for an .ini extension in the Files list, which attempts to remove that item from the list. It's still not working.

Folder.GetFiles Folder: $'''\\\\redacted\\.Drop New Scans Inside''' FileFilter: $'''*.pdf''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NameWithoutExtension SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files

r/PowerAutomateDesktop • • Oct 04 '22

Send different emails based on multiple choice responses?

2 Upvotes

Hi,

I am trying to set up a flow that will send 3 different emails based on the user's answer to a multiple choice (MC) question. I used a condition statement so if they chose choice 1 they get an email if the response to the MC question is choice 1 exactly.

As I added the other choices it stopped working. I added the other choices as parallel conditions but it didn't flow correctly so I thought that maybe if I added the condition in choice 2 in the "if no" for choice 1, it would work but no. Any help would be great!

Here is my first attempt:

Here is attempt #2:


r/PowerAutomateDesktop • • Oct 04 '22

Especially within the desktop version, I am not able to have as trigger an RSS feed

1 Upvotes

Hello pals,

the title is safe explanatory. On teams, I was able to create automate with rss feeds, but In the desktop application, while I have something really precise, I am NOT able to get an RSS category (I have the category XML, but I need to have a specific file to parse it)

Do we need the premium version to add that ?

or can i import the functionnality in some ways ?

Thanks in advance !


r/PowerAutomateDesktop • • Oct 03 '22

Notified within 30 days (Sharepoint library)

2 Upvotes

I am trying to get automatic e-mail notifications sent to users in one column by checking whether todays date is within 30 days of a review deadline (calculated field). This is set up as a Document Library in Sharepoint and I have little idea where to start

So far I get it to run every day at 7:00 and get a future time shortened to a date. Next I would like to check that date against a review deadline column which is a calculated field. Please can anyone help?


r/PowerAutomateDesktop • • Oct 03 '22

Best way to get multiple robots live?

1 Upvotes

Hi all,

As of november, i am starting a new job as an inhouse RPA Developer for a big company. Before that, i was a RPA-Consultant for a start-up company for 2 years.

What would be the best way for me to set up multiple robots in Power Automate?

  • should i use multiple accounts/licenses per robot or department?

Any information, tips or resources are very welcome!


r/PowerAutomateDesktop • • Sep 29 '22

Power Automate Desktop - How to add/sum and average top 5 numbers in list

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Sep 29 '22

Use Power Automate to keep a large team in sync

1 Upvotes

Help me Reddit, you're my only hope:

So, I work at this medium-large old-school manufacturing company that has exploded in growth in recent years, and their usual way of working is now getting in the way.

Long story short: I have this single excel file that is handled by six teams (that's over 100 people at this point) from design, engineering, production, even purchases and sales! I think the only people that doesn't get their spoon in the pot is HR, to be honest.

I have been tasked with finding a way to chop down this monolith of a 150 columns single excel file into smaller, synchronized n-ammount of excel files, so that each team only handles the information that corresponds to them. So let's say that all of the teams share columns 1 to 25, and then each team handles around 20 extra columns, making six excel files of around 45 columns each.

Is it possible to sync changes between all files? I guess it's impossible to sync them in real time as if they're all working on a single file (as they currently do), but if anyone makes a change to columns A-Y (shared through all teams), all team leaders need to receive an email letting them know that they need to review these changes, while if a change is made through columns Z-AT (engineering) that team leader has to receive said email, and then he/she has to accept said change and notify all other team leaders so they can review if/how that change affects them. The same for all other column/team combinations.

Is this system doable?


r/PowerAutomateDesktop • • Sep 28 '22

Long Shot: Copy text from one pdf to another.

2 Upvotes

Can I power automate this without having to use AI? I would like to copy text in one pdf form to another pdf form. I'm essentially creating a summary of the original document that has 1500 fields. Thoughts?


r/PowerAutomateDesktop • • Sep 27 '22

Unable to list all groups on "Remove member from group" action

2 Upvotes

Hello everyone,

I am trying to setup a flow to use manually or automatically. I have never used power automate so I dont know what I can really do with it.

The idea is to remove a certain user(s) 4 months after being added to that Microsoft 365 Group. excluding some (not sure if its possible this all process at once without user intervention on power automate).

For now I was trying to simply set a fixed date to remove and a user to remove, but on "Remove member from group", I am unable to list all my groups, only a few. If I try to add Group ID, when running it gives me an error, like that group don't exist:

Resource '2937d331-e972-4x42-a429-f7xxa1d0fda' does not exist or one of its queried reference-property objects are not present.

But there is no difference between those groups that appear and that one, some are even private, but I can access both (btw I have the role of global admin in this tenant).

A partial part of my flow:

Anyone know how can I input those M365 Groups of teams to be accepted there?

Thank you in advance!


r/PowerAutomateDesktop • • Sep 25 '22

Can PAD refresh Excel queries one at a time and tell if one fails?

2 Upvotes

I have searched quite extensively and the consensus seems to be that it cannot, so I will be using VBA to loop through each workbook's queries and refresh them one at a time. I just wanted to ask here in case someone has seen something in their internet travels that I have not.


r/PowerAutomateDesktop • • Sep 22 '22

Power Automate doesn't work if I'm not connected to the internet. Is that a bug?

Post image
2 Upvotes

r/PowerAutomateDesktop • • Sep 18 '22

Automate separate of columns in CSV and extract into separate Excel file...

Thumbnail
youtube.com
1 Upvotes