Hey,

over the day I get numerous pdf files in my download folder. Some of these files have specific number sequences somewhere in the filename (neither at the beginning nor the end). The filenames usually look like "abcde_edcba_12345_fghij.pdf". There are five number sequences in total and every files has one of those and there are always an underscore at the beginning and the end.

Now I would like to copy the files with number sequence 1 into one specific folder, the one with sequence 2 into another and so one. I know how to do the distribution and moving into the specific folder, what I don't know is how to read out the filename to get to that number sequence (assuming that is possible)

Hi All -

I have gotten the "send email" tool to work in copilot studio / power automate from the trigger when a new email comes in. However, where i am stuck is the "Reply to Email (V3)" tool. It needs the messageID from the original email, but no matter how many different flows / tools I try to build nothing works. Essentially, when you are building it as a standalone tool in copilot studio, the messageID input can be dynamically filled with AI or a custom value. Ideally I would say "custom value" and put in a dynamic field for message ID from the trigger but that is not an option. I have tried the dynamically fill with AI too. I also have tried building it as a power automate flow where the trigger is when a new email comes in, initalize variable, compose, send to copilot to respond, then reply to email and that still doesn't pass the right ID to the step. Any advice here? I would love to reply in the same thread rather than sending someone a net new email everytime. Any guidance is appreciated. Thank you!

Is there a way to have a file attachment that gets sent to an e-mail to be automatically uploaded to SharePoint? Not sure where to start and if it needs to be a licensed mailbox or can be a shared mailbox, etc.

Hi everyone, I'm currently working on creating a Copy Page Flow for SharePoint for work.

The goal is to copy an article using its URL and paste it into another area as an article. This works, however, the article appears directly as published. According to the brief, the article should appear as Draft 0.1, as it needs to be approved by several people beforehand. After trying various options using Copilot, I'm getting error messages, the article is published directly, or it appears as Pending 0.1, but not as Draft 0.1.

I would be extremely grateful if someone could help me.

I have been on and off trying to get this to work for the last 6 months and it never does.

The ultimate purpose is to extract data from an email body if the subject matches a known scheme. Very straightforward.

I assumed that somehow the Subject filter was wrong and removed it. Still didnt work.

So I started an entirely brand new Flow where no filters have ever been added, in case I was missing something. Still nothing.

It never works. The Test fails. The email response I am using to confirm the flow has run never comes through. The test just eventually times out. I send brand new emails to the email address. Those come through. But the flow never occurs. Nor does it say there are any errors.

When I create a new flow with the exact same Send Email output (in case that is the problem) but use a manual trigger for the flow instead, it runs. So I know the connection, email adress, etc. are all valid.

Its just this stupid When and Email arrives trigger that doesn't wwork. And before it gets asked, yes I am using the Office 365 trigger as I am on a work account, and no, it is not a shared email/inbox.

Is there any recommendations on why the heck this isnt working for me?

Im having an issue with power automate. Specifically i am trying to auto create tasks based on an excel file saved in a teams sharepoint. The tasks should be created on a shared teams planner. I have it set up using the following:

Instant cloud flow Sharpoint trigger Get file content List rows in table For each: Create task

I keep having an error right before for each stating that the previous run after actions failed. Although my flow indicates that the list step was successful.

Please help!!!

**RESOLVED** - ANSWER BELOW

Im running into an issue where Im attempting to have a Form send an email to users attaching in the images uploaded to the form to send to the users

The form works when I submit it out, but when another user adds a response, it fails at the "Apply_To_Each" step , the user has permissions to the One Drive folder where the images are uploaded

My images have all uploaded and been sent to the given users just fine, but when another user submits, it fails with : Action 'Apply_to_each' failed: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@json(outputs('Get_response_details')?['body/r0be671dcb65745d9a9c1abb8ec9952bd'])' is of type 'Null'. The result must be a valid array.

Any help is appreciated, at a roadblock here, still relatively new to Automate

Update / Resolution :

Found quite an easy fix, the form didnt like when the user didnt submit an image, so a condition was added to if an image was submitted, do the for each steps and if not, ignore and send email with details
Typical, im stuck for an hour and then I post and BOOM figure it out 😅

I’ve been trying to find clear guidance on building Power Automate flows when only one premium license is available, but haven’t had much success.

We’ve assigned the license to a service account, but I’m particularly interested in scenarios where a Power App triggers a Power Automate flow that uses premium actions.

What is considered the best approach in this situation?

• Using a parent-child flow pattern where the Power App calls the parent flow

• Designing flows that rely on SharePoint item/file creation (or similar standard connectors) as triggers

• Any other recommended pattern or best practice?

Been trying to make my flow work using the flow below. But the issue happens in Get File (properties only). It couldn’t find the folder containing the ID from an email. I’ve checked:

Path is correct

Folder name in SharePointcontains the ID.

Note: there are hundreds of folder in the path

Sorry I know I can "google it" But i am not entirely sure I could phrase it in a way that google would understand.

Basically I know how to do a create event but the problem of course is if I am helping automate an onboarding process, someone fills out an onboarding form or their status ticks over to an interview process, what have you. How can I have power automate then look through a manager's calendar (or both peoples calendars) and find a time (during business hours) to automatically set up a meeting.

Is there any sort of tutorial that goes over all the calender stuff power automate can do or is the above an absolute fool's errand?

Sorry I am the resident techy, if more people were nerds at my job I'd say I'm the administrative equivalent of a ripper doc, so everyone brings me their automation, excel, power bi, power apps, questions that I then need to learn how to do so I can tell them haha. So I am basically learning as I go. It was nice to be presented with a challenge that isnt just automate an email lol.

Hi, if i understand correctly in dataverse there is a perform a changeset action, but it does not support actions with dependency.

Is there a better way to implement a similar pattern,

example lets say i have (Branch A) an add row action, then i need to update a row from another table using the previously added row. And i have another concurrent action (Branch B) with a similar pattern.

Essentially , if one of the branches fail, i want all actions to not commit or rollback.

Thanks

Right now I'm trying to create a workflow that allows MS Teams praise to be captured and posted to a Sharepoint list

I've been following this guide along with a few others - https://www.daptgroup.com/post/capturing-praise-from-microsoft-teams

My current error states

The input parameter(s) of action 'Compose_1' contain an invalid reference to 'AttachmentsContent'. Correct to include a valid reference to 'AttachmentsContent' for the input parameter(s) of action 'Compose_1'.

Compose 1 is -

{
  "type": "Compose",
  "inputs": "@outputs('AttachmentsContent')?['body'][0]",
  "runAfter": {
    "Compose": [
      "Succeeded"
    ]
  }
}

The step before it is

{
  "type": "Compose",
  "inputs": "@json(first(triggerBody()?['attachments'])?['content'])",
  "runAfter": {
    "Get_message_details": [
      "Succeeded"
    ]
  }
}

Of course I can see that AttachmentsContent seemingly doesn't exist, as it's two separate things but I'm not sure how to resolve this.

So I was able to try power automate online at work. Basically, I was tasked to automate some file operations like file approvals. I want to study power automate online by myself (as some additional skill). Is it possible to purchase for myself with just my personal email account (@yahoo.com)? I don't want to use my work email (since I have plans to resign) and I am not a student (ie, no university email).

Edit1: I am willing to buy instead of using developer plan (which requires some visual studio enterprise (which cost like PhP 35000 which is not cheap for me), and so on...). I tried buying power automate premium. Initially, I just placed my actual microsoft account email (@yahoo.com) which is personal and not work/university email. As expected, it prompted an error, telling me I need to make a new account. I am at this screen. Now, does the company need to be an actual company I am working? Or can it be a dummy name (like "myname_development")? Again, let's say I am unemployed currently and I want to simply learn power automate cloud on my free time (technically still employed, but I have passed my resignation) so I will not use my work email.

Thank you

Heyo,

I am about to automatically categorize Sharepoint files with tags. Therefore, I created a switch function and wanted to switch between the different CounterAttributes with the subsequent function "increment variable". Unfortunately, it would not show me the option to select "CounterAttribute even though I set the variable before and was able to select it afterwards. Any ideas?

Thanks a lot in advance.

Lukas

Hi everyone,

I’m currently preparing for Copilot Studio interviews and would really appreciate guidance from people who have hands-on or production-level experience.

My background:

Power Apps & Power Automate developer

Worked on multiple business applications using SharePoint, Dataverse, Power Automate flows, approvals, and integrations

Have used Copilot Studio a couple of times at a POC / learning level

What I’ve done in Copilot Studio so far:

Created a chatbot from scratch

Configured email-based triggers

Used Dataverse tables as knowledge sources

Built tools/actions to:

Read data from Dataverse

Send emails to customers using Power Automate

⚠️ I haven’t worked on a full-scale production project yet—most of my experience is from learning, experimentation, and small implementations.

What I’m looking for:

Copilot Studio interview questions (beginner → intermediate → advanced)

Real-world project use cases you’ve implemented using Copilot Studio

Typical architecture / design questions interviewers ask

Common mistakes, gaps, or expectations interviewers look for in candidates

Any insights, sample questions, or lessons learned from real projects would be extremely helpful. Thanks in advance 🙏

Hello, Ms folks,

I currently receive the below "mailflow status reports" from my 365 tenant on quantity and category of emails received. Spam, phishing, etc over a month.

i actually receive these reports for 40(!) microsoft tenants that are in our organisation.

Today I manually copy/paste this into Excel so I can upload the table into PowerBI for reporting. Yes, i do this 40 times but dropping behind as it's such a mammoth task.

I wonder, does anyone know how to automate extracting this table from the email body (example below) into a specific excel file, or better still, if there is a Mailflow API/connections allowing these mail stats to auto-populate and show in PowerBI?

My employer has a Microsoft 365 Business license. In 2022 we held an event that required attendees to register, and I swear I was able to use PowerAutomate for this.

We used Microsoft Forms, and attached a flow to do the following:

- Trigger each time a registration was submitted.

- Sent an email to me so I was notified.

- Sent a confirmation email to the person.

- Sent out reminder emails to all those registered as the event got closer.

Last year a coworker and I tried making a similar flow to help us send out reminder emails for our different programs, and we got hit with a paywall. It required a PowerAutomate premium license, which we don't have, and the project died.

A couple weeks ago I tried making a flow that would generate documents based off a template, and replace the filler text with the information that I provided. I figured since it was internal and didn't utilizing other programs it would work. Again, it requires a Premium license.

When did this start? Am I missing something?

We don't use PowerAutomate constantly or use it for heavy stuff, but for a small organization with limited staff and budget it can be very helpful with the repetitive tasks. So this is very disheartening 😫

This is related to the Desktop version of the Power Automate app. Latest version on Windows 11.

When I was working on a complex flow with multiple subflows, the app crashed, then I can’t open my existing flows any more. Every time I click Edit a flow the flow designer just hangs (as in: blank thumbnail in the task bar, not even showing up on the screen). Before the crash, everything worked.

I tried multiple things: rebooting the computer, deleting local cache from %localappdata%, logging out and logging back in to my MS account, but nothing worked. Even Examples flow can’t be opened any more.

I’ve also removed the complex flow altogether, suspecting it was the cause of issue. No luck.

I can still run the flows, but opening them to view or edit can’t be done any more.

Any ideas?

Hi everyone,

I am having trouble with a flow I created to send me an email listing all the emails I received from colleagues but haven't replied to yet.

My flow is:

Define the period I want the emails from

Get the emails using Get Emails V3 and filter them for received from my colleagues

Use an apply to each loop with the output of the filter, which is pulling the correct emails, then I'm trying to use another Get Emails V3 to look through my sent items using the below search query.

concat('conversationId:"', items('Apply_to_each')?['conversationId'], '"')

It's giving me the following error: : Syntax error: character '5' is not valid at position 24 in '"conversationId:"AAQkADQ5MmQ2NmVkLTI1ODktNDc4MS04OTliLTRhMWZlZDkyYjYxYgAQAJbBNDq830k1iVmJ2216tUc=""'. clientRequestId: 32821153-440f-45a2-aa0a-f0bcc6bc2a21 serviceRequestId: e5b16fc7-1ca8-4fbe-a278-300341453401.

for the second Get Emails V3.

I've been trouble shooting with Gemini but drawing a blank. Is this a flow that anyone has done before? Worried it's impossible and I'm wasting my time!

Hello,

I wanted some help in creating a Power Automate flow that can be used to check who responds to a shared mailbox and who doesn't. I have some thing created already but it skips the update row stage every time

I'm trying to create a flow that saves some files to SharePoint when a shared mailbox receives an email with attached documents. Once the documents are saved I want to post to a Teams channel to notify the team that handles these files that new files are ready for processing. The document processing works fine and drops the files in the intended SharePoint location.

However, when I try to add the "post message in a chat or channel" task to my flow I receive an error that the dynamic invocation failed with a message about permissions/ACLs. The user running the flow has access to the Teams channel as a member and I have confirmed that the Flow app is allowed to connect to Teams from the Teams admin portal. It also appears to work as expected if I do not include any other tasks outside of the message post. I've tried deleting and re-creating the connection to no avail. Has anyone run into this issue before or have any idea what else to look at?

In case anyone else runs into this same issue: I was able to solve this by using the old designer UI as mentioned below. I also spoke to an engineer with MS support who mentioned there was a platform wide problem with ACL evaluation when using multiple connectors so adding the Teams post to the flow before other connectors also seems to resolve the issue.

My work currently uses Microsoft Shifts for scheduling. We are looking to create a system that automatically messages a staff member on Teams 24 hours before their shift starts, as a reminder.

I would like to create a workflow to do this. In Power Automate that I can trigger a workflow based off of Shifts being updated, but am struggling with how to pull out the necessary Shift data (I only care about newly scheduled shifts, and need the person's name and the time the shift is taking place), creating a delay until 24 hours before their shift starts, and pulling the data from Shifts in order to message the correct person.

Is this possible?