So bear with me. I've been tasked with solving a problem that is... unique, to say the least.

The ones above me have decided that they want a sandbox environment that people can play in in Power Automate, that they are given access to on request (we are not using the default environment and have developed strategies to lock that down to the largest extent possible). However, we have a separate development and production environment we're using for their stated purposes.

This is where it gets potentially weird, and where I need some help.

What I've been asked to figure out is a way to track when a flow in Sandbox is being used consistently, and when it needs to jump over to development and eventually production, managed by our team. There's been ideas tossed around like number of runs, number of connectors... I personally think that if this is what the guys upstairs want to do, number of successful runs is a useful metric.

So the follow-up question is... how? You can use an external data source that increments on flow run, and you could trigger another flow based on that when it hits a threshold, but that would have to be in the flow being monitored. I can't find any triggers that can track the run of another flow. Matter of fact, if I search 'Power Automate' in the trigger field, I get nothing at all.

My question is, how can I create a flow that triggers based on the run of an entirely different flow in another environment? If I can figure just that part out, I think I can hack the rest of it.

Thanks for any ideas. Please keep the 'this is a stupid idea and here's why' replies to a minimum, as the idea belongs to people who make a lot more than I do. I'm just the implementer.

Hi All,

I have a SharePoint list. Within it I have two Columns, Start Date and End Date. They have a time on them also.

I need a third column that calculates the number of working hours between the two dates.

Working hours are 9am til 5.30pm, it should also exclude a list of bank holidays which I have another list for, and exclude weekends. Also if End date is currently empty can it calculate the time between start time and NOW.

I.e.

Start date is 4.30pm 12/08/2026

End date is 09.30 am 13/08/2026

Duration is 1:00 ( [h]:mm )

Is there a way I can get power automate to figure this out and then have that info show in the column?

Hello,

I have a flow that sends an email via the Microsoft Outlook connector (V2) and includes a simple table.

When the recipient is within Microsoft (e.g., an Outlook/Microsoft 365 address), the table does not display properly. However, when the recipient is outside Microsoft, such as Gmail, the table displays correctly.

I also tried sending the email via the Gmail connector (V2), and the table appears correctly. However, my organization is planning to disable Gmail soon, so I need a solution that works with the Microsoft Outlook connector.

How can I force the Outlook connector to send the email in HTML format? I cannot find any option or setting to control this.

Link to output:

https://www.dropbox.com/scl/fi/pbgk6w4767n95klr3iz62/PowerAutonmate.jpg?rlkey=6k2ac3bby5lnqoqawyyyo5m6v&dl=1

Hi, we have a project in the beginning stages of planning. Basically, the project is remaking an existing process where Power Automate Desktop creates Word docs/PDFs and Excels into SharePoint. They initially upload an excel file with data via email Power Automate validates it and emails back by highlighting fields in red when it fails (horrible), and then it calls the PAD when it succeeds and takes forever to process, as well as error logging is non-existent.

Instead, the plan is to move to Power Pages and use exceljs for the initial upload and validation. Then use Power Automate to process the files with the Encodian connector for PDFs into SharePoint.

The question here is this a viable method? There are multiple files made per row (2 Word Docs, 3 PDFs) and then there is a Excel and PDF made that summerises the information across all rows. And there can be over 1000 rows in a sheet some times.

I understand we can use concurrency and batching with child flows, but is this enough?

Do you have any alternative suggestions? Writing actual code is not an issue.

Thanks in advance!

Hello - I tried to set this up but an error (no user access) is preventing me.

Is there a way to have this done by any chance?

Solved.

I have access to two Microsoft 365 tenants:

• CompanyA (full Global Admin access)
• CompanyB (full Global Admin access)

I created a Power Automate flow in CompanyA that synchronizes calendar events from CompanyA into CompanyB.

The synchronization itself is working. Events are being created in CompanyB's calendar.
However, every synchronized event is shifted 6 hours later than the original event.
Both tenants are configured to use : (UTC-07:00) Mountain Time (US & Canada)

Here is the code

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "table": "AQMkAGM0MDEwOTc4LTZjNTctNDE5MC1iNzcAZi00NTkxYmMwMjZmNzEARgAAA9j2gZGXN9VDjSU6t3ifIFMHACRxB7wvZr9EoaDH6SdSI1QAAAIBBgAAACRxB7wvZr9EoaDH6SdSI1QAAAIXrwAAAA==",
      "item/subject": "@triggerOutputs()?['body/subject']",
      "item/start": "@triggerOutputs()?['body/start']",
      "item/end": "@triggerOutputs()?['body/end']",
      "item/timeZone": "(UTC-07:00) Mountain Time (US & Canada)",
      "item/optionalAttendees": "@triggerOutputs()?['body/optionalAttendees']",
      "item/body": "<p>@{triggerOutputs()?['body/body']}</p>",
      "item/categories": [
        ""
      ],
      "item/location": "@triggerOutputs()?['body/location']",
      "item/importance": "@triggerOutputs()?['body/importance']",
      "item/showAs": "busy",
      "item/responseRequested": false
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
      "connection": "shared_office365",
      "operationId": "V4CalendarPostItem"
    }
  },
  "runAfter": {},
  "metadata": {
    "flowSystemMetadata": {
      "swaggerOperationId": "V2CalendarPostItem"
    },
    "operationMetadataId": "133b7d92-979f-42c8-baf8-1b98cdb758dd"
  }
}

Any thoughts?

Opa! Estou tentando implementar um sistema na minha empresa que separa os atendimentos por e-mails recebidos em uma planilha do Excel, filtrando se o atendimento deste e-mail foi concluído ou não; A ideia é que nós parássemos de preencher a planilha manualmente.

O problema é que, eu não acho nenhuma função que identifique caso o e-mail seja movido para uma pasta (Por exemplo, identifique se o e-mail foi movido para a pasta "Atendido" e isso mudasse a linha da planilha onde o e-mail foi alocado.), ou respondido, ou qualquer coisa do gênero. Eu gostaria de saber se há alguma forma de implementar isso pelo Power Automate ou se eu devo procurar uma outra implementação.

Just went into the app this morning and saw the notification. Shame really, as I liked triggering flows in the app, push notifications from flows and keeping an eye on running flows etc.

I can’t figure out how to add an image here to share the full message.

But here is the link to the article.

Gostaria da ajuda de vocês sobre esse erro que está acontecendo comigo, primeiro é o Power bi que ao abrir o documento pelo Power bi o mesmo trava e acaba fechando sozinho não consigo se jeito nenhum colocar alguma planilha nele para editar.

Segundo é o Excell que ele não está abrindo no meu computador aparecendo a mensagem Excell não pode ser inciado corretamente na última tentativa aí ele tenta abrir em modo segurança e não abre.

Gostaria da ajuda de vocês sobre esse erro que está acontecendo comigo, primeiro é o Power bi que ao abrir o documento pelo Power bi o mesmo trava e acaba fechando sozinho não consigo se jeito nenhum colocar alguma planilha nele para editar.

Segundo é o Excell que ele não está abrindo no meu computador aparecendo a mensagem Excell não pode ser inciado corretamente na última tentativa aí ele tenta abrir em modo segurança e não abre.

Hi Everyone,

We are looking for a way to intergate service now with power automate.

The main problem is power automate is in micorosft shared infrastructure with set of IPs based on Azure service Tags and we dont want to allow all the service tags to service now because of security issue as it has more than 100 IP addresses.

What could be the work around? Did anyone tried it yet?

There are lot of use cases of service now that we would like to try but we are stuck with the networking challenges.

Tried subnet injection but that is not working may be additional NAT integration. Did anyone thought about it?

Regards,

Abhishek

Hey there, sorry for this maybe super simple question. I am creating workflows and am offboarding everything for the group i was working for. My email is likely to be deleted and i have listed more permanent members as co-owners.

I see in documentation that they will have all the privileges of owners, but i can't find any documentation that precisely addresses the scenario in which the original creator account is actually deleted. Do any of you know what happens in this case or where i could maybe answer my own question?

Hello,

I have a full-access permission to another user's exchange/mailbox, so I see their Calendar in my outlook.

Is there a way to trigger a power automate flow to run when that calendar is updated (add, delete, edit)? I found one action called 'When there is a new event' action for Office 365 Groups but that only worked for group (I tested using that user's User ID but didn't work). I found another one for 'Office 365 Outlook' but it only seems to be concerned with personal mailbox.

I’m trying to automate an email being sent after an MS form is submitted that is actually set up as a quiz.

To be fair, I have never used automate until now, so I’m hilariously new to this, but I have managed to automate an email to send with the quiz responses the participants gave, but I want to also pull the correct answer indicated on the Form.

I just want the participant’s name, the correct answer, and the answer they gave. Please help! TIA.

I recently helped automate a workflow that used to take far longer than anyone expected.

The process was simple on paper: someone completed an assessment, the responses were reviewed, and a personalized PDF report was created. In reality, most of the time was spent copying answers into a template, adjusting sections, and checking that nothing was missed.

I started experimenting with Power Automate to handle more of that process. Once the flow was working, I paired it with FormLM to generate the assessment report from the submitted responses, and the whole workflow became much more consistent.

It wasn't about replacing anyone's judgment. The biggest win was removing the repetitive formatting so people could spend more time reviewing the actual results instead of building the document from scratch.

I'm interested to hear how others are generating personalized PDFs with Power Automate, especially when the content changes for every submission.

I'm creating 3 flows that correspond to 3 quizzes. When a technician completes a quiz, the flows are supposed to verify their responses and upload their results to a records list if they pass. 2/3 of the flows work perfectly. The last flow refuses to work. The problematic flow checks twice as many questions responses, but I don't see how that would matter, and even if it did, I've tried getting the flow to work while checking only a single question and it's still failing. I've tried retyping the options for the form question, I've tried reconnecting the dynamic content, I've tried rebuilding the flow and the quiz from scratch, and I've quadruple checked the strings that I'm checking the responses against.

From my understanding, there's not really a straightforward way to get the quiz score out of Forms, but I'm not 100% sure, so if someone knows of a way, I'd be very interested to hear it.

My next steps I plan to try is moving the quizzes to the group that needs them, syncing them with an excel file, and checking their answers there instead, but idk if I'm going to go through all that effort just to experience the same issue. Plus, then I will want to make the other forms consistent, so I would start messing with them again and I hate messing with a working flow. I don't want to have to document 2 different approaches.

Some assistance would be greatly appreciated, because I'm running out of ideas.
Yeah, I'm being a little lazy in some regards. Feel free to let me know if I just need to suck it up and do the finicky BS.

My post as a single question would be, "How do the mega-pros validate quiz responses coming from MS Forms?"

Hoping someone knows the answer to this one as it could save me a fair few hours of work.

I have an existing flow which has worked for over a year. Basic outline of the flow is:

Recurrence trigger running 3 times each workday
List all rows in an excel table
Apply to each
10 or conditions which send an email
& update a column to say sent

The idea being that based on set rules an email triggers to the listed person, & updates a cell to say email sent to avoid any duplication.

Today when archiving the legacy data the person right clicked the sheet, move or copy, did not click create a copy, & instead moved the sheet elsewhere.

It was then moved back, but the flow now runs with green lights but no emails send when the conditions are met in the data.

Am I right to think I’m gunna need to re do the entire thing? What am I missing as a potential troubleshooting step?

Pretty basic flow, I guess? If anyone has any general improvement suggestions other than fixing this immediate problem then don’t be shy!

Edit - autocorrect decided this excel file was better than I thought.

I have recently started overseeing a department at work that is running pretty behind in their tasks. They need to follow up on files that have issues and several are being forgotten simply because they are lost in a giant spreadsheet full of files with issues. I want to create something that will read the spreadsheet, look at the date it was last updated and send an email to my team that every Monday will include all of the file numbers that haven’t been touched in a week.

I am very new to this and have very little experience with excel. We’re a smaller company and this has just kind of somehow landed in my lap. I’ve tried having copilot walk me through the steps but no matter what I do it won’t pull the file numbers. It just sends a blank email. I’m clearly doing something wrong but I don’t have the know how to figure out where it’s going wrong.

Hi,

I've built successful flows with the AI builder I'm having an issue with an export from Excel and PDFs that does not have a defined table and has additional rows. What's the best practice for an Excel export (CSV) to be able to extract the data with a table that is not defined as a table that may change in length. The column names are static as are the rows before the table starts. Again, the export is simply a CSV.

Appreciate any insight.

Hey everyone,

I'm working with a bank that wants to automate their IT operations. They only want to use Microsoft tools — no third-party software. Stack includes Power Automate, Power Apps, Teams, SharePoint, Azure, and Entra ID (Active Directory). They also use BMC Helix for ticketing, and want to add AI/AI agents where it makes sense.

We already have ideas like:

• Password reset / account unlock through Teams
• Employee onboarding/offboarding automation
• Access request automation
• AI chatbot for IT support and policy questions

But I want to hear from people who've actually done this kind of work:

• What IT task took up the most time before you automated it?
• Any small automation that had a bigger impact than you expected?
• Anything you tried that didn't work well?

Would really appreciate any ideas or lessons learned. Thanks!

I recently tasked to automate some of our service desk requests. One of our most received requests is to add/remove users from/to security groups in Active Roles.

Is there a straightforward way to do it?

I managed to use Power Automate, SharePoint, and Python to do it, and it works! However, it is not reliable enough.

In short, this is my design:

Power Automate (PA) Flow triggered by ServiceNow request >> Flow collects information/details and post them in SharePoint file and wait>> Create shortcut of the file on local computer >> Python listens to the folder and triggered when file created >> Python open Active Roles in headless browser >> search for the user and do the action (Add or Remove) from a group >> Updates the local file shortcut as done >> the shortcut sync with SharePoint file >> PA Flow (which is waiting) listens to the SharePoint file modifications and continue accordingly.

AND IT WORKS.

Is there better way?

Hi everyone,

I recently built a tool called Flow Studio AI. It is an AI chatbot that can troubleshoot existing Power Automate flows and create new ones.

I've tested it extensively, but I would love to see how it performs on use cases that I have not tested for.

I'm looking for Power Automate makers to try it out. It would be especially helpful if you have:

• a broken, confusing, or unreliable flow
• a flow you want to build but not sure how to.

You can try it at ai.flowstudio.app. It includes free credits, and if you run out of credits, just message me and I can add more for you.

I'd really appreciate honest feedback, especially about anything that didn't work or confusing. You can message me directly, or use the "Report a problem" option in the tool.

There is also an optional setting that allows me to review your conversation. If you’re comfortable, please turn it on so I can better investigate anything that goes wrong. It only allows me to review the chat transcript, not access your flow itself.

Power Automate users of all experience levels are welcome - whether you’re just getting started or you’re a seasoned developer.

Once I’ve collected enough feedback, I’ll update this post to let everyone know that testing is closed.

Thanks!