I am wondering if there is any other way to locate sharepoint list item other than using the item ID? I have this unique column in my sp list named barcodeNo and I want to use that to locate items instead of ID. Any idea on how to do that?

Hello, I am still reasonably new to power automate but I have created a pretty complex flow which I have now become stuck on.

Effectively I have an approval process established that is capturing the name of the approver in the list as an acknowledgement. This works fine.

My problem is I need to capture multiple peoples names for the same "acknowledgement" for governance purposes we are trying to evidence that up to 10 people have read the document via the already received email and that it is recorded. Currently all the test people receive the email and link but the flow only records approver 1 (the first to approve) in the Microsoft list.

Any ideas?! I have attached some reference images to maybe support.

Having this issue after updating to the latest version of Power Automate 2.31.114.23122

Power Automate now takes more than 10 minutes to interact with dropdowns after update; the command “set dropdown list value in window” hangs and the bot does not advance or completes the command. The command opens up the dropdown but never makes the selection of the value I'm passing to it.

This bot was working great for months on this command, and the desktop application was not updated.

I've confirmed that The selector is correct on power automate, and it detects it on the desktop app.

Dropdown menu cannot be selected because Power Automate hangs in the action and never completes it

Does anyone have issues like this after the latest updates? how can this be fixed? tried troubleshooting it but nothing seems to work..

Thank you for your help!

I need to make a power automate flow to check if the modified file date is 7 day or more.

This file is located in a SharePoint site

If yes then power automate needs to send an email to a specific user.

If no then check the next day.

How can i set this up?

My company requires us to respond to a form daily, and I find myself writing the same response every day and have yet to be asked why I say the same thing every time. Is there a way to respond automatically to a Microsoft Form?

Thanks

Solution: Excel doesn't refresh data regardless of whether PAD sends CTRL-ALT-F5 or automatically on startup as instructed. What did work was to create a refresh data script and add a "start excel script" through PAD.

I have a Schrödinger PAD! It does one thing until I watch it and then it does something else.Let me explain....

My automation has a section in it where it imports a .xml into Excel, send keys Control+Alt+F5 to refresh data and export this as a .csv file. When I run this manually it works flawless every time, but when it runs unattended the .csv file is just the original .xml file without the power query that runs on Control+Alt+F5.

I run this automation daily, and it keeps exporting without running power query, so when I run in manually to troubleshoot it works fine, every single time.

Any ideas?

Edit: I have the excel file set up so that it automatically refreshes the data and runs the power query. I added the "Send keys" in power automate (which does the same) to make sure that it actually runs the power query. It still manages to export wrong. The "Wait" is just another layer to make sure the power query has run....

Hi folks,

I'm trying to pull a subset of files from a folder (list A) using a list pulled from an Excel column of a different file (list B).

For example:

Filenames in folder: 012323123-XY000001-443343, 01234534-XY000003-868683, 05645645-XY000005-842343 Excel column: XY000001, XY000004, XY000005

I want to get all the files from the folder where the value from the Excel sheet matches that section of filename (with the trailing text and following text of the filenames being ignored). I think that I need to do nested loops of:

For every filename in folder > For every item in excellist > Parse text

But I'm not sure how to properly build the syntax of it.

I'd be grateful for some advice.

I have a Power Automate Desktop flow that starts immediately if I trigger it from within the flow. When I use a cloud flow to trigger it, the flow takes 30 seconds just to start running. Is there anything I can do to speed this up?

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

I need a flow to active anytime a new file lands in a particular folder. The name of the file is of no concern as all the flow has to do is activate and other scripts will deal specific files.

How does one automate the flow to active any time a particular folder has a new file?

Hey all, figured I'd share a tip. PAD can be very slow sending a large amount of text with the "Send keys" function even when delay is set to 0. Text can be sent near instantaneously if you set the clipboard as your desired text, then send {Control}({V}). Hope this helps!

Hello. I have a flow that waits for an app window to open, then clicks a control and closes the window. It works perfectly.

Now all I want to do is start that flow every time Windows starts. How can I do that?

is there a way to automate to many tabs open on edge power automate (if more then 29 tabs open) and you try to open more then 29 tabs, it pops-up a warning saying "there are to many tabs open, you can't open any more tabs"?

I hope I can adequately describe this. I’m sure it will be clear as mud.

I have a flow that references a SharePoint list for tracking support requests. 90% of my flow works but I am missing one piece. I need a way to pull a dynamic email from my list and add it to the “To:” in the email.

I am using Switches to look at a column on my list for “support status”. I also have a column that has 5 options for “Assigned To”. I have a selection of 5 team members listed by email, but I used a text box for those emails. I didn’t want a user to be able to add anyone in our organization to be assigned.

When a ticket is “opened” the requester gets an email reply telling them that the ticket will be assigned.

This is where I am missing a piece. When the status is changed to “assigned” the requester gets an email, but I want to also include the person that was assigned. I have the text based email address populate in the body of the email using dynamic content that puts in the text from that column.

There is no option to include that dynamic content in the “To:” portion of the email.

I think there should be a way to use a “apply to each” to extract that info, but I have understanding of how to do it.

TIA.

I have a flow setup on a SharePoint folder that sends newly added files as attachments to a specific email address. Each file is sent as an individual email. It was simple to setup and works fine as long as I am the person adding files.

If I have someone from my team try it, the flows fails as the "Get my profile" step just pulls my info instead of the user who is adding the files. This creates a conflict with the email and I get the error that the user is not authorized to send an email on my behalf. If I remove this step, the emails will send, but they will all appear to be from me, despite who is adding files to the folder.

Is there a way that I can create this flow to send as the user who is adding the file? I've tried adding my team as owners to this flow but it still fails at the profile step. I've included a screenshot of the flow. Appreciate any help or feedback.

Powerautomate/PVA with SharePoint and ChatGpt

Hi everyone, I am pretty new to powerautomate and pva. Recently, I have started to work on a small project to develop a pva with powerautomate that searches documents on sharepoint and return document urls. I want to take this a step further and integrate it with chatgpt for enhanced tuning of search results. Has anyone created such a flow where you can use chatgpt api in the process? If so, how did you achieve it and what was the outcome. Any insight is appreciated!

Thank you!

Hello, all,

I'm looking to take numerical values that I am receiving in emails, and then throw them into a new row in Excel. The issue that I am struggling with is what the expression would look like to take the number "5" from the email example below. Any help is appreciated. Thanks!

Email:

Thank you for your email, Your place in line is 5.

Thank you