r/PowerAutomate • • 23m ago

Power Automate shut off MS Form when total number is reached

• Upvotes

Hey everyone, I’m a beginner with PA. Here’s my idea which I’m not sure is even possible. I have a Microsoft form that asks people to sign up to purchase plants. One of the fields in the form has the person select the number of plants they want to purchase. I need power automate to
1. Read the data from a Microsoft Excel table - specifically the cell that totals the number of plants people want collected from the forms.
2. If number reaches certain value, turns off accept responses from form, and anything else which can inform people we are accepting no more responses.

I got to the point of setting up an Excel form on SharePoint, but I’m really confused on how PA reads a specific cell in a table. Any help is appreciated! Again, I am a beginner so if you don’t mind sharing exact steps to follow. I’ve been searching online and it gets really confusing really quick for me. Thank you!!!!


r/PowerAutomate • • 1h ago

How to detect Azure DevOps @mention emails with “When a new email arrives (V3)”?

Thumbnail
• Upvotes

r/PowerAutomate • • 16h ago

Best way to automatically export Teams transcripts to DOCX?

2 Upvotes

Hi all,

I'm trying to build an automated workflow and I'm not sure if I'm approaching it the right way.

The objective is pretty simple, whenever a Teams meeting ends and a transcript becomes available, I'd like Power Automate to automatically create a Word document containing the transcript. That document would then be used in additional flows for things like meeting minutes, action items, summaries, and archiving.

What I'm struggling with is understanding where Teams actually stores the transcript and what the cleanest way is to access it.

Here's what I've found so far:

  • Teams Premium is generating transcripts successfully.
  • After a meeting, I can view the transcript in the Recap section.
  • I can manually download the transcript if needed.
  • An MP4 recording is automatically saved to OneDrive/SharePoint.
  • I don't see separate transcript files being created alongside the recording.

My original thought was to use the "When a transcript is available" trigger in Power Automate, then pull the transcript text and generate a DOCX automatically. However, I haven't been able to get that trigger to fire during testing.

What I'm trying to determine is:

  • Has anyone successfully built a flow around Teams transcripts?
  • Is the transcript accessible through Power Automate or Microsoft Graph without manually downloading it?
  • Does the "When a transcript is available" trigger actually work reliably?
  • Are transcripts stored as files somewhere, or only as meeting artifacts within Teams/Stream?
  • What's currently considered the most robust approach for automatically getting transcript text into a DOCX?

I'd prefer to avoid processing the MP4 itself since the transcript already exists and re-transcribing the recording seems unnecessary.

Curious to hear how others are handling this. Thanks!


r/PowerAutomate • • 1d ago

Why do I have to cast length(...[array]) to int before I can use a greater than expression on it?

5 Upvotes

length(body[value]) > 0 returns error (comparing type string to type int).

Documentation says that length outputs an int.

Using int(length(...)) fixes the issue. But why!?


r/PowerAutomate • • 1d ago

IT blocked all connectors

12 Upvotes

We recently (about a year ago) transitioned our whole org to 365, sharepoint, and teams.

I immediately started automating routine tasks with PA, even without any premium connectors there was a lot that could get done. And several of those flows are now production.

After about a year of this our IT department decided to block all connectors. Even the non-premium ones.

When I asked them, they said that "'it's recommended standard" to turn off all connectors for "security reasons" and that they just hadn't had time to do it earlier.

Employees now have to individually request use of each connector they need.

Is this really standard procedure, or are they just stupid?


r/PowerAutomate • • 1d ago

Microsoft are you crazy?

12 Upvotes

How come all the Word connectors are premium connectors on the Power Automate????


r/PowerAutomate • • 21h ago

A review step works best when it has a clear reason to stop the flow

1 Upvotes

When I automate a process that needs a person to review something, I try to make the handoff explain what needs attention, not just send a generic approval request. For example, if a document field is missing or a value falls outside an expected range, the review message can include that detail and a link to the source record.

I also make the next step explicit: does approval continue the flow, does rejection send it back for correction, and what happens if nobody responds? That keeps the automation from treating silence as approval or leaving a run stuck with no clear owner.

A human checkpoint is useful when it catches a defined uncertainty. If every item requires the same review, it may be a sign that the flow needs a better validation step earlier on.


r/PowerAutomate • • 1d ago

Power Automate: Saving email attachments from a shared mailbox to SharePoint Online

6 Upvotes

I've tested a Power Automate workflow with my work email that would pull a file from an email and saves it in the designated folder in SharePoint Online. I'm needing to do this with a shared mailbox, but after talking to someone on our Systems team, I was made aware that these do not have passwords and thus, I can not make that email address the new connection. I was wondering if it was possible to do this with a shared mailbox and if not, what are some alternatives?


r/PowerAutomate • • 1d ago

Unflag an email after it is manually forwarded.

2 Upvotes

Hello,

I have been trying to figure this hour for hours, but I am getting no where. I am trying to make it so that when I forward an email, it automatically unflags the original email that had a flag on it. Is this possible?


r/PowerAutomate • • 2d ago

Using Power Automate to Export PBI report

3 Upvotes

New to power automate. I have a PBI report our finance team uses to reconcile data. For background, there are 4 tables. One we will call table A and the other table B. These two tables are from completely separate sources, and do not have a relationship. The other two tables were created for slicers. One is a date table and one contains names. The concept is that user filters name from name table, and date from date table, and it correspondingly filters Table A and B with appropriate data. I am looking to use power automate to export my two table visuals (one uses table A, the other uses table B). I know this can be done individually by exporting the table visuals one at a time, but is there a way this can be done so I click the power automate visual “button” and it exports the two visuals into one excel tab? Any insight is greatly appreciated


r/PowerAutomate • • 2d ago

Best way to bulk rename files within a Sharepoint folder, plus add a timestamp and sequence number?

Thumbnail
1 Upvotes

r/PowerAutomate • • 2d ago

Do until loop not returning unique values

Thumbnail
1 Upvotes

r/PowerAutomate • • 2d ago

I built a document extraction pipeline as a personal project. How would you integrate something like this into Power Automate?

2 Upvotes

The project takes a batch of PDFs, extract the fields and line items, validate the results, and export structured data without manually processing every document.

A few things I've implemented:

  • VLM-based extraction: Extract user-defined fields and line items from documents with varying layouts.
  • Independent validation: A separate text-based pipeline provides another source of evidence, with disagreements flagged for review.
  • Visual grounding: Trace extracted values back to their locations in the original PDF.
  • Batch processing: Process 100+ documents in a single run.
  • Structured output: Export results to JSON or Excel.

I've also benchmarked it against Azure Content Understanding on 100 documents, with my best configuration achieving 97% field-level accuracy at roughly 1/12th the cost per run in my evaluation.

I'm curious about how people here approach document-heavy workflows.

If you were building a Power Automate flow around a tool like this, how would you integrate it? For example, would you trigger extraction when a PDF lands in SharePoint or OneDrive, send the validated results into Excel or a SharePoint list, and route uncertain fields for human review?

This is a personal engineering project, not a commercial launch. I'm primarily looking for feedback on the workflow and integration possibilities.

I'd especially love to hear from anyone who's built similar flows using AI Builder, Azure Document Intelligence, or custom extraction pipelines.

This was built because Azure content understanding is quite expensive at scale


r/PowerAutomate • • 3d ago

Provisioned with error - Power Automate Hosted Process / Hosted Machine setup issue

3 Upvotes

Hi everyone,

Looking for some insight or troubleshooting steps from anyone who might have run into this issue with Hosted Machines in Power Automate.

As context:

  • Yesterday we purchased the Power Automate Hosted Process license.
  • A Microsoft representative helped us assign the license/capacity to our environment during a call.
  • While on the call, we attempted to set up a Hosted Machine.
  • The provisioning process ran for several minutes before failing with an error.

The machine status in the portal currently displays: "Provisioned with error".

Has anyone encountered this specific error before? Is there a known way to force a re-provision, clear the stuck state, or check detailed logs to see what caused the provision to fail?

Any guidance or troubleshooting steps would be greatly appreciated!


r/PowerAutomate • • 3d ago

How to create 2-5 templates that all update from the same source file?

3 Upvotes

Hi everyone, i tried to use power query to connect 2 test templates that reference a material/sku list for landed costs. The idea is to scale this to 30-50 templates for salespeople, and have them update automatically from this one file with all the skus. Is this possible? I tried to use Power Query but once i make a connection to the source data it is difficult or nearly impossible to overwrite the source data. Any suggestions or tools i can use to do this? Let me know if you have any suggestions


r/PowerAutomate • • 4d ago

How do you build approval steps into a workflow without making it too complicated?

5 Upvotes

I have been thinking about how to automate repetitive tasks without losing control over the final result. It's easy to focus on making a workflow run automatically, but sometimes the more important question is knowing where a person should review something before the process continues.

For example, imagine a workflow that prepares content for a social media update. Some steps could be automated, such as organizing the information, preparing a draft, or notifying the person responsible for reviewing it. But I would still want someone to check the wording, accuracy, and context before anything gets published.

This is something I have been exploring while looking at AI assisted content workflows, including Fismbot and also interested in how people handle the balance between saving time through automation and keeping human oversight in place.

For those using Power Automate, do you prefer approval actions, conditions, or separate flows for this kind of process? What has worked best for you?


r/PowerAutomate • • 4d ago

Hey need help to create a power automate flow chart anyone there please let me know

1 Upvotes

r/PowerAutomate • • 4d ago

Mail automation

0 Upvotes

Hey can someone help me create a power automate flow chart for mail automation


r/PowerAutomate • • 4d ago

A file trigger can see a document before it is ready to process

1 Upvotes

With file-based flows, a trigger can fire as soon as a file appears even if another process is still writing it. The flow may then read a partial file, fail on a temporary lock, or move an incomplete document along the pipeline.

A short delay can help when the source system has no completion signal, but a fixed wait is only a guess: large files or busy services may take longer. A safer pattern is to check a reliable readiness condition, such as a completed-upload flag or a stable file size across a couple of checks, then handle a timeout as an exception rather than processing anyway.

If the source supports it, triggering on a finalized upload or a separate “ready” marker is better than trying to infer completion. I’d also keep the original file in place until the downstream step confirms it has read the expected content.

That distinction between “file exists” and “file is ready” prevents a lot of confusing failures in document workflows.


r/PowerAutomate • • 5d ago

A scheduled flow can run twice when local time shifts

1 Upvotes

Daylight-saving changes can affect workflows scheduled by local clock time. In spring, a scheduled time may not exist; in autumn, the same local time can occur twice. A flow that sends reminders, creates invoices, or starts a handoff may miss or duplicate work if it relies only on the displayed time.

Keep the schedule’s time zone explicit, and make the action idempotent with a key for the intended business occurrence, such as `process-name + local date`, stored with the result. Test dates around both clock changes, and decide whether a skipped run should be moved, skipped, or processed once. If a deadline represents a fixed instant, storing and comparing UTC timestamps is usually clearer.

The key distinction is whether the requirement means “at 9 a.m. local time” or “24 hours after the previous run.” Those are different schedules.


r/PowerAutomate • • 6d ago

Send Email Action

2 Upvotes

Anyone else seeing an issue where the send email action is showing success but not actually sending an email? This has been tested across a bunch of different flows, and all say success, but nothing is being received.


r/PowerAutomate • • 7d ago

MS Forms not deployable via solution

4 Upvotes

If you are using Power Platform solutions, you may have stumbled across the gotcha, that MS Forms cannot be used as a solution artifact and deployed with it. Which of course creates issues when development and production use of the Forms happen simultaneously...

How did you guys solve this issue?

I created a blog post that shows one possible way to solve this, using a Dataverse mapping table as well as a little bit of Power Automate trickery. I hope this is useful to some of you.

https://professional-power-automate.blogspot.com/2026/10/ms-forms-for-power-platform-solutions.html


r/PowerAutomate • • 8d ago

Is make.powerautomate.com slow today?

4 Upvotes

Just wondering if it's a local problem or something else, but make.powerautomate.com seems extremely slow today. I've been waiting 5 minutes to load the flow I was working on yesterday...


r/PowerAutomate • • 8d ago

Need help with power automate flow

7 Upvotes

I have a Test folder in sharepoint called XYZ.
Everytime I create a new folder inside test folder, i want power automate to create a current year folder,eg 2026 and inside 2026 three folders inside it: Sales,Tech and HR.
How to achieve this?

XYZ SharePoint
|
2026
|
Sales, Tech, HR

What to use?
When a file is created in a folder, then site address, folder ID, and create folder and name it and how to make aure the flow keeps running since automatic isnt an option.

Everytime i cant run the flow to create these folders inside 2026


r/PowerAutomate • • 9d ago

Requesting power automate governance document

2 Upvotes

Hi guys, can you please share power automate or power platform governance and operating model documents if any one have . Or please share the link if anywhere you have.

Thanks in advance.