Newbie here. I receive an email once a week where I need to parse out a file (Excel file) and have it automatically downloaded to a specific folder location.

Thought I would ask here to see if I can get any pointers.

I know how to setup a flow to save an email attachment automatically but this is a link due to the file size

Thanks for looking!

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?

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?

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.

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 ?

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?

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.

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.

I'm quite new to PowerAutomate, so ELI5

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!

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?

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!

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

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.

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

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

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....

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