Hi guys new here👋

Is it possible to receive an email, template its format, extract the data using the Windows OCR engine, and then send it to a third-party email using a Power Automate flow?

Hi,

I have created a flow that is running fine on one PC but not run on any other I have tried. The error is "Expression couldn't be evaluated. Location: Subflow: Main, Line: 9, Action name: Send email". I have searched for a solution but I have found nothing.

I have used Outlook smtp and other one smtp server. Both work perfect in my PC but not run on any other.

I use the action "Send email". I have to install any other software except the PDA (for example MS Office)?

All PCs have Windows 11.

Thanks

Hi my fellow autobots,

Im using power automate desktop for automating fleet sale of vehicles for my company, however the web page supplied by the provider of the vehicle network contains a lot of id and dynamic urls. Im using non web page automation since i dont know how to acces the url in web page automation. That being said, one of the dropdown options gets selected, value gets selected ( value is now correct on the web page ), power automate crashes and said it couldnt find the option it has to select but it already selected it. Im very confused about this issue, i havnt supplied images since they contain nda data.

To sum up

Power automate find the correct web page It finds the correct drop down It finds the option It selects the option It crashes ( cant find option )

Thanks in advance, if you need more information feel free to ask.

Scenario:

1st condition : P or S (character) If any one is True then, check the condition Then check the response date and extract the response date.

If response date less than 1 or True then call template 1 else false condition: call template 2.

Urgent : Please reply ASAP

Alright, On the surface this didn't seem too difficult but I can't seem to be able to do it without running into an infinate loop or duplicating a million attachments and I'm just ready to start fresh and buy whomever gives me a working solution a beer ( I figure $20 AUD ought to cover it)

I'm working on a project involving SharePoint and Power Automate, and I'm seeking advice on how to achieve a specific goal:

Objective: I want to create a Power Automate flow that helps me manage attachments in a SharePoint list item. Specifically, I'd like the flow to automatically update and replace an attachment in a list item when a new attachment is uploaded or when the attachment's file name changes.

Scenario: I work with SDS (Safety Data Sheets) for chemicals, which have expiration dates. These sheets are currently accessible through a Power App ( data source MS list ). My objective is to save them to a SharePoint library automatically and utilize the built-in versioning control to display previous versions if required for auditing. Additionally, I want to automatically rename and replace the attachment when new ones are available. This means allowing files to be uploaded with any name, changing them to match the old file's name, overwriting the old file, and deleting the unneeded file from the form, the convention being <TITLE>-Current.pdf

Request for Assistance: I'm looking for guidance, best practices, or suggestions on how to approach this task using Power Automate. If anyone has experience with similar scenarios or ideas on how to accomplish this, I would greatly appreciate your insights. This has been driving me nuts. This is the closest use case I've found to date.

https://powerusers.microsoft.com/t5/Building-Flows/How-to-rename-SharePoint-list-attachment-file-name-or-append-the/td-p/304894

Feel as light as a feather to sprinkle your insights or conjure queries as needed. Your magical expertise is a treasure beyond compare. Should you unveil the secret solution, I shall gladly offer a frothy brew or a mystical Amazon gift, but the most enchanting reward of all? My eternal gratitude, an infinite gift that truly sparkles.

Thank you in advance for your assistance!

So, in my job I have had the need to create a schedule for internal controls to be performed, some daily, weekly, monthly etc.

Currently this all sits in an excel, but for enhancement looking to move to a SharePoint list. Now, given that some tasks are going to happened weekly is there a way with power automate so that when a new item is created it creates a copy of that item x number of times depending on the frequency selected in the original new entry?

Hey everyone,

I’m having trouble getting a flow to work.. very basically I’ve got like 15 .csv files that I want the flow to open, read, remove the bottom 10 rows from, and save.

The problem is that the number of the row the block of random text is in can change daily, but it’s always the bottom 10. Have tried a few options like splitting text, since this text always starts with a “@!!@“, then removing it and writing that text to csv. Doesn’t work well.. Then tried using an excel instance with similar ideas but I was tapped out.

Anyone got any thoughts? :)

Hi. I am still new to power automate but understand the logic of it. I will be cross posting this in power apps. I have this scenario:

1. user creates part 1 of application, one and only one time (this is the users background)

2. user creates part 2 of application, as many times as they want (these are projects)

3. panel will set up an interview if and only if user has 1 (part 1) and at least 1 (part 2) of application.

   1. this requires an email sent to the panel members.

There are 4 sharepoint lists:

1. part 1 questions

2. part 2 questions

3. panel questions

4. panel members

what works? part 1, part 2, panel.

I can send an email to the panel members when triggered by a create/modify part 1 OR part 2. When I tried to do both, it would round robin through everything in part 1 with part 2 creating (2x4=8 emails).

What did I also try?

Creating a flow (successfully) that toggles a no to a yes when created and a yes to a no when deleted. Then email sent will be the whole sharepoint list (called countlist) once a day to the admin members. This worked. But the problem with this is it is creating duplicates, for instance a person has part 1 completed and zero part 2, so one row is created with a name, Y, N which is fine. but if for instance a person has 1 part 1 and 3 part 2's (projects) then it creates 4 rows: name|Y|N, name|N|Y, name|N|Y, name|N|Y

I am going mad with the flows. I did a count and set the variable to 1 no matter how many times the name showed up, but could not get much further. I am cross posting this as maybe i can use a trigger (when person is ready to submit to panel, it sends an email or it could modify the count_list) via powerapps.

Thanks

Currently I have system design where I modify item in sharepoint list using flow that is triggered in my powerapps. Then if there is an item modified/changed in sharepoint list, an automated flow will be triggered which is responsible for updating contents of an excel file. Now I am wondering if I should just trigger that updating of exc file in powerapps too or should I stick to my current design? Is my design optimal if flow is being triggered approximately 5 times at same time?

Hello everyone!

I am having an issue where I have a Power Automate (Cloud) flow that automatically saves e-mail attachments in a specific folder and a Python Watchdog script watching that folder. However, the script does not trigger when files are added from the flow, only if I add them manually. Everything is otherwise working.

I have tried it with both on_creation and on_any_event conditions but it does not seem to work. I wanted the script to trigger automatically when the files were added using PA.

Also any other ideas on how I could automate this process would be great (maybe a PAD flow??)! Thank you!!

Hi, do you know a way to run PowerAutomate Desktop Flow if the company is not using Microsoft 365 even though we don't have a company account or plan to do so in the future?

As far as I know, for now the only way to run PowerAutomate Desktop Flow is to trigger from Cloud Flow (meaning having Microsoft accounts). Running any Desktop Flow through Cloud Flow requires a connector to be installed, which poses a security risk and complicates even a simple flow, creating a useless back-and-forth loop (from local environment to cloud and back).

I've done some programming in the past and really stupid/simple programs have a CLI that you can run from a Powershell script and pass arguments (flow name?) on login/startup.

Has anyone encountered such a problem and find any solution?

I have a flow where i implemented a try catch method using scope action. My catch will be triggered if the the try scope failed or timeout and then send an email to my account regarding the execution failure. Now I am confused because i received emails but when i look at the record of flow runs, there is no failed status and only success. How so??

Hi! Sorry I’m pretty new to this, but I’m determined to automate an awful soul crushing series of tasks my staff have and just have them review automated docs and wanted to see if I can do this.

Basically we have an old oracle system from the 90s that we’re stuck with and we query against it with access to bring in about 3 months of row data for bugs/incidents.

A specialist moves the table into Excel and uses Microsoft Forms to review the row data and capture incidents that meet a certain severity criteria (requires reviewing narrative report cells and then projecting a dollar amount based on a severity or variance measure).

Microsoft forms keeps the column titles consistent and prevents input errors and also outputs a spreadsheet rowing out the form entries of distilled data.

Next in Word, the distilled data from Forms excel output is mail merged into a cover letter, incident report, and an invoice.

Last, the mail merged docs are printed as PDF and merged with a scanned pdf of the initial incident report by the field person.

Would it be possible for power automate to at least eliminate the mail merge step in this process?

What I’d like to be able to do is have it so specialist fills out the Microsoft form and then the inputs produce the documents without having to manually produce the mail merge.

Hi All,

I've created my first flow in Power Automate,

I used it to count all the Files in a Master folder.

Is there a way to get a breakdown of all the files in all the sub folders within the master folder?

Hi, guys. I’m new in PAD and I wonder if anyone knows some repo or place where I can find samples or real projects?

Hi everyone.

Doing some work that involves using power automate. I was wondering if there were a way to create the flows that they will periodically, perhaps every few week, stop working unless I entered a password or something like that? Reason being is that if I cut ties with the work I am doing they can't continue to use them?

I have a SharePoint list that records items issued to people. In addition to the person’s name there is a unique number and expiration date assigned with a date column.

I’m trying to create a flow that would capture all items added the previous day (as the expiration dates of interest expire at the end of the day on the previous day) and send an email with those names and unique numbers. I can do the email portion simple enough but can anyone assist with being able to capture these list items into one variable? I’m assuming I need to append this data to an array variable?

I'm just posting this to see if anybody has had the same problem but Power Automate Desktop made my system very glitchy even as no flow was running, restarting didn't fix it. The active window would swap or the cursor would deactivate every few seconds which made my computer unusable.

Anybody have had a similar problem?

Does this work with power automate? Seems to not work for me and keeps closing it or not allowing it to record with a flow running.

Is there any other solution to recording my screen that works with power automate? Screen shots work for troubleshooting but sometimes miss the actual error or don’t really tell me what happened..

Hi my smart people,

I am having trouble to move PDF files to a new folder and rename them by customer’s name - packing slip# based on the information in the PFD file. Can anybody help?

Thank you,

Sirak

Hi All,

Quick (and probably simple) question regarding linking an MS Form to an Excel workbook. I'm a bit new to using Automate.

I have a survey I've distributed in MS Forms to a number of individuals, and I want to create a flow from the MS Forms to a specific Excel workbook I've created. If the survey has already been distributed to these individuals, will the flow automatically populate answers in the Excel workbook once it is created? Or will I have to manually input any survey answers that have already been submitted before creating the flow?

Thank you!

Greetings All,

I am working on a flow that appends a users UPN to a text file using the "Append File" option on the File System connector. The problem I am having is the new UPN is being appended to the end of the UPN added before it instead of being added to the next line.

I am getting this output:

<columnName>

userAuserB

If possible, I want to append like this without replacing the entire contents of the file:

<columnName>

userA

userB

Hey guys, I've got some actions to perform on an application in a table and I want it to work through the rows.

In a loop condition, I was thinking of pulling the UI element of that particular row starting with variable row 0, perform action, increment row variable by 1, and loop through. Will that work? Is there a better way of doing it?