Hey everyone,

I run a small YouTube channel called Automate M365 where I focus on making straight-to-the-point, step-by-step Power Automate tutorials. No fluff or long intros, just diving into the actual logic because I know how annoying it is to sit through a 10-minute video just to find a quick expression fix.

I want to build some tutorials around automation, but instead of just guessing what to make next, I want to solve real-world headaches.

Whether it's setting up automated deadline remidners based on dates in your SP lists or Excel sheets, sending dynamic emails to people pulled directly from a person column, or trying to manage folder permissions via HTTP actions—what’s driving you crazy right now? Drop it in the comments below. I’ll honestly try to look through them and build the exact solution in a step-by-step video for you.

If you want to check out the channel or subscribe to see if I build your fix, the link is here:

https://www.youtube.com/@AutomateM365

Let me know what you're stuck on, hopefully we can figure it out.

Hello everyone, i need help to finish my flow.

I add every new response to my ToDo liste, but i would like to add the whole new row to the note section on ToDo, is it possible, if yes how?

Olá a todos,

Gostaria de perceber se alguém enfrentou este cenário em ambiente empresarial e qual foi a solução adotada.

Temos uma Shared Mailbox utilizada para automação através do Power Automate Cloud.

O problema é que alguns emails chegam protegidos por Microsoft Purview Message Encryption (OME) / Rights Management (IRM). Os utilizadores autorizados conseguem abrir e ler normalmente essas mensagens no Outlook, mas quando o Power Automate utiliza ações como:

• When a new email arrives in a shared mailbox (V2)
• Get email (V3)

o campo Body não contém o conteúdo real da mensagem.

Como consequência, torna-se impossível processar o corpo do email através de ações como Html to Text, extração de dados, classificação automática, integração com sistemas externos, etc.

O que me deixa com dúvidas é o seguinte:

• Se a conta utilizada na ligação do Power Automate tem permissões sobre a Shared Mailbox;
• E se essa mesma conta ou utilizador consegue visualizar o conteúdo da mensagem no Outlook.

Então, porque é que o conector do Exchange Online não consegue disponibilizar esse conteúdo ao Power Automate? Ok, esta foi a pergunta inicial, porque das leituras feitas percebi que os conectores em causa têm problemas/limitações a lidar com a lidar com o corpo destes emails.

Assim deixo, as minhas perguntas para quem já passou por situação similar:

1. Foi necessário alterar políticas Purview/IRM?
2. Criaram exceções para mailboxes técnicas?
3. Acabaram por recorrer a Graph API, Power Automate Desktop ou outras abordagens/alterativas?

O meu objetivo é perceber quais foram as arquiteturas ou boas práticas adotadas nas vossas organizações para automatizar o processamento para emails protegidos.

Obrigado!

For incremental pipelines, how do you verify that only the expected new/updated records are loaded without missing records or creating duplicates?

What validation checks do you normally perform after each incremental load?

So i recently created a flow (which works):

-Trigger: When a new email arrives
-Create and extract excel file
-runs script
-list rows present in a table
-get items

And put the info in a sharepoint list
And so on

-what my client wants now is, if there are products with diffrent name and same ID, put them together in a sharepoint list.
For example
Product A
Name: Apples
Id: 2

Product B
Name: Banana
Id: 2

Then Apple+Banana

Hi everyone,

I’m building a Power Automate flow to automate an ECR (Engineering Change Request) approval process.

The flow starts when an ECR Excel file is uploaded to SharePoint. It checks whether the file is an Excel file, reads the Excel data, parses it as JSON, checks the document version, checks for duplicates, creates an in-process Excel file, converts files to PDF when needed, and then sends approval requests to four departments: Electrical, Assembly, Machining, and Design.

Each approval result is stored in variables such as ElectricalApproval, AssemblyApproval, MachiningApproval, and DesignApproval. After the approvals, the flow runs Office Scripts to update the Excel workbook, creates the final file, extracts information from it, updates SharePoint properties, sends notifications, and cleans up temporary files.
The part I’m currently stuck on is an Office Script called ECRv8_Json_To_Excel_Table.osts.
The script expects a parameter defined as param: Test[][], where each Test object has these six properties:

Completion date
Outcome
Approval ID
Responder Mail
Responder Name
Responder Comments

The script creates an Excel table with those same six columns and then uses table.addRows() to insert the data. In Power Automate, I have a variable called Table Comments Values, which is an Array. I also have four Compose actions that build the approval information. I use a Compose called Compose table final, which currently uses createArray(variables('Table Comments Values')), and I pass the output of that Compose into the param of the Office Script.

I have already fixed some previous issues involving Strings vs Arrays and incorrect array nesting. Now the script actually runs, but it fails at table.addRows() with this error:

“Office JS error: Line 41: Table addRows: The number of rows or columns in the input array doesn't match the size or dimensions of the range.”

The data is supposed to look like an array containing approval objects, with six properties per object. I’m trying to figure out whether the problem is the structure of Table Comments Values, the createArray() step, or the way the objects are being built before they are passed into the script.
Any advice on the correct structure Power Automate should send to an Office Script parameter defined as Test[][] would be greatly appreciated.

I currently have a flow that works well, but I need help with the final steps.

I created a process for collecting candidate references via Forms. The responses update on a Sharepoint List and are tracked for 3 responses for the same candidate. When 3 references are submitted an HTML table is created to compile the responses and email them to the hiring manager. This is all working well so far. What I need help with is compiling the responses in an easier to read format. I built this whole flow with help from Copilot, so please explain any ideas like I am five.

It may be that my HTML table is formatted incorrectly and I need to start there. There are about 35 questions on the survey and some responses can be long. The table now is wide which requires scrolling sideways for a long time and isn’t easy to read. Any other ideas you can think of? Here’s more info:

• I don’t have a premium account through work. Some options to create a document aren’t available to me.

• I can’t give access to my Sharepoint List to all the hiring managers to protect confidentiality.

• We have a bunch of different departments and hiring managers, so making separate lists for each department would be a headache.

• It didn’t occur to me until just now to change the format of the html table so that the questions on the y axis and the responses on the x. I guess it could make more sense to scroll down vs sideways.

Again, any other ideas you have that I might be missing or over thinking are appreciated!

When I googled this scenario, it told me it was possible but I have not figured out a way for this to work. It also doesn't help that I'm an extreme beginner with automation.

I have created a Microsoft Form where all fields are text entries except for the optional picture upload.

Ideally, I need to export the responses and have it in a format that allows the pictures to be embedded and not the URL that appears in Excel.

It's not feasible to go through, download each picture, put it in a Word template with the text responses, and then save it in Word or as a PDF.

Any suggestions?? Or am I just crazy that I think there an automation that can help with this.

So I am trying to convert some excel stuff to sharepoint lists.
And part of it was moving dates over, but the original microsoft form has a branching question, if they choose yess it asks for a date of birth if they choose no it doesnt.

So I get an error something to the effect of expects string/date but got ""

Aside from a condition how would I deal with this?

Edit: Thank you everyone for all the help! I took bits and pieces of the advice here and managed to get it to work somewhat. There were a lot of suggestions for power query, but I just couldn't get it to work reliably with the specific conditions I had. I'll definitely look into seeing if I can optimise future stuff for it though after going through a few tutorials.

If anyone is interested in the fix:
My original script for writing the 30k rows had a resize table function which i took out and replaced with a fixed table size of 50k rows in order to cut down on processing time. I also removed the condition since I realised I could write the condition itself into one of the earlier scripts. I also figured out that the run script actions had a a 30-60s extra run time when trying to test to flow in the afternoon due to the amount of traffic on the sharepoint site. That pushed the run script action times to over 2mins, causing the stalls. The flows ran smooth and quick when testing it during the actual time the trigger will run (midnight).

Any help will be appreciated at this point because I feel like I've tried everything I could but the power automate flow doesn't work.

I am trying to automate a daily update of a file that uses multiple other source files. The office scripts used run fine individually on their own for both batch writing and a single copy when I am manually testing them on an open sample file with a small (200 row) set rather than through the flow with the whole original dataset. Most of the flow works, right up until I need it to copy over over 30000 rows of data over 14 columns from one workbook into a set table in the master reporting file. I've tried a single batch copy, but the script will then time out in power automate due to it taking over 2 minutes. When a try copying in multiple batches, the flow stalls at the do until loop no matter how small I make the batches. Is there any way I can reliably copy the rows I need without the flow taking an extremely long time as manually copying it only takes between 2-5 minutes.

I built the flow like this due to not having a premium license for power automate and company DLP policies stopping me from using HTTP triggers directly.

Parent Flow: Images 1-3
Child Flow: Image 4

I can provide the office scripts used for steps Run script 3B,E,F and 4 in the comments below if necessary.

Hello,

I'm familiar with Flows but pretty new to coding adaptive cards. I'm trying to code an adaptive card so that when long design requests from Microsoft Forms are received by email they are posted in a Teams channel. That part is easy, where I'm struggling is figuring out how to make them collapsible/expandable to keep the channel clean.

I finally thought I had it all figured out after pasting my code in a JSON reviewer and having no more errors (dang trailing commas) but there is no button/toggle visibility showing in the previewer.

Any help with the below code would be super appreciated.

{
  "$schema": "http://adaptivecards.io",
  "type": "AdaptiveCard",
  "version": "1.5",
  "body": [
    {
      "type": "Container",
      "style": "emphasis",
      "items": [
        {
          "type": "TextBlock",
          "text": "New Design Request",
          "weight": "Bolder",
          "size": "Medium",
          "wrap": true
        }
      ]
    },
    {
      "type": "FactSet",
      "id": "expandableContent",
      "isVisible": false,
      "facts": [
        {
          "title": "From:",
          "value": "@{triggerOutputs()?['body/from']}"
        },
        {
          "title": "Subject:",
          "value": "@{triggerOutputs()?['body/subject']}"
        },
        {
          "type": "Body",
          "text": "@{triggerOutputs()?['body/body']}"
        }
      ]
    },
    {
      "actions": [
        {
          "type": "Action.ToggleVisibility",
          "title": "Show/Hide Details",
          "targetElements": [
            "expandableContent"
          ]
        }
      ]
    }
  ]
}

I am trying to test something for an automated system where I could do this:

1. An image with a company letterhead background
2. A list of names
3. A static text on the image
4. send them as an email.

So basically I want to embed text on image and send it through email. I've tried through html code but the design doesn't remain same for mobile and web. I was hoping if I could create a new image for each name in the list without using premium connectors or PA desktop.

So here is the weird issue.

I have a team telling me they need help automating, cleaning up, and organizing an onboarding tracker.

But of course everyone wants something different.

The people that do the onboarding want to focus on making a sharepoint list that works, doesnt crash(like excel), and automates tasks like sending emails and such.

Their boss, wants a sharepoint list specifically so outside people can view and see their status.

Now how I did this on my project was I have a sharepoint list for my use, then a power bi dashboard for external viewing, this allowed me to cut out what I dont want people to see, be it personal information or sausage casings(so to speak)

Their boss however is hyper focused on the sharepoint list.

The team that showed their sharepoint list does it one specific way I am not sure I understand.

Basically the hide the columns they dont need so the onboarding team uses edit to see all the columns instead of using edit in grid view and everyone else just has a view only link. But I am not entirely sure how to do this properly.

I worry that while this would work, wouldnt be as secure as it could be.

I can use just about anything, I have access to power automate, power apps, power bi, etc.

So I cam here to brain storm ways I could have an external facing tracker that people can see onboarding statuses without PII.

I already created a tracker on the onboarding teams site, there is a second site that is for external use as well.

So far my plans

A) Do what their boss wants and figure out a way to hide the PII and pray someone doesnt accidentally unhide it.

B)I made a test power app that displays all the names on the left you click on or search a name to find out details on a pain on the right.

C)Make a dashboard like I did for my team

D) Use power automate to feed any new entries into both trackers and then create a second power automate that updates the external tracker whenever the private tracker is updated.

So I came to you guys to brains storm which would be best.

I technically already have B and just need some tweaks before I can show it.
I mostly no how to make C (will have to rejog my memory on certain bits.

A and D I might need help in how to do it though D I am decently knowledgeable about automate so I know I can do it just might need advice on how.

Repost to another community

I'm new to power automate, struggling to build effective logic please help me with below requirements

I have a excel file(not in table format) on a sharepoint folder
I daily update it and download it removie unnecessary/confidential sheets and columns and send it to concerned team.

I want to build an automate flow which get the file and then edit it like i want and send the edited version of excel file from outlook mail. whereas original file must be unchanged

I tried some flow
1. made another file use powerquery to fetch data(only required) and send but the issue is it becomes tabular and formatting is also removed and size of the file also increased.

1. make a copy on a sharepoint file edit it send and delete BUT in this flow everyday one file is created and deleted which is unsustainable solution I consider.
   

If anyone can please tell me a effective flow

I'm trying to get the error of the Parse JSON inside a loop and it just send failed status with no error message. I checked the raw outputs and yep there's the error message. I just can't get it outside the loop.

Sadly I cant update the microsoft form and remove the question no matter how redundent it feels.

I was basically asked to make it so the form feeds into a sharepoint list, easy right?
One hitch.
One and only one response askes for a "projected start date"

How the form works

1. What is your role? choose from a list, if you choose contractor it branches to

2. Contractor type? B puts you back on the same path as the roles above, A asks your projected start date then puts you back on the same path.

Eventually everyone gets asked for a start and end date later again as well.

So of course all of my tests failed so far for the error " field_6 should be type string/date. the runtime value "" is not string/date

If I use a condition that means every time they make a change to the form I will need to edit two Create item steps.

I could just bipass it and make it do start date no matter what but of course there is a chance it is different and that causes problems.

Is there a way I can use compose or some other option that basically says if projected start date returns "" use Start Date instead?

Hello,

I’m creating a Power Automate flow and have imported it as a solution so that it can be shared with someone else and used in the same way.

However, when the solution is imported by another user, the flow fails before it even starts. The error occurs on the “When a new email arrives” trigger:

“Mailbox move in progress. Try again later. Cross Server access is not allowed for mailbox…”

Are there any ways to resolve this error, or alternative methods for sharing a Power Automate flow with another user while ensuring that the email trigger works correctly?

Thanks for your help.Operation: Create; Exception: [Status Code: ServiceUnavailable; Reason: Mailbox move in progress. Try again later., Cross Server access is not allowed for mailbox 4bb66193-b11a-49ce-8f73-23bbeff13104] clientRequestId: a23c986e-1e92-4dee-bc30-f25471a3cb27 serviceRequestId: 6010a8fc-3999-44ce-b7e4-c8526a5ac517

Hi all, I'm working on a proposal/concept to digitize a ordering workflow that currently is all paper based. We are migrating a lot of things to sharepoint and currently are using some other workflows to automate some tasks.

Im hitting a wall with my current project. Not an actual wall, I mean this will still work, but this just visually looks ridiculous to me. Is there no better way to do if-this-then-that conditions in power automate? I know its just a simplified JSON environment. Ive tried hunting through the actions and nothing seems to be as particular as I want it to be.

In this flow I am receiving inputs from a Forms response and generating a task in Planner via the responses. The workflow on our end depending on the sale type is different since there are different steps for each.

Does anyone have a better suggestion to get to the same end goal without having to nest so many conditions? I'm assuming its adding time to the flow (probably a negligible, but still)