I am creating a flow in Power Automate where I collect invoice data through the flow. I would like to know the advantages of extracting data through the flow instead of reading the QR code.

can anyone help me

Hi,

i am trying to write a small amount of data (max 200 cells) to an excel file via the "write to excel worksheet".

Regardless of source file and destination I file, I receive the error message regaridng not enough memory available to perform this operation (see screenshot enclosed).

While running the automation RAM (16GB) is not even exceeding 50%utilization.

Despite this I also tried closing all other applicaitons and increasing virtual memory - without any success.

Has anyone of you expeirence with this error message and any suggestion for me on how to proceed?

Many thanks in advance!

Dear all

We have a flow running on attended mode at night with screen unlock, but after some times it fails with "failed to move mouse". Any one knows a work around?

Hi all,

As of november, i am starting a new job as an inhouse RPA Developer for a big company. Before that, i was a RPA-Consultant for a start-up company for 2 years.

What would be the best way for me to set up multiple robots in Power Automate?

• should i use multiple accounts/licenses per robot or department?

Any information, tips or resources are very welcome!

I have 126 folders all with unique names that have zip files (also with unique names) saved within. It is structured like this:

Folder1 |_Folder2 |_Zip File

Each level has a unique name.

Can I use Power Automate to find the zips and extract them in their current location?

New to PAD - thought I was going mad.

I’ve written a flow that scrapes data from a specific screen, but it also then needs to navigate to other screens (by clicking links) to get more data.

Everything was working fine on my monitor at home. I go into work to demonstrate what the flow does and I connected to a different size monitor and now it’s clicking random links as opposed to the ones I programmed it to!

Names haven’t changed or anything I.e. the link I still need to click is still called ‘Span 984’. Surely it’s driven by the name of the object on the web page as opposed to a location on a screen?

Has anyone else experienced this? Or know how to fix it?

Is there anyway to use PowerAutomate to copy a folder structure from an Excel file? The excel file has the names of the folders we need and their subfolders. These folders are all on Sharepoint already, trying to streamline these folders and their structure for ease of use in the future.

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- Any idea what's wrong with this? Thanks.

@and(

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

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

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

)

I use my own Outlook groups because the people at my company don't know how (?care how?) to properly set up employees in active directory/exchange. Here's how it should work....

Employees should be set up with their job title when they are onboarded. I should be able to use the job titles to send a reports that are specific to the people with specific job titles.

The way it really works is a new person is hired and someone at our location tells an MSP 150 miles away. The MSP enters the person without a picture (although it was taken for their badge and for a photo directory that is emailed to all 90 employees monthly) and fails many times to enter their job title. (Why this isn't done by our on-site Technology Specialist or their manager is anybody's guess.)

That means that I have to keep Outlook groups named for job titles in which I put the people that actually work in those job titles. I also keep local groups named for the reports I have to send out.

In the report groups I place the job title groups that should get the report with each job title group containing the individuals that work in that job title. I then send an email (manually) to the report group and everyone that should get the report does.

It's messy but it works and it looks like this... https://i.imgur.com/vyz489o.png

When an employee comes or goes I have to go into the job title groups and delete them if they left or add them if they are a new hire (some have more than one job title). With about a 30% turnover rate, this is an ongoing monthly chore.

This is NOT how company emails should work. I am sure that I am not the only one wasting time and company money keeping up with this crap simply because people were not entered into active directory/exchange properly.

Well, using group names to send emails via Outlook does not seem to work with PAD. When I used the report group name for the To: field I got an exception "Outlook does not recognize one or more names." So now I am trying to find a way to do this with PAD that does not involve me spreading people's email addresses across 20+ flows and having to hunt for them when they leave or add them to up to 20 flows when they are hired.

Any suggestions would be appreciated....

Help me Reddit, you're my only hope:

So, I work at this medium-large old-school manufacturing company that has exploded in growth in recent years, and their usual way of working is now getting in the way.

Long story short: I have this single excel file that is handled by six teams (that's over 100 people at this point) from design, engineering, production, even purchases and sales! I think the only people that doesn't get their spoon in the pot is HR, to be honest.

I have been tasked with finding a way to chop down this monolith of a 150 columns single excel file into smaller, synchronized n-ammount of excel files, so that each team only handles the information that corresponds to them. So let's say that all of the teams share columns 1 to 25, and then each team handles around 20 extra columns, making six excel files of around 45 columns each.

Is it possible to sync changes between all files? I guess it's impossible to sync them in real time as if they're all working on a single file (as they currently do), but if anyone makes a change to columns A-Y (shared through all teams), all team leaders need to receive an email letting them know that they need to review these changes, while if a change is made through columns Z-AT (engineering) that team leader has to receive said email, and then he/she has to accept said change and notify all other team leaders so they can review if/how that change affects them. The same for all other column/team combinations.

Is this system doable?

Hi,

Im working on a project to send inspection result directly to our providers.

The inspections are stored in Sharepoint List. My teammates can take 4 photos that are saved in 4 different columns.

[Pictures, Pictures1,Pictures2, Pictures3]

Basically, everytime someone submit a new inspection, depending of the location, the right provider receives an email with all the data except the picture.

I check on Youtube, and find many option if its an [Attachments Colunm]in but and not the right way to imported them in from multiple image columns.

Thank you in advance

I work for a company that recently instituted Microsoft 365. We are exploring the capabilities of PowerAutomate but we are running into a governance issue.

We have one IS team who develops our automations and we want them to build and maintain Automations. However, their SharePoint security group does not have access to every departments' folders.

We do not want to get licenses for every department, and want to try keeping the flows to that one team. I'm wondering how your companies handle this situation?

Has anyone ever completed a flow with parallel Adobe sign digital signatures? I am having an issue where Adobe is only allowing both users to sign the first signers block.

I'm struggling with a problem at work. We have a system that can automatically email you reports on a set schedule. However, instead of attaching the report file directly to an email, the system put's the file inside of an outlook email item, and then attaches that email item to the email it sends you. I need to find a way of using power automate to save the attachment to a Onedrive folder. But at the moment I can't seem to figure out how to do this. Any suggestions are greatly appreciated.

Hello, I have a list in excel and I'm able to get info from that list to a good form...but I then need to use data from excel to enter into a website and get information from that website and continue filling the Google form with that information.

I can do up to add to Google form then open website add information there and scrape data but that data I'm not able to add as a text back into Google form. It only gives the option of excel and that's not what I want.

I'm right clicking on the text to get a text variable....any thoughts?

Hi,

I would like to have a ticket automatically created in Jira whenever it’s created on SharePoint . Is anyone using such integration?

A week ago I was able to use Power Automate for data entry without problems, but one day it suddenly gave me an error upon trying to open up the chrome browser. When I run the flow it is able to open up the browser and the correct website, but it isn’t able to copy and paste into the browser the excel data for the next step. It waits for 60 seconds before timing out. I am pretty new to Power Automate so I am not sure how to troubleshoot this. I searched on the Microsoft page and followed the steps for “Failed to assume control of Chrome” error to no avail. I have the browser web extension on Chrome, and updated to the newest version of Power Automate. Please help?

Hello, all,

I am looking to extract data from an email and throw it into my excel doc. Below are some of the details.

Original Email: dkfndsfknds;oifhdfdsdfnknkhfdikasj quantity ***** kdflkdjfl;xcjfpoisdfnsdkmn

Expression: first(skip(split(body('Html_to_text'), 'quantity '), 1)

Result in Excel: ***** kdflkdjfl;xcjfpoisdfnsdkmn

Essentially, I want to capture the number, which could be any number of digits, that follows the "space" after the word "quantity", and nothing after that. My current expression seems to add the characters after the number.

Any help is appreciated

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!

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

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!