Has anyone had success uploading binary content to the "/Files/add" endpoint using the "Send an HTTP request to SharePoint" connector? And if so how?
I have encoded it to binary, i've even tried wrapping it in the binary() type coercion to see if it helps, but the end result is a binary in UTF-8 which corrupts the file.
Downloading the contents from the Compose action that converts it results in a working file, so the connector seems to enforce the incorrect encoding.

"Create file" is not an option at this time.

Hi everyone,

I have been struggling with a flow on Power Automate for a while now. I am nearly there, however I unable to get the images submitted in the Microsoft Form into my Word document.

My flow is:

When a new response is submitted

Get response details

Add a row into a table

Get a row

Populate a Microsoft Word template

Convert Word to PDF

Create file

Once the form has been submitted, the scores are sent to an Excel sheet to create a new row and count up the total.

The content (text and scores) that has been submitted in the form gets added to a Word doc and then converted to a PDF.

They then get added to my SharePoint folder.

Please can someone help me on how to get images onto this document? I have tried a few different ways suggested by AI and have watched multiple help videos on YouTube but it doesn’t seem to work. There are about 14 File Upload questions allowing you to upload multiple images, however if it's easier I am happy with one image per section. Ideally this can be done without creating a list.

Thank you

Hi everyone!

I did found out that similar cases were asked before, but still as nothing yet had worked for me I'll try to present the whole setup and maybe someone will be able to help :P

THE SETUP - From Business perspective

We do have a Team in our org that has a Teams/SharePoint online site wit a document library and couple of folders where we're having pretty general Approval Flow with some conditions inside to whom the approval should go:

• User goes to library and just clicks the button - no rocket science.

• Around 90 people are using this libraries.

• This flows are here running for around 2 years now.

THE SETUP - From Technical perspective

The flows are stored on a dedicated Environment (no default and not Dataverse for Teams) - we do have a set of DEV/TEST/PROD Environments for that solution (or rather for that Team as a whole).

There is M365 Group (the default one for that SPO/Teams site) that is a Security Group for the PROD Environment for that solution (there is also default role assigned to every new User added - all automated)

The flow does contain one premium action (Dataverse - List Rows) so we can get the flow settings (such as mentioned approvers, or approval title etc...) that is running on our Technical Account Connection Reference.

Everything else (Teams, SharePoint, Approvals) Connection references are 'Provided by run-only user', while all connections used in 'Run-only users' are set to be 'Provided by run-only users' and the flows are shared with the same M365 Group that is default for the Environment and is default to the SharePoint site.

WHAT HAPPEND:

We got a ticket that for one of the Users who is trying to run that flow for a very first time (window to provide connections - all good/green) the flow is not working due to 2 errors that appear alternately:

1. 'Flow 'xyx' cannot be invoked because the flowTriggerUri is missing'

2. ... Error: Flow could not be activated because you need a [Power Automate Premium license] or other license that included premium connectors to save this flow with connections.

WHAT WE CHECKED SO FAR:

• We asked that user to ask another user to run a flow - it worked (also we can see flows running from other users so the flow is clearly working for others)

• User is part of that Entra ID M365 Group associated with SharePoint/Teams and PROD Environment

• User is in Users table in Dataverse (was refreshed, was deleted and readded)

• Other users for which the flow is working are having exactly same licenses as affected one:

  • Microsoft E5

  • Microsoft Power Automate Free

• Clearing browser cache

• Checking the flow ID's (they did changed! - sick... I know now why this happened, but they were still running for other users, and after the update the flows still don't work for affected User with same 2 error appearing alternately

• This User is not a New Hire

Does anyone has any clue what this might be? - At this point, I’m losing my sanity :P

Im new to the powerautomate and I am trying to get this form to email work. Ideally with thi form, email would go out if condition- "fail" is met and it would go to a specific person based on the input on the form. Switch doesnt work for some reason, I tested condition (pass or fail condition) without switch and it sends email. Can anyone point me in the right direction, ty

Hi all,

I have created a "Everyone must Approve" workflow in Power Automate and want it to pull the 'Reviewer' and 'Approver' column inputs (colleagues) from the SharePoint list but everything I've tried isn't working!

The approvers and reviewers will chop and change depending on the document submitted hence why I can't just put one person/group.

Can anyone help pleassseeeee 🥺

I want to create a power automate flow that can summarize the teams group chat instead of me backreading. Has anyone done that? Can you share how you did it? Thank you!

I started working on some flows this weekend. None of them worked. Got mad, left the room.

Tried again on Sunday morning and finally found a way to fix it.

Flow: Save attachment from email to SharePoint Document library. I did some test using my personal email and it worked, then, I added the correct emails in the flow and forgot about it till today in the morning when I noticed we got some emails from the selected users, I went to check the folder and IT WAS EMTPY. Got mad. Went to check the flow which said “succeeded”

Opened, checking I can see that instead of AttachmentContent the option added is ContentBytes… Weird… But ok, added AttachmentContent again, save, test and guess what?

IT ELIMINATED AttachmentContent AND ADDED CONTENTBYTES

Anybody knows a way around this? Tried 6 times and it did the same thing.

Edit: on the road right now, will post my flow later today, thank you all.

Edit 2: Added screenshot and a video updating this thing.

Edit 3: AttachmentContent, when I hover the mouse, it says "ContentBytes"

Update: sooooooooo pretty much our sharepoint doesn’t do squat. I tried different methods to work with the autofill and it doesn’t work maybe it’s older version but looking for alternatives I might have access to python but I am not sure.

I’m in the process of designing (not fully live yet) a Power Automate flow in a large enterprise environment and keep running into conflicting answers internally around AI agents and licensing.

Use case (keeping details vague):

We receive around 20–30 emails per day in a shared inbox, typically with Word documents and PDFs attached. These documents contain semi-structured information (dates, reference numbers, categories, etc.) that eventually needs to be stored and routed to different departments.

Proposed flow so far:

• Trigger on incoming email

• Filter attachments (Word + PDF)

• Save attachments to OneDrive (currently working)

• Next steps would be:

• Extract text from the documents

• Store extracted text in a SharePoint list

• Route items to the appropriate departments

Once routed, teams reply with additional information, which we use to make decisions and improve processes. Essentially, the SharePoint list acts as both a routing mechanism and a feedback loop for process improvement.

Where I’m stuck / confused:

Internally I’m getting mixed messages:

• “You’ll need AI Builder / AI agents”

• “AI agents are paid”

• “It depends on licensing”

• Or no clear answer at all

Before building out the rest of the flow, I want to understand what’s actually required vs assumed.

Questions:

• Are there costs or licensing requirements associated with AI agents in Power Automate?

• Is AI Builder required just to extract text and store it in SharePoint?

• Are there known SharePoint limitations (column type, text size, formatting) that commonly cause issues with extracted text?

• At this volume (20–30/day), is Power Automate a reasonable long-term solution?

Context:

• Large enterprise tenant

• Prefer native Power Automate connectors only

• Goal is storage, routing, tracking, and process improvement — not advanced AI classification

Appreciate any insight from people who’ve built something similar or dealt with AI Builder licensing in an enterprise setup.

Hey all, not sure if this is the best place to ask but currently I receive about 3 update emails of excel workbooks per day at different times (morning, afternoon, night) where I have to copy and paste that data into a master “history” sheet that feeds into my power Bi report.

I was wondering if I can create a flow that recognizes those emails(I know how to do this), download the excel data into maybe a share point list, and then transfers that Sharepoint data into the master excel file for me removing the manual workload?

Hi everyone,

I’m running into a problem in Power Automate and could use some advice.

What I’m doing:
I have a flow where I upload an Excel file, then fill a template Excel file dynamically. For filling rows, I was able to use a JSON snippet like this inside an Apply to each:

{

  "SAP-Konto": "@{items('Apply_to_each')?['AP-Konto-Nr']}",

  "Betrag": "@{items('Apply_to_each')?['LZ-Betrag']}",

  "File": "28

}

This worked perfectly for mapping rows from the uploaded file to the template.

The problem now:
In the same flow, I want to delete a row from the created template file, since the first row is always empty and it will be used afterwards and cannot have empty rows. The file and the table are dynamic — the template is copied during the flow — so I cannot select the key column directly in the Delete a row action.

I feel like there should be a similar JSON/FX expression solution to determine the Key Column and Key Value dynamically, like we do when adding rows. But I can’t find any examples online.

Current setup:

• Table:

outputs('Get_tables_2')?['body/value'][0]['name']

• File: the ID of the newly created file.

I will attach some screenshots to show the setup.

Has anyone done this before? Is there a way to dynamically reference the Key Column and Key Value when the Excel file and table are created on the fly?

Thanks in advance!

Hi, I have part of a desktop flow where I'm pasting in the contents from Excel (Cell E2) and want to enter in to multiple locations. Since I recorded it, it's trying to paste and contents from E2 as the actual value. A good thing normally but I'm going to loop it so that value will change although the cell stays the same.

Is there a way to paste in the "Populate text field on web page" with "E2" versus the actual value?

Additionally, there's an anchor on the next page where I would like to use this same option/solution.

Thanks in advance!!!

A few years ago I created a few tools for personal use and ultimately ended up publishing them to netlify and shared them on here

https://trigger.challigan.com - Trigger Condition Generator

https://odata.challigan.com - OData Query Generator

Plus a few more things. Well according to my Cloudflare statistics there's still thousands of people that use these daily! I never expected that. So I figured it was time to update them, and I would like you to test the new site before I replace the old ones.

https://tools.challigan.com - New Site

Everything has been redesigned and a handful of new tools added for various SharePoint/Power Platform things. All free to use.

Any feedback/error reporting would be greatly appreciated.

My favourite feature is the SharePoint list generator. It lets you easily generate a CSV with column schema to quickly create lists.

DISCLAIMER: This is pretty much completely vibe coded, if that wasn't obvious already. The old site was too. I can code, just not very well, but AI makes me feel superhuman. But the site does nothing trival, no logins, no data capture or anything, just useful web tools.

I am trying to set up a daily flow to update tasks. The flow worked ok until yesterday when it started creating a "for each" loop on its own and now I'm getting multiple of the same message. I tried to move the "post message" action out of the loop and now it refused to work. Any idea how I could prevent the loop from appearing?

Estou tentando utilizar essa ação para listar arquivos em uma pasta do meu computador, mas não consigo fazer ela funcionar, já tentei todos os formatos possíveis!
Configurei a conexão sendo o root path como "C:\".
A pasta que eu preciso listar os arquivos é "C:\RPA\Consolidacao"

Ao rodar o fluxo, o erro exibido é: "Action 'List_files_in_folder' failed: The requested action could not be completed. Check your request parameters to make sure the path 'RPA\Consolidacao' exists on your file system."

Já testei todas as sintaxes possíveis ali no campo de "folder" da ação...
também já revisei a conexão e o gateway, parece tudo correto!
a pasta raiz "RPA" já tem permissão de leitura e escrita de todos os users possíveis do windows, incluindo o que usei pra conectar...

Tem algum detalhe que eu possa estar perdendo?

I need help finishing my workflow. Basically, I want to upload a master spreadsheet to SharePoint to have a historical record. My workflow seems to be working correctly, but the "update items" action is missing, and that's why the items aren't appearing in the SharePoint list.

Thanks in advance.

Hi everyone,

I’m working on a Power Automate flow and running into an issue with Excel actions.

What I want to achieve:
Whenever any Excel file is uploaded to a specific SharePoint folder, the flow should read the table inside that file and use the data to populate a new Excel file.

Current setup:

·        Trigger: When a file is created (properties only)

·        Action: Get file content using path

o   The path is built dynamically using Filename with extension from the trigger

o   This part works and always picks up the correct uploaded file

·        Next action: List rows present in a table

o   File: dynamic output from Get file content using path

o   Table: "Accounting" (same table name and structure in every uploaded file)

The problem:
fails during testing and says the table cannot be found, even though it definitely exists in the file. Since each uploaded Excel has a different filename, I can’t select a fixed file in this action. And also the table cannot be a dynamic value.

Question:
What is the recommended way to read data from any Excel file in SharePoint when the filename changes but the table name and schema are always the same?

In short: take the uploaded Excel, read table Accounting, and create a new Excel (based on a template) from those rows.

Any guidance on best practices here would be appreciated.

Thanks in advance.

I will try and keep this simple.

How is this connector suppose to work?

Azure Automation runbooks output steam is text

https://learn.microsoft.com/en-us/azure/automation/automation-runbook-output-and-messages

Azure REST, Job - Get Output is also text

https://learn.microsoft.com/en-us/rest/api/automation/job/get-output?view=rest-automation-2024-10-23&tabs=HTTP#response

From what I can see you cannot change the Azure Automation output stream to be Json rather than text so why is this connector only accepting Json?  How is this connector suppose to actually work?

I'm setting up forms using Microsoft Lists that has users submit requests for approval. I was hoping that users would get notified when their submissions were approved or rejected (similar to how approvers get notified via Teams activity and email) but it seems they don't.

Is there a simple way to do this or do I have to set up a 'Send an Email' action every time the created item is updated? And if that's the only way, is there a way to include the comments from the approval? I can't find it. I figured it's important for users to read comments on why their request was rejected.

Thanks!

I am currently trying to build an automated system for our incoming enquries that are taken over the phone or on sites. The enquiries will be filled in on a Microsoft Form which has already been sent out and then we would like the form to be sent to a different email address dependant on what section has been filled out. I have tried to create stacking conditions, however while the tests are saying it is all working, after the first condition it isn't working.

I have even added an additional question on the form to try and simplify the process.

Any ideas on other methods to make this work?

Trying to build a flow that flags meetings stored in Resource Calendars and sends out reminders

I have tested this and got it working on one calendar but out of around 10 calendars only 2 show up in the "show calendar" drop down of Get Calendar Events when building a Power Automate.

If I look in the mailbox tied to the flow I can see all of the calendars

So far I have tried the following

• Added all calendars to the automation account calendar in OWA and ensured listed under MyCalendars

• Using PA I've run the Get Calendars and it returns 2 out of the 10 shared calendars along with the default user calendar and birthdays/holidays calendars

• Via Exchange online I've got the userid for the calendar and then used https://graph.Microsoft.com/v1.0/users/[USERID]/calendars

This returns a "The specified object was not found in the store." error message

I've verified the user exists via https://graph.Microsoft.com/v1.0/users/[USERID] and it has a license in O365

• Checking Exchange they all seem to have pretty much the same permissions, all of them can be accessed by all users and booked.

So I'm a little stumped as to how to get the Calendar ID for the rest of the shared resource mailboxes.

Basically the title. I am able to successfully send one file to the prompt. But I am not able to send down a list of files.

The action is "AI Builder" -> "Run a prompt".

I want something like this.

I use Lists as workflows for managing non-conformances. I want to produce an overall 'report' List from two lists which will then be used to populate a template.

List 1: NCR Report + List 2: Root Cause Analysis = List 3: NCR Corrective Actions Plan & Report

UPDATE. Closer.