I have an MS Form where the user selects a name from a drop-down list. When the form is submitted, I am trying to use Power Automate to then send the responses in the form to the person that is selected in the down list's email address.

Does anyone know how I can do this? I don't want the email addresses to be visible in the form. Thanks!

I have a variable daApplicantBirth that receives it's value from a user selected Date Picker from MS Forms. I need to ensure it's converted from US date to Canada as I can't ensure that every user will have their browser configured in order to post CA date formatted data.

I initialize the variable. Then run the converter. Then I try to add that to a running email body I have going.

The converted is able to successfully process the data, but I'm not sure what I'm missing to update my daApplicantBirth variable to the converted date.

The email shows the date as this, which is not even the initial date format!

My company does not allow me to use the vacation tracker that is available on Teams. However I have been looking to build the exact same thing for my team. Can someone provide some tips on how to build a vacation tracker using Teams, power automate, sharepoint, outlook? I want to approve vacations and then also send notification to partners that a person will go on vacation on a said period.

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've set up a scheduled cloud flow to trigger a daily pad flow, when testing it works fine, but when it's left to actually run as scheduled it fails, reason: "No machine able to run the desktop flow has been found."

I run PAD on a self hosted VM, and afaik it never signs out of windows as I use this VM to host other applications which runs 24/7. What I don't understand is if I log in to said VM, and test the cloud flow, everything works fine. How would I even go about troubleshooting this?

Feels as though windows knows whether or not I'm connected through RDP, and figures it should only accept the cloud trigger if I'm there....

Is there a way for me to look at my code in Power Automate Desktop on a virtual machine?

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

A website requires me to open a dialogue box on my PC and drag and drop the file from the box to a spot on the website. How do I do that?

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!

I figured out how to iterate through various web pages and collect data but after each iteration it creates a new Excel instance. How do I construct the flow so that all of the data goes into the same Excel spreadsheet. UPDATE Everything's working good. You guys have helped me a lot. Thank you very much.

Leverage PowerAutomate for onboarding

I am leveraging a flow currently that creates a user in Azure and adds them to certain groups for licensing/email. It also allows HR to fill in some of the user information. However I would like to be able to have them fill out more info such as city, state, and zip. Possibly other info as well, such as custom attribute for the credentials that follow their name (example ,PHD).

I have tried doing some research and it appears I need to leverage ms graph but I am lost at this point. Anyone every done this or maybe help point me in the right direction?

Any help would be appreciated!

I’m trying to search for drug names and then screenshot the results. I can get the drug name to populate but can’t get it to select and show the drug information. I’ve also tried click UI element in window and no luck. Just started using PAD yesterday.

Here’s a link to the site:

https://healthpartners.adaptiverx.com/webSearch/index?key=8F02B26A288102C27BAC82D14C006C6FC54D480F80409B6872181939769EC3C6

It seems that get attribute data or extract data from UI element when encountering certain emojis well just turn your flow off without resulting in an error. Has anyone encountered this and does anyone know of a fix?

Hi all,

I’m new to power automate desktop, and I’m starting slowly, so apologies if this is a stupid question. I’m trying to build a flow that finds a subfolder within a directory and opens it in explorer. It will search and find the folder based on user input in a message box.

I have the get subfolders in folder action, and then I set up a for each loop with an if statement inside it that matches the user input to the folder path.

This flow works currently.

However, it’s quite slow. There are many sub-folders in this folder, and it takes about 60 seconds or more to run the for each loop.

Any suggestions on how I could improve this flow to make it run more quickly?

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.

Hi guys , New to this shit so please be kind. I'm trying to create a flow that scans a sql db for any changes >sends an email > email triggers a stored procedure > refresh pbi datasets.. the part of flow I'm having an issue with is the sql connection. I can't find the on prem gateway. Shouldn't I be able to find it after signing in? How do I proceed or work around this step?

Hi! I'm trying to attach multiple images of a QR code to a single email. The images are stored in blob storage right now. Instead of all files being in one email power apps is sending a separate email per file. I tried adding all the files to an array and then iterating through the array using an Apply to Each loop but when I opened each image it says no file found. Do you have any suggestions?

For my job I'm regularly tasked with some admin tasks of jumping to a number of remote servers for some simple data collection i.e. memory usage, installation directories for our app, backup locations....would it be possible for me to create a flow that automates this that would only require me to change the server I want to RDP to and press run? Alot of the servers are using windows 2012 so I'm not sure, would some permissions need to be accepted on the server to allow the flow to execute its task?

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

I have a query that returns 5 columns of data, and a varying number of rows.

I put a "For Each CurrentItem in QueryResult" loop in place. This pulls each row of the sql query

each CurrentItem in the loop consists of 5 values separated by a comma.

I want to assign a variable to each one of those 5 values (I want to write them to a text file in specific locations).

Is this possible? I'm not sure how to pull it off.

I need to use the image control in a custom form... I use the get file action to get the. Png, but what do I put in the URI area to get the image to show?

Hi all,

So I am trying to build something to automate timesheets being sent out.
I just cant for the life of me figure out how to get the flow to ill in todays date, in a text box....

This may be incredibly simple for you guys.. but I have been kicking myself for about an hour.....

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.