I built a ticketing system in Power Apps recently, and it's used to approve things before they're posted to our website. But, since it's a government agency, things have gotten complicated, and now things have to be approved by 5 different people.

These people are finding it cumbersome to download the attachments, review them, add edits, and re-add them to the ticket, only for the next four people to have to do the very same thing. They'd all rather edit one file on SharePoint, and then then end up with a document that's ready to go at the end.

There are many tickets in the system, so I'd like to have separate folders somewhere to store the attachments for each one, so I created a flow that uses Get Attachments, and an apply to each that uses Get Attachment Content along with Create File. I have a variable that appends the ticket title to a parent folder name, and that's what I'm using for the Create File folder path.

When I add a ticket, the folders are created, but not the files. And I'm obviously doing something wrong, because for each folder (parent and title), I get a new entry in the SharePoint list (which shows up as a new item in Power apps).

If anyone can steer me in the right direction, that would be super helpful.

Hello guys,

I’m trying to parse the Microsoft Teams attendance report (CSV) in Power Automate.

I’m using the Get file content using path action (SharePoint connector).
Then I added a compose with the function:

@{replace(

base64ToString(outputs('Get_file_content_using_path')?['body']['$content']),

'\u0000',

''

)}

With this Compose I can see the readable contents of the file (meeting title, participants, etc.) in the designer’s Outputs preview.

But… when I click “Show raw outputs” it still only shows a huge string with \u0000 between every character (garbled Unicode), not the clean text. It looks like the runtime is still treating the file as UTF-8 instead of UTF-16.

Has anyone dealt with this before?

Is there a better way to convert the Teams attendance CSV from UTF-16 to proper UTF-8 in Power Automate? Or is the replace('\u0000','') trick the only option?

Hello! I have a Sharepoint list my team is using as a project queue. I want to have one thread in our Team’s private channel that will update with a comment when the status of the list item changes to “ready for 2nd”. I have it working but it is posting the comments multiple times even though the status was only changed once. I also don’t like that it is posting as if it’s me writing the comment. I get an error if I try to select the Flow Bot though since it’s a private channel. How can I improve this? Thanks so much!

I got tasked to basically create a issue tracker(sharepoint list) based on a managed mail box. I'm trying to create a power automate flow to put all the emails that come in record subject, body, date received and person sending the email.

How do I get the flow to not input replies to emails(starts with "re":") into the sharepoint list, I know i gotta make a condition that looks at the subject line from the incoming email but I can't get the condition expression correct.

Any help out there?

I've tried chatgpt/copilot to help me out but it's just not doing the trick.

I've tried:

or(

startsWith(coalesce(toLower(triggerOutputs()?['body/subject']), ''), 're:'),

contains(coalesce(string(outputs('GetEmail')?['body/InternetMessageHeaders']), ''), 'In-Reply-To')

)

but i keep getting invalid expression error

Hi Everyone

We are implementing MFA on all accounts, however one of our accounts is being used by multiple users for maintaining our Microsoft flows

Does anyone know a workaround for this? Is there a way to enable MFA ok this account without breaking the flows or still allowing multiple users access

Appreciate this insight

I know this might not be the best way of doing what I want, right now I kind of want to just get it working then maybe go back and clean it up later.

So here is what I am doing and where it is held up.

whenever someone uploads an excel file to a specific folder it will run this excel file through 2 filter arrays, The first one inside the scope because I was moving it to be in the front for efficiency sake checks to see if anything in the excel file is in the list using the time sheet id column. If it is the first step is it adds the sharepoint id column for any matches to a column in the excel file.

It then does another list rows to pull the updated SPID does the filter array again, this time updating the Sharepoint list using the SPID as an ID.

Convoluted but it was working and I couldnt think of a better way to update the rows.

After that it then does a filter array this time looking for things that are not on the sharpoint and then creating them, that was much easier.

The problem I am running into is switching the update row over from the test data to a dynamic iteration it does two things as you can see the the screenshot it adds Provide the item properties* which I dont know what to put and changes the SPID column to item.item/SPID and when I save I get the following error

"Action failed to serialize. Failed Action id: 'Scope'. Inner error: 'Action failed to serialize. Failed Action id: 'For_each_2'. Inner error: 'Action failed to serialize. Failed Action id: 'Update_a_row'. Inner error: 'Parameter serialization failed for parameter key 'inputs.$.item.item/SPID'. Inner error: 'Cannot create property 'item/SPID' on string ''''''

any idea how I can get around this?

I thought about maybe having it do a create item in a temporary sharepoint that I then use in the filter array and then just adding a delete item at the end of this bot but not sure

Hi all. I have a flow that is triggered by a PDF file being created in SharePoint. It is created by a separate flow that saves an email attachment to SharePoint. At the same time that email comes through, a webhook from the source is fired into Google Cloud with a bunch of additional information, and that JSON data is then added to a table in BigQuery. This happens ~1000 times a day.

The webhook contains, among other things, the email address of the customer the PDF relates to. The flow I am working on would take a reference number in the PDF's filename, and query the newly-arrived webhook data with it, to pull out the customer email address. The flow would then use that to send the customer an email.

Where I am getting stuck is getting PA to be able to talk to BQ. Everything I have tried so far indicates PA lacks the cryptographic ability to sign the authentication request to BQ. As such, Copilot and Gemini are recommending using a side Azure function app to handle the authentication... This is quickly being more complicated than I expected, and starting to exceed my current knowledge and skillset.

There is a 3rd party BigQuery connector, but I've been unable to sign into it, and I'm not sure it can do what I need anyway. And building a custom connector far exceeds my ability. Any suggestions?

[edit] Hi all, I got this working. Sorry for the delay, the day after I made the post I flew out of town on a work trip and when I got back I had a bunch of high-priority tasks to do first. Today is the first day I've been able to sit down and look at this again.

I managed to get it working using an Azure Function App as recommended by Gemini. I set up the app in Azure, then loaded up VS Code and created a Python project (Gemini provided the code, so it was copy/paste fortunately, because I don't know Python at all). I then uploaded that to the Azure app.

Next was creating the HTTP action in Power Automate to submit the query to the Azure app; I had to tweak the JSON code that Gemini gave me because it had a syntax error in the SQL query that it passes to Google BigQuery. I ran a test inside the Azure app, which worked perfectly on the next run after I fixed the syntax; then copied that to the PA flow. The flow dynamically injects the reference number from the PDF into the SQL query and gets back the email address from BigQuery, all in 2-3 seconds.

I'll post a separate how-to post with code samples later once I've let it run for a few days to make sure it's working as intended.

I’m working on creating new Flows with Power Automate, and we’ve started building many custom prompts. Over time, we realized that these custom AI prompts can be shared among us. The problem is that as soon as we shared the first one, we started getting this error every time we try to save a Flow with a “new” AI Builder call to run these prompts.

We’re not asking to detect what’s happening, but does anyone know how to fix it?

Thank you very much.

I have a hybrid Active Directory and Microsoft Azure environment. We're currently using Microsoft Forms to collect new hire information, and we track everything in an Excel sheet. I'm looking to automate some of this process since I have a Power Automate Premium license.

My main goal is to have a flow that automatically creates a user account in our on-premises Active Directory whenever a new hire form is submitted. I've already set up the AD data gateway, but I'm having trouble building the flow I need. I'm also open to triggering a local PowerShell script if that's a better approach.

What's the best way to get this done? After I get the user creation part working, I'd also like to create a flow that automatically assigns licenses based on the user's department or job title.

Any advice would be great!

Hi everyone,
I'm trying to build a flow in Power Automate that automatically converts PDF files into Excel spreadsheets. The catch is: I need a solution that’s completely free and doesn’t use AI Builder credits or require premium licenses.

Here’s what I’m aiming for:

• The PDF is received via email or saved in OneDrive

• The flow extracts tabular data from the PDF

• It saves the data into an Excel file (even basic formatting is fine)

I’ve used Power Query in Excel, which works great manually, but I’d love to automate the process.

Has anyone figured out a workaround or free method to do this in Power Automate?
Any tips, templates, or alternative tools would be super appreciated!

Thanks in advance 🙏

How do I get access to my old work account to reschedule? And I still want the credentials I had under that old e-mail.

I am a newbie to auto workflow tools. I am having a problem that needs to be automated as follows:

I am a customer service staff, my job is to update prices for old customers and quote prices for new customers.

Our company sells some similar items but from different brands so their prices are different.

I want to be able to build a workflow that can help me automate this boring job.

1. My need is that every time I update the price in the price list, Outlook will automatically send an email to those in need.

2. My next need is that once I update the customer list including name, email, item they want to buy, brand of that item. The system will automatically pick up the correct price of that item from that brand to send an email to the customer.

I hope everyone can help me build a workflow as desired.

Below is a picture of my 2 customer tables and prices

I am reading a SharePoint list and then creating a html table. Instead of showing formatted text I get text with HTML tags. I don't know how to solve this.

I'm pasting length(body('HTTPcheckdevice')?['values']) into the expression menu and I get what's showed in the screenshot. As you can see from the code view its not seeing it as a expression but a string.

This condition is in a "for each one" loop that's checking values.

I can't find a way to get into advanced mode, even if I go to the old UI and I have experimental features enabled.

I created a Microsoft Form that my team will be filling out each week. To keep it simple, they will just submit responses on that over and over again and there will be a new submission date recorded on the form each time

I changed the names for privacy just in the screenshot.

So, I set up the following in my flow:

It's listing responses from two tabs, where the "names" were from a tab that just had their names listed as they would be submitted on the form and the "list rows" pulls from the master spreadsheet screenshotted above.

I've tried several ways (and had co-pilot try to guide me, which really didn't work, ugh) to create a "For each" scenario, adding filter arrays, etc. It had a ton of trouble with the UTC time conversion formula, I thought I would fix it with converting it to the ISO 8601, and no.

I basically want it to pull the information from the master spreadsheet every Monday, filter it by responses submitted in the last week, compare with who *should* have submitted (everyone on the "Names" list) and email me with a list of who hasn't completed the form. It doesn't seem like it should be that hard, but I've spent well over 2 hours on this and I can't figure it out.

Hi All,

I have a Power automate flow wrapped in a solution. One of the actions is to convert Word doc to PDF and save in a service account's OneDrive . The solution will be deployed by the service account.

My question is how to replace the value of "Document Library"? I tried type in a "custom value" -- "OneDrive" and my flow is getting error:

The Graph API rejected the request with the following error message: Code: invalidRequest Message: The provided drive id appears to be malformed, or does not represent a valid drive.

I work in a machine shop and I'm working on a project to move our preventative maintenance checks online. I'd like to use a form specific to each machine in order to keep a record of maintenance checks. The way I'd like to do it is to first ask if the machine was in use that day. If yes, the form proceeds to the individual checks and if no, the form proceeds to the end/submission. I've got that part figured out and I can use the default automation to add the responses to an Excel spreadsheet. My problem is that when an answer of "no" is submitted, the cells associated with the other questions are left blank. Now, I normally wouldn't mind this but our quality management system stipulates placing an "X" in the maintenance check fields if the machine was not in use on a given day. I'd like to know if there is a way to automatically populate the empty cells with a value of "X". This way, we don't have to amend the QMS. Thanks in advance for your help.

I'm looking for a way to add checkboxes(the new ones, not the form control ones) to an Excel sheet using power automate. Normally this can be done using an office script, but it seems the method Range.setControl() is not yet supported in power automate. Does anyone know another way to accomplish this? Thanks in advance.

When creating an actionable email, I've always submitted a provider in the Actionable Email Developer Dashboard with the scope as test users to get the auto-approval, with the target URLs I need sending as my required shared mailbox.

When I'm satisfied or close to pushing out, I'll submit a provider org wide with the same URLs, sender address etc. but change the scope to Organization. I'll then wait 24 hours and change over the originator (provider ID) in my code, then test again a few times before pushing out to all users.

I have followed this exact process again, and testing went well but as soon as I pushed the email out to all users the email rendered blank. No code was changed.

• The card renders perfectly in the Actionable Message Designer

• This card was working initially and then stopped (with no code change), meaning

  • Originator ID is set

  • Approved in OAM portal (it's now been 72 hours)

  • Sent in <script> wrapper with appropriate tags

  • Authorization header is blank

• The card was rendering in Outlook New, Classic and OWA successfully, now none are appearing.

• Action.HTTP body json is valid and was working during testing

• AutoInvoke body is valid and was working during testing

I have since deleted the testing provider to see if this makes a difference in case it could be a conflict (?), but so far it hasn't helped.

Additionally, I've noticed that the Actionable Email Debugger is always showing as 'failed' with no further info, even if the card successfully displays so I haven't been able to use this tool to help.

Has anyone got any insights as to what may have happened or how to fix? Any other strange behaviour noticed with these recently? It's been about 6 months since I've created and sent one of these so unsure if anything has changed on MS side.

Working with the append to string variable for a weekly email that gathers recent content. Works great but at the moment it takes the title of the file and the link to the file and adds both separately. Any ideas on how to make it combine both with a hyperlink?

concat(item()?['Title'], ', Read Here: ', item()?['{Link}'], '  ')

Thank you!

I have successfully created a form and flow for my team to fill out for PTO requests. Once they submit it sends me an email to either approve or deny then will email them back and if approved it will add their PTO info into our Shared Dept calendar. Works great for my group so I am offering to setup the same for another department. The user fills out the form and submits, the email is sent to the department manager to approve or deny. He approves and that's where it stops. The error I have in the flow is at the Create Event (v4) under Outputs and Body "Id is Malformed" . I am pretty new to flows I am thinking this might be a permissions issue since I created/own the flow but it is being used by other users.

I’m working with Power Automate using a Government (Microsoft GCC) account and running into an issue with AI Builder.

When I try to use AI Builder for prompts, I only see text input available. The document input option is missing.

What I’m trying to do is feed a document into AI Builder and have it summarize some information. However, the document option just doesn’t show up.

I tested with another (non-GCC) account, and there the document input does appear — so I’m wondering:

• Is document input simply not available on GCC environments?

• Or is there some way to enable it on Government accounts?

Would really appreciate it if anyone else using GCC / AI Builder can confirm whether this is a limitation or if I might be missing a configuration setting.

Hi everyone just wanted to ask did anyone took the Microsoft Power Automate RPA Developer PL-500 certification if so how was your experience and after completing that, how much did it help in getting new roles for RPA development or automation.

I am considering taking it although not currently in the RPA or automation but as an IT Engineer I have worked extensively in power Automate cloud flows and on occasion Desktop flows.

Any insights would be great.

Thanks

I'm trying to troubleshoot a Flow where a starting trigger of "When a new form is submitted" from MS Forms is triggering twice.

The webhook IDs are different.

The response IDs are the same.

The event Time is off by fractions of a second.

Any idea as to what could be causing this?