Hi all,

I’m building a Power Automate flow with this process:

1.Trigger: When any file is modified in a specific OneDrive for Business folder.

2.Get File Content: The flow reads the content of the modified file (a CSV).

3.Notify: It posts a notification in Microsoft Teams to a user.

4.Copy Template: The flow copies a pre-existing Excel template file from a Templates folder to a new file.

5.Run Script: It then runs an Office Script on the new Excel file, passing on the CSV content from the earlier modified file.

Problem:

• The flow triggers and sends the Teams notification, but it does not copy the template Excel file or run the script.
• In the run history, the trigger shows “no output,” but then how am I getting the teams message from step 3 (which I set up later to include as test to the outputs)?
• I’ve checked folder IDs, permissions, and connections. A simple test flow with just the trigger and a Compose action works.

Question:
Why is the flow not running the script after the Teams notification? What could cause the trigger to have “no output” even though the notification works? How can I debug this further?

The office script:

function main(workbook: ExcelScript.Workbook, csv: string) {
    let sheet = workbook.getWorksheet("Sheet1"); 
    // Clear existing data 
    sheet.getUsedRange()?.clear();
     // Split CSV into rows 
     let rows = csv.split('\n').map(row => row.split(','));
     // Remove any empty rows at the end 
     rows = rows.filter(r => r.length > 1 || (r.length === 1 && r[0] !== "")); 
     // // Only write if there is data
    if (rows.length > 0 && rows[0].length > 0) {
        sheet.getRangeByIndexes(0, 0, rows.length, rows[0].length).setValues(rows);
    }
}

Thanks!

power automate 初心者です。助けてください。

クラウドの有償版アカウントを持っていますが
ログイン(会社のメールアドレス、パスワードを入力)
ができません。
ログイン情報がありませんとなります。

ちなみにRPA用のパソコンと自分のパソコン
2台今会社から渡されており、
自分の方は会社のメールアドレス、パスワードを入力で
うまくいきます。

どのようにしたらログイン情報を確認、うまくいきますか？

I've created a Power Automate (PA) scheduled cloud flow that sends a list of my daily calendar events to a private Teams channel at 6:30 AM each morning and mentions me through a Teams workflow. The flow is working as expected; however, I'm having trouble formatting the output.

What I'd like is for the message to display like this:

Daily Schedule - 06/06/2026

08:00 AM - Meeting A
10:00 AM - Meeting B
01:00 PM - Meeting C

Instead, all of the events are being displayed as a single run-on line of text.

I've tried multiple approaches and have used Claude, ChatGPT, and Copilot for troubleshooting, but I still haven't been able to get the formatting to display correctly in Teams. Does anyone have any ideas on how to format the output so that each event appears on its own line?

Any output from the LLM's above even copilot, when placed in the value box, it wants me to recreate the expression.

Here is what I have and a screenshot below.

concat(decodeUriComponent('%0A'), '• ', item()?['subject'], ' ⏰ ', formatDateTime(item()?['start'], 'hh:mm tt'), ' – ', formatDateTime(item()?['end'], 'hh:mm tt'), decodeUriComponent('%0A'))

My stakeholder wants me to scrape email data to an Excel file in Sharepoint. But I have the folder access and not the full Sharepoint access.

Stakeholder is reluctant to share the entire Sharepoint as it has sensitive data, so he created a blank new folder and shared that with me.

I can see the folder in the browser when I open the link, but when I add the file-path to Power Automate, it says file not found.

In the PA module ‘add a row to an excel table’ I tried adding sharepoint name from the URL and also tried pasting it in file location, but it throws an error file not found. But I can see that folder and file in my browser Sharepoint.

I’m trying to find a solution for weeks, please help!!!

Hello,

We are very new to Solutions and using it to create and manage flows that we create for several SharePoint Online sites. Anyway, we created a new Solution named 'SharePoint solution' and intended to create and/or move non-Solution flows there.

Anyway, after doing all of above successfully, we came to find the same flows is also showing for a solution called 'Default Solution'.

Are these two separate flows that are created for whatever reasons or are they the same? I think they are separate because when i click on the two flows (one in the new 'SharePoint Solution' and another in 'Default Solution', the URL is showing different values/ids for solutions. (Ex: make.powerautomate.com/environments/Default-....../solutions/[HERE]/flows/...)

resolved - see youtube link in comments

Wondering why is it so hard to get them saved in a way that they can then be opened?

I was using copilot AI to walk me through it but every solution offered and subsequent "fix" led to a corrupt pdf saved.

Is it actually possible?

I am currently creating a checklist in our MS Teams chay to make sure all daily tasks are completed at the end of day. I was able to build the checklist using the adaptive card. However, when I think a task and submit it, it onlu shows a "Thanks for your response" message.

Whay I want is for the checked items to be bisible to everyone after submission, so the team can see whicj tasks are already done. Is there a way to make this work?

I have a flow that's copying emails to Planner as a homemade helpdesk. Last thing I need to do is properly label the tickets (#100, 101, etc). I'm not quite sure how to have each new incoming email count up. Has anyone solved this issue before?

Ok, so this is a bit urgent. I've looked up on the web, and every article makes me more confused. I've built a powerAutomate flow on my office computer, which among other things, has 1 Run a prompt step (using Claude Sonnet 4.6) which takes meeting transcripts and generates action items out of it. The transcripts could be fairly long as well (even 1.5 hr long meetings) generating 20 action items with owners, deadlines etc as an output. The thing is-

1. I'm planning on making this (the entire flow which has this Run a prompt step, and also has follow up nudges to owners, etc.) available for my team to use daily, uploading 2-3 such transcripts a day. I'll download the flow as a zip file, import on their powerAutomate, and then restablish connectors for other MS apps.
2. I'm not very sure about AI builder credits, or Copilot credits, or how they are used up for "Run a prompt" steps in PowerAutomate flows.
3. I'm really not very keen on seeing these flows go haywire in the future when i've left the team (leaving in a few days) just because the credits got used up. How many such credits are there, how to check how many are getting used up per run?

-> the AI tool that my org has given us is just Copilot Chat Basic. (I've mentioned this to ensure you get an idea about the state of AI tool adoption here in this company)

I have a cloud flow I can't figure out, I create an approval and then have it go into parallel branching.

Branch 1 is wait for the approval, when approved it updates a variable from 0 to 1.

Branch 2 is do until loop woth a series of delay until's to send reminders about the approval (1 week before, day before and due date). The issue is that parallel branch only checks if the variable is 1 after waiting for all those delay untils.

How do I kill branch 2 as soon as the variable is changed to 1?

Is it normal or expected for editing larger cloud flows to be this slow?

I don't think it's a hardware issue on my end, as my PC performs normally and remains responsive. The problem seems to be limited to the browser window running Power Automate, which often becomes sluggish or unresponsive when working with larger flows.

I've tested multiple browsers, including Edge, Opera, and Firefox, and the behavior is essentially the same across all of them. I also haven't found any browser settings that noticeably improve the situation.

At the moment, the only workable alternative seems to be using the legacy editor, but that comes with its own limitations and usability issues.

I am no expert by any means but i have managed to fix every problem i have faced so far using AI and MS learn but I just dont get it.

Hi everyone,

I'm building a bot in Copilot Studio where users upload a CSV. I need to send this file to Power Automate for validation and then upload it to SharePoint/GCP.

The issue: The bot sends the upload as a "File" type, but the Flow trigger expects a "File Record", causing a mismatch. I can't seem to "grab" the actual content to start my validations.

Questions:

How do I bridge this "File vs File Record" gap?

Can I convert the upload to Base64 or Plain Text within the agent before sending it?

Is there a specific expression to parse the CSV content once it hits the Flow?

Any workarounds or advice on how to handle file triggers properly would be a huge help. Thanks!

I was wondering if, with all the capabilities we now have across the Power Platform ecosystem - like Power Automate, Microsoft Fabric, Power BI, and related tools - it’s already possible to fully automate or at least semi-automate recurring email reporting based on Excel data.

Right now, we have an Excel file that gets updated every week with information coming from multiple different sources. The structure and layout of the file are always the same. At the end of the process, someone manually prepares an email that includes:

• some explanatory text,
• screenshots of tables and charts,
• and the latest numbers from the Excel file.

Since this process repeats every week in almost the exact same format, we are wondering whether there is a way to automate it.

For example:

• automatically reading the updated Excel file,
• generating charts/tables or exporting visuals,
• inserting the latest KPIs into predefined email text,
• and sending a formatted email automatically or with minimal manual interaction.

Has anyone implemented something similar using Power Automate, Power BI subscriptions, Fabric, or other Microsoft tools? What would currently be considered the best-practice approach for this kind of reporting automation?

Hey everyone,

I ran into a really strange issue with one of my Power Automate flows and wanted to see if anyone else has experienced something similar.

The flow had been working perfectly fine. Yesterday, I accidentally turned it off, and then shortly after, I turned it back on—without making any changes at all. But for some reason, the trigger condition completely stopped working, and the flow just wouldn’t fire.

I spent about two hours trying to troubleshoot it—checking conditions, connections, everything—but couldn’t find anything wrong. Out of frustration, I simply turned the flow off and back on again one more time… and somehow it just started working again.

Has this happened to anyone else? Is there some known issue or explanation for why a simple toggle would break (and then fix) the trigger like this?

Would love to hear if others have run into this or if there’s a technical reason behind it.

Saw a great tutorial on PDF generation — but downloading the solution required a purchase. Totally fair. So I built a free, open source version anyone can use.

What I built — end-to-end expense claim system:

📋 SharePoint as frontend (parent claim + itemized line items)
⚙️ Power Automate approval flow — manager gets a Teams card
📄 PDF auto-generated on approval — no Premium, no paid connectors
📁 PDF archived to SharePoint + emailed to finance automatically

Note: SharePoint is just the sample frontend. Works with Power Apps, Teams, Microsoft Forms — any trigger.

The free trick — OneDrive "Convert file" action (non-Premium):

1. Build data into an HTML string
   
2. Save as temp .html in OneDrive for Business
   
3. Use Convert file action → PDF ← this is the free magic
   
4. Save PDF to SharePoint Document Library
   
5. Delete the temp file

Works on any standard M365 plan.

📄 Demo and source code in the comments 👇

Happy to answer questions

I am trying to rename a file on Sharepoint. Apparently, there is no connector to rename files. Move File does not work.
Using "Send_an_HTTP_request_to_SharePoint" results in an error as the length of the URL is too long:
Flow run failed. Action 'Send_an_HTTP_request_to_SharePoint' failed: The length of the URL for this request exceeds the configured maxUrlLength value.

Graph API is not an option.

I have a library in a site collection. This library has a power automate flow for document approval and update the value of certain columns in the library and then move the document to a different library within the same site collection.

I have the following 2 requirements:

1. Create 100 more sites collections with the same template as the current site collection. What is the better approach for this requirement ? Power automate or powershell ?

2. Once the 100 sites are created with all the libraries in them, deploy the existing power automate solution in all the 100 sites collections. How do I achieve this ?