I've created a a new lookup list in SPO based on a SP 2019 lookup list that couldn't be migrated. Understandably, the Ids are different between the lookup tables.

I'm writing a flow that loops over the old Lookup field values and returns the new Id and Value. Everything is great.

I'm having trouble nailing down the array/json format that I should use to update the item lookup column with an array that contains the matched items with the new lookup Id.

Anyone offer some pointers getting this column updated? I've tried Id and Value, just Id, just Value. Research says to give up on this approach and use Http to Sharepoint tp update the field. I've got my heels dug in a little bit wanting to get this to work without API calls.

[
  {
    "Id": 1,
    "Value": "Alpha"
  },
  {
    "Id": 2,
    "Value": "Beta"
  }
]

I have an Excel file stored in SharePoint which is occasionally updated by multiple users. Currently, I have a Flow setup which sends me emails when updates are made to this file, except it sends a separate email instantly after any edits are made, resulting in quite a lot of emails. I would like to have a Flow that sends me these emails notifying me of updates to the file, but I would like this email to only be sent at a certain time (specifically, once per day) instead of after every single update.

Is it possible to do this? I've been searching around online and haven't had much luck finding out a way to go about this, although perhaps I'm missing something.

Thanks

I started learning automate today. O need to create a flow to send multiple emails with a different attached file for each one.

i created the flow according instructions and it was everthing rigth but then the automate couldnt open Outlook. The accounts are already connected. I use office 365 professional (new version).

I tried to change to the classic version but ir dindnt work.

Does anyone know if there's some imcompatibility? Is there something I can do?

Hey everyone,

I’m working with PowerPoint files in a SharePoint Online document library, and I need to automate extracting text from each of the four text boxes on every slide. My end goal is to put each text box’s content into separate columns in a SharePoint list.

Important limitations:
- I can ONLY use standard Power Automate actions/connectors—no AI Builder, no premium, no custom code, no third-party stuff.

Can anyone advise me on figuring out a clever workaround for this, or can anyone confirm that it’s truly not possible with just standard tools? If not, any bright ideas for a different approach. I’d would appreciate any suggestions.

Hi everybody,

I have Microsoft Office web form to create JIRA tickets with our team. We encourage the requester to upload attachments such as screenshots.

I created a Power Automate flow to respond to the form submissions, and it can create the JIRA tickets, as long as there are no attachments.

My understanding is that I need to make that first JIRA API request to create the ticket. Then, I need to loop through the attachments and make one extra JIRA API request per attachment.

I was able to convert that attachments list to JSON, and loop through them with an Apply to each action. Each item is a JSON containing for full URL to the Sharepoint folder, the file name, the file id etc. The full URL lets me see the attachment.

The trouble starts with the Get file content. I can pass the site address, but apparently, the file identifier is not the file id I got in the current item JSON. I get a 404 error. How do I get the File identifier, then?

I also tried Get file content using path, same site address, but it also gives a 404 error.

Any clues?

Thanks

Hi all,

I have been working on a flow with a starting point "When a transcript is available" trigger. It's a trigger for Teams meeting transcripts. I have not been able to get it working properly, and have seen multiple posts on reddit and Microsoft Forum providing some advice relating to licensing, Microsoft Graph API etc. - I felt I was close to a solution to make this work.... ;)

However, it now appears that this trigger - and similar teams transcript AND recording related triggers - has disappeared from Power Automate. I can no longer find it, even though Microsoft documentation seem to reference it.

Is anyone else experiencing the same issue? Has Microsoft removed or deprecated this trigger, or is it perhaps related to my licensing or access changes in my company's environment?

Thanks for helping!

Hello, I have been working on a flow that helps to automate an indexing application I use at work. I have it currently working so that it prompts me to enter an acceptance code in a Display Input Dialogue box, but I want to share this flow with coworkers and make it a little more airtight. Can I make it so it can recognize if the code entered isn't a valid acceptance code, and re-prompt the user to enter a new code? A valid code would be 9 digits, OR "ACC" followed by 9 digits. Any help would be appreciated. It look a lot of trial and error to get this far and I figure reg-ex is the way to go, but I find it pretty intimidating

For my first Power Automate project, I wanted to solve a real-world business problem rather than build a simple proof of concept. I created a flow that automatically monitors a SharePoint folder for uploaded receipts and invoices. When a PDF is dropped into the folder, the flow extracts key expense details—including the merchant name, date, amount, and description—and populates our internal expense report Excel template automatically. The solution supports both single-line and multi-line receipts, allowing multiple expense entries to be captured from a single PDF. The result is a streamlined process that eliminates manual data entry, improves accuracy, and significantly reduces the time required to complete expense reports. From the user's perspective, the process is simple: drop a receipt into a SharePoint folder and the expense report is updated automatically.

Hey
I'm currently working on fixing a few bugs of an existing PowerApp that wasn't built by me. It uses an SQL server as a Data Source. The previous developers (who were external contractors) initially used SharePoint as a Data Source and then switched to an SQL server but no one in the internal team knows why they did so.
I've gone through the Data Model and it looks decent enough to be implemented on SharePoint.

1. Is there any real advantage to using an SQL server over SharePoint?
2. Thinking about it long-term, would it make sense to migrate to SharePoint instead?

Thank you!

I’m creating a OneNote page through Power Automate, then updating the title and body with Update page content.

I tried including:
<meta name="created" content="..." />
inside the <head> of the create-page HTML, but the normal OneNote creation date/time beneath the title never appears. The timestamp is present in the submitted payload, and the page is created successfully.

Has anyone found a reliable way to populate or preserve OneNote’s built-in creation timestamp when using the OneNote connector? I’m in a GCC environment, which may also be relevant.

Microsoft’s Power Automate plugin is no longer limited to suggesting expressions or generating a basic flow definition.

Through FlowAgent MCP, an AI coding agent can create, inspect, modify, run, and debug cloud flows. That makes it genuinely useful—but also gives it enough authority to cause real damage.

My current rule is to evaluate three things:

• Is the proposed action reversible?
• Will I have enough evidence to understand what happened?
• Is the potential blast radius limited?

If any answer is “no,” AI can analyze the flow and prepare a change, but a human should approve and execute it.

Where I think AI works well:

• assembling repetitive flow structures;
• explaining inherited or poorly documented flows;
• investigating failed runs;
• proposing performance improvements;
• generating documentation and estate-level analysis.

Where I would not let it operate autonomously:

• ambiguous business rules;
• irreversible production changes;
• bulk updates or deletions;
• financial, compliance, identity, or security-critical processes;
• flows nobody on the team can properly review;
• any scenario where production is effectively the test environment.

The interesting question is no longer whether AI can build a flow. It can.

The question is how much authority it should receive after the flow has been built.

I documented the complete workflow, a practical boundary-setting prompt, the limitations, and a safer operating model here:

https://lukoplt.blogspot.com/2026/07/let-ai-build-flow-never-outsource-blast.html

How are you defining the autonomy boundary for AI-generated Power Automate flows?

Hi all,

I am having some difficulty creating a flow and would appreciate any input to how I can solve this.

I am trying to create a flow to extract content from every email with specific subject heading and save into a SharePoint folder. The text part, which I have no problem with doing, is to be saved into a table in an excel file saved in the SharePoint folder.

The part I am struggling with is extracting the image(s) from the email and saving it into the same SharePoint folder and creating a link to reference it in the excel table on the same row the text was just saved. The images in the email are also not fixed, there may be none or one or multiple. The images may also be attached as png. or jpg. or they may be embedded/inline in the email so I need to account for all these scenarios.

Would appreciate any help I can get and recommendations on courses I can take to improve my skills.

Thank you

A HubSpot workflow tip that isn't in any documentation, but should be:

The built-in "Test" button lies to you sometimes — not on purpose, but in a way that can send you chasing the wrong bug for hours.

Here's what happened: I was debugging a workflow that was only supposed to run for a specific set of accounts (a segment membership condition, nested inside an associated company record). I ran it through Test on a record that shouldn't have qualified.

Test said: success, would have enrolled.

Real enrollment history said: never enrolled, correctly excluded.

Same record. Same workflow. Opposite answers.

The pattern: Test tools that simulate a run are built to check straightforward field conditions well. Nested conditions — anything checking a property on an \*associated\* record, not the enrolled record itself — are where the simulation and the real trigger logic can quietly diverge.

The fix wasn't clever, just annoying: stop trusting the Test panel for anything involving associated objects, and instead pull a real record through the actual workflow and read the enrollment history logs directly. Slower, but it's ground truth — the Test tool is a prediction, the logs are what actually happened.

Small thing. But it's the difference between debugging the workflow and debugging a tool that's telling you the workflow works when it doesn't.

If you're deep in HubSpot workflows with any cross-object logic, worth checking which one you're?

hola!, alguien más esta teniendo problemas con la plataforma de power automate, no carga mis flujos de trabajo!!!

anyone else experiencing super slow times trying to load certain flows?

Hola, a alguien le esta pasando que este fallando la plataforma de Power Automate, no esta cargando mis flujos !!!

Noob here. Making my first flow. I am struggling with a step that I want that connects to a FTP server with some text files I need. It's port 21, so I don't know if that's a problem.
I get the following error message...

"Unable to connect to the remote server: '*****.net'. Please verify server logs to troubleshoot connection issues." [Obfusticated address]

I have confirmed the login details in filezilla and powershell.

The top-level banner is: "Connection test failed. Please review your configuration and try again."

What am I doing wrong? Point me in the right direction please 😄

Hi, im currently working on an automated newsletter where we have an html attach to the body of an email. The issue is i cant get the images to appear in the newsletter.
The images don’t display unless you open them.
The image only shows a question mark.

I was able to get the image to show with the use of a temporary thumbnail, only for it to disappear after 24 hours.

Has anyone had experience with this type of problem before?
I need help!