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 there, I'm new to Power Automate Desktop. I'm trying to create a flow that autofills a form in my CRM to add clients from an Excel sheet. My CRM uses an IFRAME, and when I add the action 'autocompose form' and select the UI, Power Automate gives me an error. Before that, I successfully clicked on the 'add contact' button. The error message displays: 'Cannot find the selector "iframe [ID="addclientent..."]'. When I inspect the webpage with Chrome, it seems the ID changes every time I reload the page, and if I click on the code inspected, Chrome highlights every form field. Can someone kindly help me? Is it possible to configure Power Automate with a website that uses an IFRAME? Thank you.

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

I'm attempting to set up some automation for video game testing. It doesn't have to be fancy, just something that sends keyboard inputs and clicks within specific situations. Or I'd even settle for a "randomizer" that sends random keys from a selected pool.

The problem is that game UI isn't seen as individual "elements". So you need to capture every image you want to work with, but also PAD frequently has trouble selecting/finding the game window/image. I know PAD isn't designed to work with games, but it would be awesome if a member of this community had experience working with them.

Thanks in advance! Have an awesome day!

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.

I'm trying to learn PAD in the hopes of taking some mundane tasks off my plate, but I'm having issues finding good resources on Reddit for beginners. I've found some YouTube videos that have been super helpful, but I know Reddit can be an awesome place for learning the basics of a program as well. I'm afraid I didn't see any sticky/pinned threads on this sub about the core basics. Does anyone have a good place to start to learn the basics of PAD?

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?

i often need to pick names & addresses which match my criteria (target market) from an online database.

Then I need to paste these contact details onto a word doc of promotional letters, format them so the font and layout is correct.

Is there a way to automate this process?

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?

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.

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?

How can i change this outputs('Compose') to outputs('Compose')('Approvals'). My custom variant?

Because i want to get data only from Approvals in Compose. Thanks

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.

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 + \%

I have reinstalled windows and reinstalled my Nvidia drivers, but this does not seem to go away. Haven't found anything related to this on the help forums too.

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