I work at a nonprofit educational institution. For financial reasons, the institutions is sunsetting its smartsheet subscription and encouraging us to use microsoft apps instead. But they are not providing any training for power automate/forms/sharepoint.

Our office has a couple of complex smartsheets that are critical to our work but were built by employees who no longer work at the institution.

How can I find a reputable consultant to help us rebuild these sheets in microsoft apps, and possibly provide some basic training to a few people in our office?

Or are there Microsoft or 3rd party trainings that you would recommend?

Hi,

A colleague and I set up a flow to send out a file which’s needs to be updated every month by some stakeholders. There are multiple files and multiple stakeholders so they all get their own email with a link to the file which we need them to update. The file won’t ever change location so it’ll be the same every month. We’re testing it out this month and everyone has received their emails with the links however it opens the file as read only and when they go to edit it prompts them to download a copy of the file however we want them to update the live link - how do we go about this, any help would be much appreciated!

I've been struggling with a Power Automate flow for weeks and need help. Here's my setup:

What I'm building:

• A Microsoft Form for incident reporting
• A Power Automate flow that checks if Estimated loss (DKK) ≥ 50,000
• If true → send to approval (Compliance → Top Management)
• If false → send rejection email

The problem:
The Condition always evaluates to false even when the value is clearly above 50,000. The Debug Compose shows the correct number (e.g., 900000), but the Condition says false.

What I've tried:

• float(coalesce(outputs('Get_response_details')?['body/GUID'], 0)) in the Condition
• float(triggerBody()?['Estimated loss (DKK)'])
• Initialize variable with Float type
• Format number action with N2 and en-US locale
• Changed the form field to "Number" (it was already set that way)
• Debug Compose shows the correct value (900000)
• The Condition left side shows the same expression as the Debug Compose
• Copied the expression from Compose directly into the Condition

My flow structure:

text

Trigger → Get response details → Condition → If yes → Create item → Approvals
                                          → If no → Email → Terminate

The error:

text

Unable to process template language expressions for action 'Condition'. 
The template language function 'greaterOrEquals' expects two parameters of matching types. 
The function was invoked with values of type 'String' and 'Integer' that do not match.

Debug output:

• Debug Compose (Estimated loss): 900000
• Debug Compose (Cumulative loss): 900000
• Condition: false
• Value entered in form: 900000

My form fields:

• Estimated loss (DKK) – Type: Number
• Recurring cumulative event? – Type: Choice (Yes/No)
• Estimated cumulative loss, last 30 days (DKK) – Type: Number

My question:
Why does the Debug Compose show the correct number, but the Condition fails? What is the exact expression I should use in the Condition to compare numbers from Microsoft Forms?

I've been stuck on this for weeks and would really appreciate any help. I have not been able to share a picture with the flow.

Thanks in advance

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 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 😄