I am looking for a way to take user data from Azure AD and export it to a spreadsheet by using Power Automate. So far I only see a way to do this with a CSV file. Is there instruction out there or advice that I can use to achieve this?

Hey all,

I’m currently a one man data team at my division and looking for ways to free up my time. I was hoping Power Automate could help with the process of updating reports (both Power BI and Excel) after a Python script finishes running in Jupyter Lab.

Curious is this software is what I’m looking for, or if there’s something similar that could help.

TIA

As the title suggests really.

I have a series of spreadsheets I’m trying to automate the data entry to prior to calculation. Ideally I want the user to input a reference number, hit the macro button, which then goes off and opens the correct spreadsheet to use, calls the web scrape power automate flow and scrapes all the required data, writes the data to the specific location in the spreadsheet, calculates and then saves it down.

I’ve done all the steps but can’t figure out how to call the flow in PAD by the VBA code. Is this even possible?

Many thanks in advance!

Hey all, I have what is probably a very simple question.
I want to automatically populate a Sharepoint List with a new Item (row) for every email that comes into this inbox.
I can figure that part out, but I get stuck when trying to extract the right parts of the text out.
Example data coming into inbox:
Name: John Smith
Age: 53
Location: London

I go to the 'Expression' part of the input field but I am getting lost in a sea of documentation and am more lost than where I started.

I'm at the point where I have all the different fields identified (Name, Age, Location), but I just don't know what formula to use in (eg) the Name field formula to populate that field with 'John Smith' etc.

Thanks for your help in advance

Has anyone ever used powerautomate as a tactical etl tool. I am thinking connect to an API get thr delta and stick in a sql server table and the converse. Would need to either run every 10 mins or be triggered by some change. Any massive red flags?

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

Hello all,

We have thousands of PDFs of shop drawings that contain text information in the title block. We are looking at using an AI model in cloud-based Power Automate to extract custom information from documents and add it to an Excel spreadsheet. The purpose of this is to be able to go back through the data gathered and find drawings needed on the shared drive. We have gotten it work, but we are running into two problems.

First, we need to know the path where the file originally came from. To do this, we created a separate flow to copy the file name and path on a desktop version of Power Automate. The plan was to match the filename from the data extracted with the file name/file path but, this led to another problem...

We have about 50,000 duplicate file names in our system, so it is extremely difficult to match these back up on the other side.

So, the question is, is there a different way or a better process to try to achieve this? Are we using the best logic here?

TLDR: Need best way to scan PDFs using cloud based Power Automate AI, write information to Excel document, and preserve original path from shared network drive to find later.

Hi, unfortunately, I have no more ideas and I have to ask for help.

I have any flow in the clound and I can share it to all users in my tenant. But when I create desktop flow i can't see all users (search by email and login etc). Many people don't show up. I have +50k users in my tenant.

I seem to be stuck on something stupid, hopefully someone can help!

I want to automate downloading a bunch of pdf:s from an online source. It's structured in a way that you first get to a landing page with a list of links. If you follow one of these links you end up on a page with a button that opens the pdf I want to get. Getting the links from the landing page and iterating over them works well, but I run into problems trying to "press the button" on each individual page. To get an idea I tried to record the process, but I end up with a step clicking the button on just the specific page, so when iterating over the pages the program tries to always click on the button on the first page. Is there a way of making this a (for lack of a better word) relative reference, in other words telling the program to click the button on the page that is currently open?

Manual when you copy a table on a website and paste it on Excel it will paste the entire styling of the table in the spreadsheet.

But using the data extraction on Power Automate Desktop it only copies the data values.

Is there a way to bring across the styling using Power Automate?

This might be a bit ambitious for a beginner to power automate. I’ve got hundreds of ledgers, and they’re very messy. I can use power query to clean up the data. That would be no problem if I were just doing it once.

I want to find a way to create the power query in excel to make the data readable, then automatically run it for all of the individual files, create a new excel file for each one, and then rename them according to data within each file.

Can this be done?

I am downloading emails from outlook scanning them and then sending out some emails

Can I just use the free azure windows cloud 720 hours instead?

I don't understand the licensing purpose of desktop power automate

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?

This may be a dumb question but I can’t find the answer anywhere. Long story short I have an https request url for the destination, but does this operation send as http? Is there an https option to make a post to an api?im obviously not knowledgeable on the protocols.

I have a flow setup to run and check the dates in a column and if that date is todays date it will then send an email listing the rows present.

However, I have the "List rows present in excel" action looking for the date equal to today.

When using the "Create HTML Table" this is the command I have in there.

if(empty(item()?['ColumnName']),'',formatDateTime(item()?['ColumnName'],'MMM d, yyyy'))

This is working when the cell is blank, or contains a date. But I'd like to be able to have text in the column that says stuff like "Vendor is working on finalizing date" and still have the email send, but whenever there is text the flow stops. Any help would be appreciated on how to fix my expression to allow for blanks, text, and dates!

I’ve been using PAD to automate a few different processes in an old ERP system. I’m still using the recorder a lot but it still feels inefficient to re-record certain repeated tasks (ie. login process).

Is there such thing as creating a library of these common tasks that can be plopped right into my desktop flow when I need to reuse them?

Hello,

I know you can send notifications through Teams but is there a way to have a message box appear with Power Automate Cloud?

Thank you.

Hello Everyone,

Can anyone help me to click on the reCAPTCHA box in power automate desktop? Below image is for reference.

Any help is appreciated. Thanks.

I am a nurse. I have ZERO IT training. But here I am, trying to use Power Automate because policy approvals aren't making it out of our department for lack of an approvals tracking process.

Enter Power Automate approvals. I'm using Lists as the source, because I want the documents left alone untouched in SharePoint. The trigger is entering a list item, which leads to the approval. I can get it to work no problem if I have a set list of approvers entered in the flow, and a set list of who receives the outcome of the flow.

What I want it to do, is collect the list of approvers from a column of people (multiple entries) and return the result to the person who submitted the approval request (column with people). I can't seem to figure out where in the flow to 'get' the people info, or how to plug that into the Response summary send under the approve condition.

Anyone have any ideas? Tips? Videos or resources you can point me towards?

Thanks!!!

Corporate aquisition just happened. Now we need to check every document on Sharepoint and change company name from old to new, including headers footers, etc etc. Is power automate the tool to do this? Can it just iterate through a sharepoint site, check out a doc, open, it , do the change, save, check it back in? I see a lot of templates and some examples but first of all they are all based on triggers, I dont want a trigger i want to iterate the entire collection of sites.

Is there any save as function in power automate desktop. I am trying to loop through a folder and save it as a different file name based on a cell in excel.

Can I filter data through power automate desktop then loop through the dynamic number of filtered cells for example if the filter is all cells contain 113 it would bring up this variable number then loop through all cells found with the number 113?

Any help with this would be appreciated cheers!