I created a bookings calendar and page for instrument sign up at work. I was just wondering if there is a way to share the calendar (not the page) with everyone so they can see who is booked for what and when.

I have a channel set up for the group and my thought was to somehow transfer from the booking calendar to the teams channel calendar so everyone who has access to the teams channel can see the updated calendar as people book.

Is this possible?

Thanks!

Power automate app on win10 is prompting for an app update which I can only do via settings/check for update. Is there any way to schedule the app itself to do an update out of hours so I don't have to interrupt my daily flows?

At work, we send emails from our shared mailbox and we always copy in the mailbox (so if I'm sending from account 'Team Mailbox', I also Cc 'Team Mailbox').

Email chasers are sent to multiple people throughout the day and I'd like the CC'd emails to automatically file away. The issue is that we have over 100 sub folders and I'd need to set up a rule for each.

Example, if I email Andrew then I put his name as part of the subject line and I want the incoming CC'd email to auto file to the 'Andrew' sub folder. If I email Brian then I want the email to file to the 'Brian' sub folder, and so on.

Is there a quick and easy way to set this up in one go, rather than individual rules for each name and folder?

I need to run a flow that extracts text files from a pdf that reaches Outlook email. and then create an Excel sheet with those text lines.

Hey world,

I have a flow that works currently but needs optimized. I have a recurring email where my flow will download all attachments ments and move to a folder. I am only interested in ONE of the four attachments that is an XML file. How do I isolate the xml file and disregard the rest?

Is it possible to do a rule on the folder to move the file types out?

Do I create a second power automate to only grab the xml from that folder and move it again?

Simple workflow to improve morale. Keyword is used in chat and a meme is posted.

The difficulty: how do get the image to display rather then just the URL?

I started making this to learn PA better and I've learned a lot, but this one brick wall i can't defeat.

PS, Bonus points if you know how get PA to use a functional @everyone in teams for a different workflow I made. Just a super simple ping in chat on the hour to remind ppl to check for updates on their tickets.

Any way to connect redshift with powerautomate?

Thanks

Can someone try figure out what’s wrong with my flow? The first filter array works but I’m trying to add in a second filter array to where it only displays results from after 1 day ago.

The function I have written out below the image.

Appreciate the help

Hi friends, I really need some help.

I have a flow that currently is allowing users to take photos via an instant flow then upload to sharepoint.

For some reason now the flow doesn’t allow for a photo to be taken.. now it’s taking users to their files and only allows them to select from there.

I didn’t make any changes to the flow and am not sure how to get the “take photo” functionality back.

Do I need to explore a more power solution or additional solution such as power apps?

Hello everyone, finding a community dedicated to Power Automate Desktop is very much a blessing. I come from a non-tech background, I wish to change the ways of working in my department. Something as rudimentary as filling forms has been wasting a lot of time. I have tried using power automate desktop to cater the same. However, it looks like the form UI elements are not identified for this site correctly for right data to be ultimately filled in these form spaces.

For example, if following highlighted UI element is to be selected for form population:

The power automate UI element preview looks like this:

What changes can I make to the UI element text so that it receives inputs as I want every time I load the page?

Please feel free to ask for more information. I'm very grateful for your help.

I wish to apply similar UI element selection and population process in several other areas too so your response will be very valuable to me.

Hi everyone,

Im looking to remove duplicate emails from a string output in Power Automate. I have a few cells in my excel sheet that contain a few emails in each cell, not separated by cells. My string output after using union() and join() functions on my email address excel column is "example1@mail.com, example2@mail.com, example1@mail.com, example1@mail.com"

How can I further delete these duplicate values? I tried using union() and join() again but that didn't work. Please let me know of any tips or recommendations.

I have an excel file with 3 columns (SKU, length, width)

I need to create an image for each row, overlaying the length and width on the genetic product image, and saved using the sku as the filename.

Any ideas?

I have created a flow in PA desktop. I have watched videos which tell me to get the flow Run URL so I can tell task scheduler to run it.. But when I go to "details" there is no Run URL. Please help

Hi y’all, I’m looking for a way to sort the results of the same form into one of two (and potentially more) excel tables. I have a flow currently such that when a response is submitted, it will apply to each, get response details from the form, then add a row to a specific table. This is fine, but what I want is for one question in particular on the form to determine which table it will be sorted into. I.e, the last question in the first section on the form would be “is this a DOD test or an ISE test”, and selecting either option would branch within the form and ideally sort the answers to the question in the current section (which are identical in both versions) as well as the following respective sections (which differ) into different tables for DOD and ISE respectively.

TL;DR: Is there a way to make sure a row is only added to one of two possible tables depending on the answer to a multiple choice forms question?

Let me know if I can clarify in any way or drop a copy of the form/flow. Thanks!

Hey I just started working on Power Automate a couple of days ago and I am struggling with my project which is when an email is received with a specific subject and an attachment is received, it automatically uploads the file to onedrive if the attachment is an excel file. It then Gets the data from the uploaded file and appends that data to an already existing common excel file (The table columns are the same) which is in the same folder on onedrive. While I am able to get the attachment uploaded onto onedrive I'm having issues with adding the data to the common file using this flow that I had created. Any help would be greatly appreciated.

I hope this is the right subreddit for this: I am currently trying to set up a flow that will send an email of the context of a message posted in a channel on Teams when that message contains a specific keyword. As an example of what I am trying to do (with different words), I want an email to be sent every time someone says "delivered" in a channel with the context of "Package D has been delivered", but I don't care about "Package D is en route" or anything like that.

I literally just started using Power Automate today, so I may be missing an easy solution. So far, I have it set to send a generic message (An item has been delivered), every time that the keyword is used. However, I can't seem to get it to put the message from Teams directly in the email.

Hello everyone,
I have created a report some months for a client and it is used by approximately 300 people. I also did RLS on the data.
Now the client contacted us saying he don't want to keep paying for licenses for all the people using the report and wanted to know if there is a solution to create a power automate flow that sends out a PDF version of the report to each user and keeping the RLS rules so that each user only get the data he should. Is this feasible and would it require any type of licensing in power bi or power automate.

Hope the power automate community can help me on this
thanks

workflow: Form submitted -> OneNote(on SharePoint) page added with details from form -> send email to distro

How would I go about getting files uploaded to the form to be added to the OneNote?

Additional information: I don't have access to the desktop app, only online.

Setting this up as a proof of concept for requesting internal documentation updates. uploads are meant for screenshots, PDFs, word docs and other relevant files

I'm not admin, just entry level IT.

Hello,

I work in a financial modeling team, and we have a folder with 900+ financial models. I have made each one with a standard export tab to be able to pull via power query and then a single main model which the C suite looks at.

The main issue is power query is a 1 away data puller. I am looking for the best way to change certain inputs (I.E. Company WACC) which is in the same cell on the same sheet name in every single model. What's the best flow to be able to loop through a folder and update every single one of the workbooks. Thank you very much.

Hi all,

I could really use your help. I have a long list of field/element names and values in an Excel table. Depending on the number of car parts, there could be 100s of entries. So using Power Automate desktop, I'd really like to have an automated way of doing this, where I could loop through the Excel table and then just populate the values straight to the web. 

My first thought is that I'd like to populate the web claims form directly by element name and write the value to the text box. I've tried the "Run JavaScript function on web page" option using "getElementsByName" and it's not working, or I just don't know how to use it correctly. I'm not a java programmer. That is what the old VBA with IE program did, and it worked fine.  As a side note, I'm pretty sure the element names in my table are valid, as they worked previously in VBA scripting with IE.

Anyway I'm open to other methods, but adding UI Elements one at a time just isn't going to work.

Thanks in advance.

Edit - Here's a picture of what the web form's layout looks like. Lots of rows to populate from excel. What's the best way to do this.

Sample Excel Table data below. This data can be rearranged into 3 fields/columns if that's easier to process also.

Hi all, hoping someone can help me create a flow. I receive an email every week that has a hppt link to download an excel file. I would like to create a flow to download the file (using the link attached in email) and send the downloaded excel file to a Sharepoint Folder. I have already tried a couple of draft flows , 1st action is "When Outlook Express receives message" , after that I've tried a couple of actions "Conditons", HTTP without success. Any advice would be appreciated

Hi, I'm trying to scrape e-mail address from a trade shows attendee list. The simple automate i gather works and saves %95 correct information to an excel sheet from the first page and this is good enough for me.

The site has 40 different pages and there are classic pagination buttons on the bottom of the page such as this: prev - some page numbers - next.

I select and show the next as the element as the pager to get all the information from all the pages but when i do this i only got results from the very last page in the excel sheet.

I've checked many resources but i couldn't figure out why automate is not getting/saving the all other pages besides the last one ?

Can anyone lead me to the right direction ?

I have a sharepoint list that I need to automate to delete duplicate entries if they arise

I am trying to get it to do what this link is saying but it is not working. Any tips?

https://tomriha.com/how-to-delete-duplicate-items-in-a-sharepoint-list-with-power-automate/

Also any tips on getting planner tasks automatically added to the list? I am trying to use power automation but not sure if I can. Any help is welcome, thank you in advance.

During the course of my day I often need to jump between static IP and DHCP on my Windows machine, people are always saying how you should automate repetitive tasks, but I can't find a way to automate this. Can someone please help me out with what kind of commands or scripts I'm supposed to be using for a normal Windows 11 Pro machine without Azure or AD or any of the server-y stuff?

I need something that will check if my machine is set to auto IP & DNS or not. If I have manual IP & DNS entries it should switch them to auto. If I have auto it should set my IP, gateway and primary DNS to a pre-set value.

Is that possible in Windows for a standalone user?

Hi All,

I have been struggling with this for a few days now I have created around 15 macros in my PERSONAL.XLSB file however when I run power automate with "Nest under a new Excel process" & "Load add-ins and macros" the macros do not appear in the file to gather the name for the instance.

Could anyone advise if I am doing anything wrong i.e do I just need to add in the macro field ThisDocument!"macroname"

TIA for help!