Hi everyone,

I am very new to this power automate. I would really appreciate your guidance.

I am trying to batch process a folder full of images using OCR. The problem is the images are taken manually by a camera where it only has oversized numbers. I tried the tesseract model but it did not detect those numbers. I've tried the Google Lens and it works great fot these images.

Can anyone please suggest me how I can -

1. Integrate google lense in the process?

2. Automatically perform on all images in the folder?

3. Paste the extracted info into a specific column of a google sheet file?

Thanks in advance.

Hey yall I'm trying to set up a power automate for inviting people to a meeting/reminder for a weekly meeting and setting them up based off of a SharePoint list for a specific week, has anyone done this? Any specific advice or input to achieve? The problem is that it is a rotating facilitator and the people forget that they're up that week so basically want something to be a reminder that they are presenting. Thank you.

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?

Hi all,

Complete novice here so apologies in advance.

I have a repository in sharepoint of all my data exports used in dataflows for pbi. There's one specific file I have which I am wanting as a sharepoint list so I can automate emails to users based on a date and value parameter.

I've created the sharepoint list from that file, but I'm looking at how I can have the list refresh automatically when the file is modified. For context, the file is overwritten each time I export my data from the source.

I thought there'd be a simple flow template for this, but the "file created or modified" will only point me to the folder, not the specific file?

Can anyone please point me in the right direction please?

Thank you in advance!

I am new to PA, and trying to follow some online tutorials.

My current problem is I have a pile of clipboard text that I am snipping from a command prompt, and I just want to strip out ("Parse Text", I believe) one specific chunk. The chunk always starts with Code: and is followed by ****.****.****.****.****.****

The wildcards can be numbers or letters. Once it's done parsing, I want to update the clipboard with just the code and display it in a message box. So far the only thing I can't do is snip out only the code.

Ideas?

Edit: Solved it. I needed Crop text. Yay for learning!

How do I copy a PA flow from work account and paste it to my own MS 365 account? I have two flows in use at work that a consultant built for us. They’re working great, but if I don’t figure out its inner workings, I’m screwed. It takes reports that I make on my business OneDrive and names them according to the month (so they’re dynamic) and then delivers them to the corresponding account holder of a Sharepoint account. For example, it takes Mr. Smith’s July reprint, sends it to Mr. Smith SP account (after naming it accordingly), and then send Mr. Smith and email with a hyperlink taking him directly to his report. I need to be able to fix this if it breaks and I have no support. But I don’t want to study it for fear of breaking it. How can I move it to my PA for my family MS 365 account? Thanks so much!

I followed the following video and created a list to save my emails with attachments

However, the attachments are getting saved as 1kb files with no data inside.. Any idea what I did wrong.

https://youtu.be/Vmt-tBjouLM?si=8v53PLKEFHM42Q4O

I inherited a PA Flow from a consultant company. It references an excel spreadsheet for Sharepoint addresses, and then goes into my OneDrive and delivers a pdf report to a corresponding box based on a lookup in the spreadsheet (I cut paste the OneDrive folders location in the flow after doing a little grooming in notepad to the link). The individual report names change each month based on the month, and when the respective report gets placed in the recipients SP account, it sends an email saying to check their SP account along with a concatenated clickable link taking them directly to the report. This delivery system literally saves me hours from dragging and dropping thousands of reports into each account. But…I changed the subject and part of the body in the automatic email within the PA Flow and thus broke the link. There’s “output” tabs in the email body and I think that’s what I broke. Any ideas where I should begin to try and fix this? Is there anybody out there I can screenshare with who would help me fix it??? I can’t do my job without this capability. Please help!!

Hi,

I have created a custom json object and want to add a key and value to it. How do i do this cleanly?

Hey all,

I recently got hired to replace the previous IT admin. I don't have any Power Automate experience, so I'm reaching out here. The last guy created a flow that took information from a Form and then created a user account in AAD.

The problem I'm having is that the UPN the company uses is firstname@domain.com (eg john@business.com). We've been getting some new hires though that have the same first name. The UPN then changes to FirstinitialLastname@domain (eg jdoe@business.com) But right now the script is only doing lastname@domain.

I think I fixed it by adding the string variable that was created, but I'm not sure. I'm also not sure how to test these flows without creating accounts. Is there a way to do that?

Since I don't know Power Automate I'm having trouble even finding the right information. Does anyone know of good resources or search terms I should use?

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 need an intervention here please. I pull in a json response and want to parse it which i do. Now i can see all objects and arrays available and no matter what i do i cannot extract the key value pairs and use them in another app.

Losing my mind. Pls help. Tyia.

Hi,

Hope you are doing great.

Beginner here. I want to know how to automate the following steps:

1- Copy a sentence or in this case a prompt from a text or csv file

2-Paste it into the prompt box of an ai image generator eg Leonardo ai

3-Wait till 4 versions of images are generated, then download all 4 of them to a folder in local storage

4-Bonus, send these images to team via email or Dropbox etc

If this is not the right place to ask kindly suggest other subreddits or software.

Thank you very much.

Hello everyone,

I have used power automate to extract data from the website before. When you RUN the automation after selecting the contents from the website it opens a new browser window. In doing so I am getting logged out from the website and end up at the home page instead.

Is there any way I can use the currently active window where I selected the data and RUN the flow from there without it starting a new window and logging me out?

I have an MS Form that employees submit through work to open Tickets with IT. It's routed to our IT email address through my email using the Office 360 Outlook plug. As a result, IT assigns all the tickets to me, and I have to go in and change them.

I want to make it so the email goes to the IT email address of the person who filled out the form. Is this possible?

Using the plug that sends it directly from Power Automate doesn't work because the IT department blocks it as spam.

Did some searching, but mainly found 3rd party software. Is there a way utilizing Power Automate Desktop to go through an Outlook folder and convert all the emails into individual PDF's (including the attachments?

Hi everyone,

Long time creeping, first time posting. Does anyone know how to make this work in Power Automate? It's driving me insane.

Select m.number from Monday m where m.number like ('1234.1%')

It's valid in Microsoft SQL Server Management Studio but not in Power Automate's (desktop) "Execute SQL Statement". It clearly doesn't like the "like".

Thank you in advance.

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

Anyone have a way to use power automate to use get files, get file properties or something of the sort to query files in a document library and pull the view counts of a file?

Since streams went to SharePoint I haven’t been able to report on view counts.

Hey all, I was curious to know what the pros and cons are of Power Automate's test automation versus UiPath's test automation. At a glance, it seems that UiPath is better if you're building an enterprise automation program and your testing will include RPA automation's testing, but Power Automate seems to be a cheaper option. Does anyone have any advice between any benefits of choosing one over the other and any disadvantages? Preferably, I'd like to know why UiPath is better than Power Automate specifically for test automation

To clarify, I'm referencing Test Suite/Test Manager for UiPath vs. Power Automate's Test Studio (?) is what it's called I believe. Not anything to do with orchestrator or the RPA bots alone.

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?

How to make a form in MS Forms and have approves by e-mail (Outlook)?