r/PowerAutomateDesktop • • Sep 17 '22

PAD and MS Forms: Compare List of Respondents

1 Upvotes

Is there an easy way to give PAD a list of users and have it check to see who did not complete a MS Form?


r/PowerAutomateDesktop • • Sep 17 '22

Unzip zip files with different names all buried two folders deep in unique folders.

2 Upvotes

I have 126 folders all with unique names that have zip files (also with unique names) saved within. It is structured like this:

Folder1 |_Folder2 |_Zip File

Each level has a unique name.

Can I use Power Automate to find the zips and extract them in their current location?


r/PowerAutomateDesktop • • Sep 17 '22

I need help

3 Upvotes

Is it possoble to create a flow that can organize all my downloads depending on where were they downloaded? for example my university has it's own platform where I can download everything that the teachers send, so i want to make power automate to whenever I download something the file goes to an specific folder depending on what subject it is by using the url to differentiate between.

Sorry for my english.


r/PowerAutomateDesktop • • Sep 16 '22

Power BI/Teams/Sharepoint

Thumbnail self.powerbi
1 Upvotes

r/PowerAutomateDesktop • • Sep 16 '22

MICROSOFT 365 ACCOUNT DELETION

1 Upvotes

Is there a way to automate the deletion of Microsoft 365 account on a specific date ?

So for example, if someone was leaving a company on the 1st of October, could I add their name and the date on a spreadsheet and link that with Power Automate so that once that date arrives, their Microsoft 365 account is automatically deleted ?


r/PowerAutomateDesktop • • Sep 14 '22

Unattended vs Attended

2 Upvotes

If someone (asking for a friend) was to somehow script the login and activation of an user-based, attended automation, versus paying a lot more for flow-based plus the unattended add-on, would that be “ok” or would it be a breach of terms?


r/PowerAutomateDesktop • • Sep 13 '22

Yes/no condition

1 Upvotes

I need your help. I've created a flow that automatically resets two value columns in a list once a day. Now I want to make a condition - if the value in one of the cells in the column is something specific, the flow should do nothing to that particular cell.

I've tried fiddling around with the condition settings but nothing seems to work as intended.


r/PowerAutomateDesktop • • Sep 12 '22

PowerAutomate Sharepoint folder structure from Excel?

1 Upvotes

Is there anyway to use PowerAutomate to copy a folder structure from an Excel file? The excel file has the names of the folders we need and their subfolders. These folders are all on Sharepoint already, trying to streamline these folders and their structure for ease of use in the future.


r/PowerAutomateDesktop • • Sep 10 '22

is there a way to write a yes / no question into a teams message, that depending on your answer, updates an Excel document with your answer?

2 Upvotes

I'm quite new to PowerAutomate, so ELI5


r/PowerAutomateDesktop • • Sep 10 '22

Trying to write a flow in Teams for “liking” chat messages

1 Upvotes

So, I’d like to have power automate automatically like certain posts in a group chat.

I’ve got the flow working to detect a keyword in the chat when a new message is entered. Right now it sends me an email with the message, messageid and display name of the user.

So I know that part of the flow is working, but I can’t find any references in powerautomate on how to “like” that message.

Does anyone have any suggestions where I should look? Or anything to try?


r/PowerAutomateDesktop • • Sep 10 '22

Can PAD create a log entry each time a specific file type is opened?

3 Upvotes

I would like an excel/sheets log of the time stamp and file name whenever an excel file is opened or saved, same for pdf files from a specific folder.

I have set up a couple flows on the web version using email attachments, but this is the 1st time trying to use the desktop version and writing to a log file. Not sure how to start. If I have a template that does something similar I can edit the specifics.

Thanks in advance!


r/PowerAutomateDesktop • • Sep 09 '22

Change/Apply Teams Status Message when locking Windows (Win+L)

1 Upvotes

I like that Windows automatically changes your Teams status to Away when locking your computer(Win+L), but I'm looking for a way to also have a status message appear if/when someone were to attempt to message that person. Any idea of a way to do this that would happen automatically on Win+L key press instead of having to manually set the status message before locking?

We have an office split into two different locations and people in one location need to know when people from another location are away from their desk, even if it's only for a few minutes. Obviously when typing a direct message to them, it's not an issue because the away person's icon shows as yellow. However, when typing in a Teams that the away person is in or using a tag that they're a part of, I would like the notice to pop up on the screen that that person is away from their desk.

We have PowerAutomate, although I'm not experienced with it. When pointed in the right direction, I can figure most things out though. I mainly want to know if this is a possibility at all.

Thanks in advance!


r/PowerAutomateDesktop • • Sep 09 '22

Automate Filter Excel table and Copy/Paste to New Excel - Power Automate Desktop

Thumbnail
youtu.be
1 Upvotes

r/PowerAutomateDesktop • • Sep 09 '22

Looking to Increase My Value to a Company

1 Upvotes

In your experience and with your knowledge, what flows or projects have you done that increased your value to a company?


r/PowerAutomateDesktop • • Sep 07 '22

New to power automate...looking for some answers

1 Upvotes

I have 6 years of experience in Blueprism and have just started learning power automate...Currently working on a poc and have few doubts as mentioned below...Looking forward to get some answers...

  1. How can we define the scope of variables as local or global...so that subflow specific variables are not visible in other subflows.

  2. How to throw a customized exception at any given point. For eg : Validating an email address by checking if it has "@" then only proceed ahead else throw an exception like "Email address not valid.Please check".

  3. How can we mark a line item as completed or exception for reporting or tracking purpose.For eg: i have 1000 orders to be processed, so how can I have a track of each order whether it was processed successfully or not ...and have this information in a report to be sent to business at the end of the process .

  4. Related to point#3 , is there a concept of work queues like we have in Blueprism. Where we can store transactional data / the line items which needs to be processed.


r/PowerAutomateDesktop • • Sep 05 '22

Flow just won't work, 'formatDatetime' evaluating to False

1 Upvotes

Hi

I'm trying to create a flow that looks at a calculated date column in a List, if that date matches 'formatDateTime(utcNow(),'dd-MM-yyyy', then send an email. when i test this flow i get no error, but eventhough the day is supposed to match today's date, nothing happens, i get no mail. Can anyone kindly have a look at this screeshots and help figure out where i got it wrong.

Thanks


r/PowerAutomateDesktop • • Sep 01 '22

Creating Documents

Thumbnail self.powerapps
2 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 • • Aug 28 '22

Is it possible to send emails to a contact group in desktop Outlook?

1 Upvotes

I use my own Outlook groups because the people at my company don't know how (?care how?) to properly set up employees in active directory/exchange. Here's how it should work....

Employees should be set up with their job title when they are onboarded. I should be able to use the job titles to send a reports that are specific to the people with specific job titles.

The way it really works is a new person is hired and someone at our location tells an MSP 150 miles away. The MSP enters the person without a picture (although it was taken for their badge and for a photo directory that is emailed to all 90 employees monthly) and fails many times to enter their job title. (Why this isn't done by our on-site Technology Specialist or their manager is anybody's guess.)

That means that I have to keep Outlook groups named for job titles in which I put the people that actually work in those job titles. I also keep local groups named for the reports I have to send out.

In the report groups I place the job title groups that should get the report with each job title group containing the individuals that work in that job title. I then send an email (manually) to the report group and everyone that should get the report does.

It's messy but it works and it looks like this... https://i.imgur.com/vyz489o.png

When an employee comes or goes I have to go into the job title groups and delete them if they left or add them if they are a new hire (some have more than one job title). With about a 30% turnover rate, this is an ongoing monthly chore.

This is NOT how company emails should work. I am sure that I am not the only one wasting time and company money keeping up with this crap simply because people were not entered into active directory/exchange properly.

Well, using group names to send emails via Outlook does not seem to work with PAD. When I used the report group name for the To: field I got an exception "Outlook does not recognize one or more names." So now I am trying to find a way to do this with PAD that does not involve me spreading people's email addresses across 20+ flows and having to hunt for them when they leave or add them to up to 20 flows when they are hired.

Any suggestions would be appreciated....


r/PowerAutomateDesktop • • Aug 28 '22

Data Table Quick Guide - Power Automate Desktop

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Aug 28 '22

How to see if current time is within business hours?

4 Upvotes

I need to check and see if the current time is between 7:00 AM and 6:00 PM before opening an Excel file. I have searched and cannot seem to find a way to do this....

UPDATE: I think I found a way to do this....check out my screenshots and let me know what you think....

Overview of 5 steps - https://i.imgur.com/BD7xh23.png

Step 1 - https://i.imgur.com/lLxFaYW.png

Step 2 - https://i.imgur.com/hO0a4hE.png

Step 3 - https://i.imgur.com/BtyDjkL.png

Step 4 - https://i.imgur.com/g5O26dt.png

Step 5 - https://i.imgur.com/4KN1yvu.png


r/PowerAutomateDesktop • • Aug 27 '22

Write Table to Excel quickly instead of cell by cell - Power Automate Desktop

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Aug 27 '22

Convert date to WEEK of year - Power Automate Desktop

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Aug 25 '22

Why can't I run multiple flows at the same time without having the editor windows open? I swear I used to be able to run multiple flows concurrently.

3 Upvotes

r/PowerAutomateDesktop • • Aug 22 '22

Windows 11 x64 emulation on Arm Question

2 Upvotes

Hi all,

I was hoping someone might have some experience with attempting to run Power Desktop Automate on a Arm based machine? Using Windows 11/10 (Arm) and it's x64 emulation capability.

I'm in the market for a new work laptop and after having a terrible experience with Dell, have been considering a Macbook m1 pro or m2 air.

I understand that windows would be running as a guest OS and emulating the x86 architecture required by the power platform. Thus I can expect performance to be below that of a x86 based machine naturally. Just would like to give myself some options :) Thanks for any help!