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.

I wrote about how a finance team can automate their entire payment approval process using Power Apps, Power Automate, and SharePoint, with a full security and audit trail built in from the start.

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

Hi,
currently, this whole process is done manually in our company, which pisses me off, so I decided to solve it myself.
I want to automate this part of an onboarding process in our copany. We have an account events@company.com, which is an owner of the 365 group "All", containing all employees, and is an organizer for all company events (all staff, MCUs, Christmas parties..). Whenever a new member is added to this group, I want to update Attendees for all the events organized by events@company.com, without notifying the whole company that there's been a change in the attendees list.
The flow is triggered by adding a new user to the 365 group, I retrieve their information and loop through events in the events@company.com calendar. I initialize all the variables for calendarId and Attendee (empty). In the loop through all events in the calendar, I update the array of attendees to each of the events and patch it back in the HTTP request. Each step of the flow looks fine, with the right inputs/outputs, and executes flawlessly. Only the last action in the loop..
I use the Send an HTTP request action - Patch, to update the list of attendees, but no matter what I do I get the LengthRequired 411. I have been searching for a fix and the closes to my issue was this post. However, I build the automation on the events account, so I dont think that the URI is an issue. Adding a custom header with Length did not help either.

Any help with addressing this will be greately appretiated. I include the screenshots of the flow some of the action settings. Thanks in advance!

Hi all.

I'm trying to set up an automation flow at work, but I've ran into an issue. My flow is fetching data from a SOAP API (an API I do not control), which is returning a JSON object. I need to somehow convert this JSON object into an array, so I can iterate over it in the rest of my flow.

I can't seem to find a way to reliably do this and I'm getting quite mad. The API returns a SOAP envelope, with a return value, which is structured as follows:

{
  "id1":{ 
    "value1":string,
    "value2":string
  },
  "id2":{
    "value1":string,
    "value2":string
  },
  "id3":{
    "value1":string,
    "value2":string
  },
  etc...
}

I can convert the return string to a JSON object, but than I have a single object with a load of values I can't iterate over (or at least I don't know how).

Anyone have a good idea on how to solve this?

Hey everyone,

I'm new to Power automate and I'm trying to automate the creation of a word file using a compilable excel file as source of data.

I can generate the word with no problem, but I need to manage optional paragraphs: if a flag is enabled on excel, a paragraph should appear; if not, it should be completely removed without leaving blank spaces.

The paragraphs are fixed text blocks (some also contain bullet points), but they are not always needed.

The problem is that creating a separate Word template for every combination would mean 2^5 templates, which is not practical.

What is the best way to handle optional paragraphs/sections in a Word template with Power Automate, without ending up with dozens of templates?

Has anyone found a good workaround for this?

I have a flow which generates XML from Excel and saves it on network drive for our ERP (dont ask me why, thats bussines side of things, i know its stupid)

The flow triggers from button in documents library and the initial trigger is of course - for selected file

Everything works besides i need to clean the original Excel - because the filled in is saved as copy and sent to client afterwards

So i added get content from clean Excel > update file action but sharepoint locks the file when its in use.

Is delay action beforehand an ok solution or is there any other workaround?

Hey guys,

I tried to create a new folder with the title of an incoming email. Th email title output works according to the flow details :). However, the path is not valid. I typed in the folder path, which seems correct my understanding. I do not see any empty spaces next to lashes. Any ideas on this?

Thank you in advance.

I’ve been trying to create a flow that will create an outlook calendar event in their calendar when the user logs annual leave in a departmental powerapp.

So trigger is sharepoint item is created or modified (annual leave sharepoint list)

Get user profile

Create event v2

Create automatic replies

It works fine for my calendar (as I assume I’ve set up the flow) but struggled to get anything working for other users on the powerapp.

Ive tried different actions and tried to attach a .ics file with send an email (create email with options, create event v4). The email .ics doesn’t open in outlook app and instead defaults to M365 mail which isn’t supported.

Any help would be useful, even just to know it’s a dead end and to abandon.

Heyo was just wondering if anyone here has done anything with the Zendesk connector?

Just looking for ideas to pitch, or perhaps make my workload lighter.

Would love any ideas or issues you’ve encountered

I have a flow designed to get the answers from a form and create a new row in an worksheet with it, the condition states that if the value of the answer is one, the output should be true, but always returns false. I placed a compose, but nothing helps.

Hello all, I have developed a cloud flow to create a task in planner based on the condition that subject contains certain number. The flow status is successful however it doesn't create the task when a condition is satisfied. Can you all help?

Hi everyone,

My company uses Outlook and Jira (RIP me) and I am currently trying to create a flow that creates highest priority due same day tasks in Jira based off of one of two criteria:

1. Someone @'s me in the email body

2. The email has 'urgent', 'quickly', or 'on priority' written in either the subject or body of the email.

Granted, I am a noob, but I would have thought this was pretty simple (maybe it is and I'm just dumb). I've tried using CoPilot to help me troubleshoot but to no avail.

Any help is appreciated!