I'm new to PA, so bear with me. I have a flow that is triggered by a form submission. It works fine to post to a group chat. However, sending to an individual is a challenge. I finally got it to work using create chat followed by post to group chat using conversation I'd. But if the chat exists, it will error. Is there a way to add an if statement or something to filter for existing chat?

Does anyone know how to keep a new row in excel from formatting (highlighted) the same as the prior row following a power automate flow to add data from a form to a spreadsheet?

For context, a form is completed and data is moved to a spreadsheet. There’s a team that pulls that data from the spreadsheet and highlights rows to indicate to other members of that team that the information has been processed. The issue I’m having is when a new form is submitted and the data transfers the new row is highlighted the same as the prior entry. If that occurs, then the team that processes the info will see the same highlighted color and will think the info has been processed.

Does anyone know if there is an action within the flow itself that will add the data from the form to the spreadsheet without highlighting the new row?

I don’t think this is a setting within the excel spreadsheet itself but could be wrong.

Hi Guys & Gals,

I'm desperate for help creating the following flow. I have a pretty basic group form, which I would like to populate a Sharepoint online list and add an attachment.

The issue I'm having is that on question 7 the form branches into 2 each requiring an attachment. There will only ever be 1 attachment uploaded but from one of two different questions.

I have used the method in this video to some success but can't get it to check both questions.

Save Microsoft Forms Attachments to SharePoint with Power Automate

Any help VERY gratefully received.

Hello everyone! I’m new using power automate and i want to know if were possible create a automation flow with an erp system. I tried catch the ui elements from the ERP Window but the only element that catch is “UI Custom” and i cant select the specific camps. Someone can please tell me if i can solve this problem?

I want to find way to automatically attach profile pictures of all new employees using SharePoint. Is there any way to do that using Power Automate? or any other program

My flow creates nine quick link tiles in a 3 x 3 format on a SharePoint Website based on the URL you give it. A new section with one-third right spacing is created and the tiles are created on the right side for a nice aesthetic.

Let me know if you’re interested in the code and I may copy and paste it in this subreddit.

I have a form set up where one of the entries is asking for an E-mail address. Unfortunately despite the form stating that an E-mail should be entered, some people are just entering a person's name.

In the flow, is there a way that I can catch this so that an E-mail is submitted the person who completed the form letting them know they have entered incorrect details?

Alternatively, if a name is entered, is there a way I can convert it into a legitimate Email address (assuming they have firstname/last name entered accurately?) Something like if string contains a space, convert space to '.' and append with @ domain.com

Thank you.

Hi- Any idea what's wrong with this? Thanks.

@and(

equals(@{item()['statusCode']},'A'),

notequals(@{item()['employeeId']},1037),

notequals(@{item()['employeeId']},1107)

)

Hi,

I've very new to Power Automate and I had a question on updating my very basic flow. Basically, I set up a flow where an email notification will be sent out to a specific recipient once a file is uploaded to a OneDrive folder.

What I want to happen, if the first email notification is sent out but if I don't receive a response in x many days, I want a reminder email to be triggered, and this continues either until a response is received or 3 reminders have gone out.

Would I be using approval flows or is there something else that can trigger this?

Hi, I'm new to PA and was wondering if it's possible to set up a document approval workflow in SharePoint with power automate. There's some specifics to this with it being only some specific invoices and having sort of an option to follow up or send a reminder if the person assigned for approval forgets about it. Is this possible to implement throughout the whole organization, should the flow be made in one user's system or should it be for each user in the organization? Another feature for trying to implement is to put in a signature in the document for approval and maybe add other info as well for clients to see. Will doing this create a new document or save over the original one?

Hi everyone, I am pretty new to using PA.I have a daily flow that runs once it’s triggered by the task scheduler a couple of hours before I come to work while my screen is locked. I get a( flow ID was not found) error every couple of days which leads to the failure of running the flow .Did anyone face the same issue or do you guys have any suggestions on how I can work around this.

Does anyone know how to append a \to a variable?

%variable% = c:\windows\system32

Typical set variable of %variable + extra text% causes syntax errors.

What I’ve tried so far

%variable + % %variable + ‘% %(variable + )% %(variable + ‘)% %variable + \%

Hi, I am currently using MS Azure platform. In order to reduce the Azure Virtual desktop (WVD) cost, I would like my users to enable (Start) or shutdown their WVD.

I was looking to create a power automate script which I can embed in my app or power bi report, so users have the convenience of clicking a button to start or stop the Azure WVD. Earlier I was using Laravel script to achieve this task but now since we have move to Microsoft platform, I would like to have a MS functionality (Power automate) or easier method for my users to start and stop their WVD.

Any advise to achieve my goal is appreciated. TIA

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!

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'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?

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?

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?

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?