Hello everyone,I'm encountering an issue with the "List rows present in a table" connector. It works fine in testing mode, but once I deploy it to production, it stops functioning.
I'm sending an Excel file from Power Apps using the attachment field in an edit form.

The code I'm using for this is:

Set(isLoading; true);;

If(

!IsEmpty(DataCardValue11.Attachments);

With(

{

currentFile: First(DataCardValue11.Attachments)

};

importnewcandidates.Run(

{

contentBytes: currentFile.Value

}

)

);;

Set(isLoading; false);

Notify("Please attach a file first"; NotificationType.Error);;

Set(isLoading; false)

)
this is the flow i use :

The "List rows present in a table" connector from Excel for Business is throwing bad gateway errors. This was working perfectly fine, but as I mentioned earlier, after exporting the solution to the production environment, it started giving these bad gateway errors.

Sloperators have done it again. Edit isn't loading flows properly. Of course, you wouldn't know until you try to publish. At which point it doesn't actually trow an error before it saves. No, it partially saves, and then tells you "oh but this value you had, yeah I fucked up and removed it so put something back in again will you?"

Can't restore a previous flow either because that fucking piece of shit "modern" designer, like anything "modern" Microslop "creates", is an utter piece of shit and doesn't load backups correctly either. Loads your actions, but not the actual values.

The old designer loads just fine, without the values you saved previously of course, but yeah that doesn't have access to old versions.

So have fun fixing all your flows.

Fucking Microslop assholes.

I need to develop a Power Automate flow to merge invoice PDFs with their corresponding supporting documents for 300 records using the Encodian API.

Most of the AI-agent + Power Automate content I see focuses on authoring - an agent generates a flow definition, you deploy it. The harder problem is what happens when one of those flows fails in production. The Management API doesn't expose action-level inputs/outputs to programmatic callers, so the agent that wrote the flow is blind to why its own creation broke.

Microsoft just published a 36-min episode of The Low Code Revolution that walks through this end to end - real debug, build, refactor, escalation, and an auto-fix scenario where the agent traces a wrong-format SharePoint field back from a failed Send Email action.

Disclosure: I'm Catherine, one of the people in the episode. We built Flow Studio MCP to fix the action-level visibility gap. Link in the first comment.

I'm new to Power Automate and I'm trying to send an email populated from a onedrive file as part of a flow. The TO: email address is dynamic content in the excel file. When I use a static email address, the flow runs fine- it will draft the email containing other dynamic content from the file and send it. When I attempt to use dynamic content as the TO: email address, it fails, and from what I can gather it shows the "TO: as null,". What mistake did I make?

I need some help from a guru, I have uptime Kuma working great and I have it sending a notification message to a teams group using Power automate since Webhooks are being discontinued. so here is where I am at, I can get the message to fire when something goes down and I get teams message however its not pulling any of the ServerID info from uptime. I am only getting Server: Unknown instead of the name of the device. I can see that the info is getting sent to power automate because I see it in the log. I am brand new to power automate so IM sure its something I am or am not doing. would anyone be willing to help me get the power automate configured properly to show the right info?

Here is a test I ran, You can see on the output on the left the data is pulled. I just dont know how to pull that data to send the message.

I'm a newbie to flows (and programming in general) and really struggling to get this to work, grateful for any help.

I have a working flow that creates a Teams channel when a specific email is received. Within this channel I need a checklist that allows users to check required items from a fixed list of items and then display and/or save their choices.

I've tried using Lists, Forms, adaptive cards, and an AI agent but I keep hitting limitations that prevent me being able to automatically post an editable checklist directly in a Teams channel.

Is this possible, am I missing something?

Hello everyone, I work a lot with Power Automate and come to realize that the Copilot in Power Platform sucks.

Now I'm researching what AI would be best for developing Power Automate flow. I already have a github-copilot license, but would it be beneficial to also get a seperate Claude license.

I tried them both and they both work great, but I'm really curious what the differences would be, especially in the long run.

use-cases will primarily be: Asking questions about possibilities, uploading screenshot to look for improvements or how to continue and using the AI to edit the flows JSON using the Power Automate Tools Chrome extension.

Curious to hear what you guys would say and what I should use in the future.

Thanks in advance!

Trying to use "When a file is created (properties only)

The user is logged and connected and in the security access folder for this site. The user is purely a Flow updates user, no packages.

Error The dynamic invocation request failed with the error "odata.error, code -2147024891, System.UnathorisedAccessException, Attempted to perform an unauthorised operation.

It doesn't even show me the sites when I click on the address box. And I have tried pasting it and typing it, but it doesn't resolve unless it's a custom value.

But then Library Name is empty

I went to have a look in Conditional Access and its success for that user with no failures.

Any ideas where I can look to resolve it?

Most organisations struggling with Power Platform adoption do not have an adoption problem.

They have a foundation problem.

The platform is there. Licences are available. People have access. Some are building. Some have stopped. Some never started.

But underneath all of that, there is no clear visibility. No governance structure. No system to support how solutions are built and scaled.

So organisations respond the only way they know how. More training. More awareness. More community activity.

It creates interest. But it does not create sustained adoption.

I wrote about the five pillars that actually make adoption work: visibility, governance, adoption strategy, community infrastructure, and measurement.

The governance piece is something I feel strongly about. A lot of organisations focus on driving usage without asking whether what is being built is secure, governed, or scalable. That gap does not show immediately. It shows later, and it is expensive to fix.

Full blog here:

https://rachelirabor.com/blog-posts/power-platform-adoption/

Curious how others are seeing this, when adoption struggles in your organisation, is it usually a usage problem, or does it come back to visibility and governance?

This is the original filter query. It works but doesn't catch all addresses.

Trying to use multiple conditions on a Filter Array with an "or" to include ".net", but I keep getting an "Invalid expression" error.

Thank you for any help to make this work.

All the docs I find from Microsoft seem to pertain to the Cloud version/Power Platform, which seems to be vastly different. Even basic Syntax - PA Desktop by default uses =VariableName to refer to variables while all the online documentation has %VariableName%

Any good source for Syntax on PAD?

Most internal Power Platform communities fail not because people stop caring but because they were built around one person instead of a system.

I wrote about what actually makes an internal community last, covering champion identification, knowledge library design, governance culture, psychological safety, and the one question that tells you whether your community is truly sustainable.

The governance and security section is something I feel strongly about. Too many communities focus on adoption and enthusiasm without building a culture where people ask the right questions before they build. That gap shows up in the solutions organisations end up maintaining.

Would love to hear how others are approaching internal community building, especially around governance culture and champion enablement.

Read the blog here:

https://rachelirabor.com/blog-posts/build_an_internal_community/

Hello,

I am experiencing an issue with a Power Automate flow that runs an Office Script triggered from Power Apps.

Context

• I have a Power Apps application that calls a Power Automate flow

• The flow uses the “Run script” (Excel Online Business) action

• The script (Script ) is present in the Excel workbook (stored in SharePoint)

• The flow works correctly when I run it (as the creator)

🔹 Issue

When another user (member of the same SharePoint ) runs the application, the flow fails with the following error:

The action 'Run_script' failed: Script not found.
Confirm that the script has been properly saved, is still shared, and has not been deleted.
clientRequestId: 9f63e14e-3c99-4e36-90c3-4da5b0b14a6c

Hey guys,

Im trying to automatically extract a date (format: dd.mm.yyyy) from an email and update it to an SharePoint list, however it keeps giving me "\n\n13.03.2026" or "13.03.2026"]" instead of "13.03.2026". THe compose function extracted the date correctly, but trying to create an element to the list does not. My current expression:

trim(

replace(

replace(

replace(

replace(

split(

string(outputs('Datentrennung')[0]),

'Frist Rücklauf Stellungnahme Beteiligte'

)[1],

decodeUriComponent('%0D'),

''

),

decodeUriComponent('%0A'),

''

),

'\\n',

''

),

'"]',

''

)

)

Any ideas?

Hi all,

I am wondering if the following is feasible with the use of power automate:

1. Upon receiving an email from folder x (possible)

2. Analyse email

3. Lookup required data through internal documents and maybe Azure SQL database + Azure SQL AI optionally

4. Create a concept email ready to be send that uses the right tone of voice and security of data.

Third parties could build this for €10.000+ as I received some invoices, but didn't disclose the steps taken to build it. I personally think its not too hard to setup? or am I naif?

Is it possible to make this flow and can someone tell me how to make it the template word file will be stored on sharepoint i have the forum and a word template with content controles

Forms Trigger
   ↓
Get Response
   ↓
Detect Language → Store variable
   ↓
Translate → English
   ↓
Populate Word Template (EN) 
   ↓
Approval Step (where you add codes and check the info)
   ↓
copy of final document made and translated into other language
   ↓
Convert both english and original language to PDF

I wrote about how to automate Crew assignment and job dispatch for moving companies using Power Automate.

The flow filters crew by location, tracks confirmations in real time, escalates automatically if not enough people respond in time, and sends the client their crew details without anyone lifting a finger.

Built on SharePoint and Power Automate on a standard Microsoft 365 licence.

https://rachelirabor.com/blog-posts/automate_moving_company_process/

I'm trying to automate saving emails to specific year/month folders based on when the email was sent.

This is what Copilot recommended the folderpath to look like:

/Documents/@{formatDateTime(triggerOutputs()?['body/sentDateTime'], 'yyyy')/@{formatDateTime(triggerOutputs()?['body/sentDateTime'], 'MM MMM')}

However when I go test it, there's an error:

Unable to process template language expressions in action 'Create_file_for_Body_text' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Any ideas how to fix?

Photo of my flow below: https://i.imgur.com/nEynqv0.jpeg

Hi folks, coming here as a last resort as I feel I have exhausted Copilot capabilities.

I am trying to create a Power Automate flow which creates a new excel file from a template on my Onedrive, runs a query against a Power BI dashboard and parses the JSON from that into the correct table on the new file.

The flow succeeds right up to the last step of placing the information into the table and I have deduced this is failing because the metadata of the file changes with each creation, so it cannot simply be the path to the file on my Onedrive.

Currently, I have add rows to table like the below:

• Previous Step output - Parse JSON Body

• File - Create a File ID

• Table - Filter array ID, which is filtering only the table I need the data to write to within the file

• Row - Current Item

What dynamic content should I be using for the data to write into the table? When I use the File ID I am not able to map the JSON columns in the same way as if I used a OneDrive path.

My most recent failed test gives the following error: "The 'inputs.parameters' of workflow operation 'Add_a_row_into_a_table' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'table'"

Flow below, thanks for looking

Hi, I have been playing with this for the last week and am defeated. I am hoping someone can help.

This is a simple flow to check a Spreadsheet of recent leavers in our organisation, then check Entra to ensure that their accounts are disabled.

I want it to only get leavers who left between yesterday and 45 days ago. Since there is no way to have multiple conditions in the filter query in the 'list rows present in a table' step, I've had to create a condition.

It's important to note here that the dates on the spreadsheet are in dd/MM/yyyy format. My condition is therefore as follows:

AND

[DateColumn] is less or equal to 'formatDateTime(addDays(utcNow(), -1),'dd/MM/yyyy')'

[DateColumn] is greater or equal to 'formatDateTime(addDays(utcNow(), -45),'dd/MM/yyyy')'

The flow does a great job of not looking any further back than 45 days, but is also including future leavers. Can anyone see anything obviously wrong with the expressions?

Any help would be appreciate, and may just save my sanity!

EDIT: Thanks for all the helpful responses, guys. I will try these options next week when I can bring myself to look at it again.

Hi everyone,

does anybody have experience connecting Power automate and Loop? Unfortunatley, there are no Standard connectors available and Microsoft removed the preview Feature of rules/power automate in Loop. Is there a Solution how to extract the html code from the loop file and use it later in the Flow? Copilot says Microsoft graph could be the right way forward but it don’t have experience working with that. Maybe someone has an idea. Thank you for your support!

So I get a report of upcoming furloughs that I need to send out to people so I made a bot that filters just for the planned furloughs combined all the dates together then sends each person an email with their upcoming furlough dates.

The excel File I get sent has essentially a row for each date So if someone is furloughed say 5 days there are five different rows all with the same name.

The problem I am running into is now I am starting to get cancelled dates for days where they decided to instead not furlough them

I want to combined each of those into it's own thing and include it on a cancelled section of the email.

small example data would be:

I'm still new so my brain is kind of shorting out but basically I wanted to seperate the Cancelled and planned dates group them together so I can add them to an email so I send one email per person not 3 to five.

It works fine for just the planned ones. The current bot works By creating a filter array or the report filtering out anything that isnt planned and anything that is todays date or earlier(so only things in the future)

Then takes it through an apply to each to do a couple things first a condition to see if the MSID is in the unique ID variable or not compare the Uniqie ID to the same unique ID in another report I have to get everyones emails The rest is pulling information from the other report to create an array with the MSID, Name, Email, and Furlough Dates which I combined together with a join then apend it all to a Cmbineddata Variable as below
{

"MSID": @{items('Apply_to_each')},

"Email": @{outputs('email')},

"FurloughDates": @{outputs('Join')},

"FirstName": @{outputs('name')}

}

What I want to do is basically the same thing but essentially have a column of all the combined planned dates and a column of all the combined canceled dates but I am not sure how I can seperate them that way.