Hello, I manage a report that we will call the "Setup Sheet" for this. I receive a weekly "Inventory Report" via email every Monday that includes products and their on-hand quantities. I have a Power Automate Cloud flow that receives the email attachment, filters out .png attachments from email signatures and only keeps .xlsx attachments. It then saves the file into a specified OneDrive/SharePoint folder. I also have a Power Automate Desktop flow that when I manually run it, checks that folder for the most recent file, opens it, runs a macro that formats it, and then saves and closes the file. Then in the "Setup Sheet" I have a Power Query that refreshes data anytime the file is opened, and it checks for the most recent file in the folder and pulls the Quantities column from the Inventory Report.

All 3 of the above processes work separately, but I am encountering errors when I try to use the "Run a flow built with power automate desktop" at the end of the Cloud flow so that I do not need to manually run the Desktop flow. I have worked with ChatGPT, Co-Pilot, and any other resources I can find, and I cannot figure out a way to get that action to work. I keep getting an error and when I look it up it says it is because my device is not connected to Microsoft Entra or AD domain. Except, I have worked with my IT Admin and confirmed that my device is connected to Microsoft Entra and AD domain.

I am curious if anyone can offer a work-around that does not require me to deal with Microsoft Entra permissions, or if what I am trying to do can be done in just the cloud or desktop versions. From my understanding, I don't think I can, since opening an Excel file from a Sharepoint folder opens it into Excel Browser, which does not allow Macros, which is why I have the Power Automate Desktop flow to achieve that. (unless there is a way to specifically open it in the excel desktop app?)

Hey guys,

I try to make a condition where the mail body is checked to see if any of the words in an excel column is contained.

My approach so far:

list rows present in table -> append to array variable -> for each mail(condition(mail body contains Array) -> if true action -> terminate)

Somehow it doesnt let me save with terminate in the loop.

Anyways, I think there might be more problems and room for approvement. Any tips or links to guides that might help here?

I'm creating a travel form that is giving me an error I can't seem to fix. Here are the steps Im trying to do. Snapshot and error message below.

1. User submits request in an app that stores data in a List
2. Data from List is entered into a Doc and converted to PDF
3. PDF is sent to manager with an option to pick who the approver is. They can also update the list data if needed.
4. Updates are received, and repopulated into a Doc than PDF again.
5. New PDF is sent to approver through an Approval process.
6. Response is updated on List, and new repopulated into Doc than PDF again, and sent out to requester.

I get an error for the Update item on Approval/Denial step for a People field that allows multiple selections. I also have the same flow running in another office but it has one less Update/Doc/PDF step, which I dont see why that would be an issue.

I've added the people field from the Get item Any updates step, as well as custom coded attempts to just send the emails or claims, but nothing works. Let me know if I didnt provide enough info or if you would like to see the input/output code. Thanks for any help you can provide. Been working on this most of the day without any bit closer to a resolution.

https://preview.redd.it/g6du4kh8qdge1.png?width=670&format=png&auto=webp&s=fa30d5952cff0c5c1a2c9fbd51e3fefdf3359b7a

The 'inputs.parameters' of workflow operation 'Update_item_on_Approval' of type 'OpenApiConnection' is not valid. Error details: The API operation does not allow writing a value for parameter 'item/PersonnelNames[0]/DisplayName'. This parameter is read only.

I have a power automatic desktop flow all setup which accesses data from an Excel worksheet in my desktop and and fill up an external Mark Entry Portal through Google Chrome.

I want to run this all in background using power automate cloud.

Q.1 Is there any way that I can transfer my desktop flows to the cloud?

Q.2 how do I declare %Excel instance% in power automate cloud? N.B. I cannot get the data extracted from my Excel sheet (Hosted in Onedrive) to my Cloud flow.

View Poll

Hi i'm struggling a bit. I want to create a flow which when i get a specific e-mail with an attatched file -> go search in a table and search for an email-adress -> send the the same atteched file to the new email adress. This flow is working but the attached file is blank when it comes out in the other end. Any suggestions?

Hello,

I'm hoping someone might be able to help me. I've literally spent days googling this, using Chat GPT and Co Pilot, watching videos and reading forums and am getting no where.

I'm trying to create a power automate flow that will get a variable number of CSV files saved in a SharePoint folder, and simply combine all the rows (and the headers) into either a new CVS file output, or, put the rows of data into a blank excel template (which already contains the column names).

But after creating various loops, variables, compose actions, I'm getting nowhere with this :(

Does anyone have any experience of doing this, or can point me in the direction of any resource to refer to (albeit I feel like I've scoured the entire internet at this point !) ?

Any help would be much appreciated!

I've got a Flow where I'm using a filter query to pull items from a Sharepoint list where data in a certain field matches what has been submitted in a Form. This is working fine.

I've tried using the expression length(body('Get_items')? ['value']) to check if there are any records and this appears to be working too.. there is either the record it found that matches in the outputs value section or it just has [blank]

The issue comes when I use the result of this in a condition... if the result of the logical test is that there was a record, it goes on to do what it's supposed to do next... in this case send a specific email to someone. BUT, if the result of the logical test was that there was no result, the Flow just stops and doesn't go on to send the email specific to this scenario.

I have tried using the length expression directly in the condition and also by using the compose action instead, then using the result of this in my logical test, but to no avail.

I'd be grateful if anyone has any ideas why one side of my condition isn't working.

Thanks!

Hi guys,

I have troubles to get together FLOW.

I have a Share point list with some data which looks like this:

The data set will have more than 200 rows. For every entity there are assigned two rows from column Account and one email. But to one email 2 or more entities may be assigned. I want to achieve, that Power Automate would take data from Share point list, group rows by entity and send it to assigned mail. The problem I am facing is that I am sending all data to one mail. So receiver in this case gets table like you can see above. But I want to achieve that receiver would get two separate mails: for AE10 and for BE10 separately. And once he accept/reject those data his answer will be recorded back to mine Share point list. I know this might seem easy, but I am new to this and cant really figure it out I tried chatGPT but no help....

Thank you for help in advance! :)

https://preview.redd.it/b00wpvlq5bge1.png?width=688&format=png&auto=webp&s=295c9364615ee46d565ec0924b3cf161d3969811

https://preview.redd.it/0gxy0hos5bge1.png?width=724&format=png&auto=webp&s=abef5bebc82480c26abf4bf0c18d25ad3c303b32

https://preview.redd.it/u0ul1f1w5bge1.png?width=578&format=png&auto=webp&s=bc2aa16c7233e2bdc2fe473c392328b1ebfc7d74

Hey everyone. I have a successful flow that runs a script on excel files uploaded to our SharePoint automatically. What I am having a hard time setting up and understanding how to set it up, is changing the file name once the script has ran. This is the current flow I have.

https://preview.redd.it/tyypaygp3bge1.png?width=1341&format=png&auto=webp&s=73e9f241d51ab164c44d4661d3001aa65e6cd631

The file is being created but when I open it there is no content. Any direction would be appreciated.

Hello everyone, I am trying to send data via the Http request, i.e. the graph api, because add rows in power automate cloud is too slow for me. The following data is displayed as input from the select step to the http step: 

"Uri": "https://graph.microsoft.com/v1.0/me/drive/items/b!Sw97P6uTlkuYM55gApDo8D7imNEbejdIoJJXx9SGs3nXb3e70q9iQaN9n2dvtsCu.01ZHA3RDX53JP6AZFAAJHYOK377UXARWIC/workbook/tables/Tabelle1/rows","Method": "POST","Body": "{\n\"values\": [{\"Umsatz\":\"1111\",\"Bu-Text\":\"test\"},{\"Umsatz\":\"26.59\",\"Bu-Text\":\"test\"},{\"Umsatz\":\"1056.13\",\"Bu-Text\":\"test\"}]\n}","ContentType": "application/json"}
Code view:

   "type": "OpenApiConnection",   "inputs": {     "parameters": {       "Uri": "https://graph.microsoft.com/v1.0/me/drive/items/@{outputs('Copy_file')?['body/Id']}/workbook/tables/Tabelle1/rows",       "Method": "POST",       "Body": "{\n\"values\": @{body('Select')}\n}",       "ContentType": "application/json"     },     "host": {       "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365users",       "connection": "shared_office365users",       "operationId": "HttpRequest"     }   },   "runAfter": {     "Select": [       "Succeeded"     ]   } }   

In the Uri after items i use the "Id" identifier for the excel i wanted to write.This is the output messages.Headers: 

{"Transfer-Encoding": "chunked","Vary": "Accept-Encoding","Strict-Transport-Security": "max-age=31536000","request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03","client-request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03","x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"Germany West Central\",\"Slice\":\"E\",\"Ring\":\"4\",\"ScaleUnit\":\"000\",\"RoleInstance\":\"FR1PEPF000018E6\"}}","x-ms-environment-id": "default-e10a9c97-6c83-4090-b7be-56eefcc121c7","x-ms-tenant-id": "e10a9c97-6c83-4090-b7be-56eefc21c7","x-ms-dlp-re": "-|-","x-ms-dlp-gu": "-|-","Timing-Allow-Origin": "*","x-ms-apihub-cached-response": "false","x-ms-apihub-obo": "false","Date": "Fri, 31 Jan 2025 08:48:30 GMT","Content-Type": "application/json","Content-Length": "283"}
body: 

{"error": {"code": "invalidRequest","message": "Invalid request","innerError": {"date": "2025-01-31T08:48:31","request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03","client-request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03"}}}

Even with this URI i tried it and its not working:   "Uri": "https://graph.microsoft.com/v1.0/me/drive/items/split(actions('Copy_file')?['inputs']?['parameters']?['file'],'.')?[1]/workbook/tables/Tabelle1/rows",.

Does anyone know what might be causing this issue or how I can resolve it? Any help would be greatly appreciated!

Thanks in advance!

https://preview.redd.it/8np5f1unwage1.png?width=610&format=png&auto=webp&s=2055cd92f2608aa4442afed0bc5adf6ef2cdda35

Okay, so there are definitely higher level solutions for my work being so repetitive that could be fixed with better systems/processes, but I am a low level employee and I don’t have any say in changing things. If you have an easy to implement suggestion, I’d be happy to hear it just in case someone ever asks my opinion, but I’m not holding my breath lol.

Here are my two major duties:

1. Manage the review/approval of documents/contracts from our contractors

• I receive an email with the item/s to be approved
• I review the items to see what subject matter experts within my company need to review/approve and then forward them out.
• SMEs respond back with either approval or comments.
• if a SME doesn’t respond within a certain time frame, I send a follow up email.
• once all SMEs respond, I send either approval or feedback back to the contractor
• if there is feedback, the contractor will revise the items and send them back, restarting the process.
• all of this correspondence must be uploaded to onenote.

2. Manage resolution of contractor’s consumer issues.

• issues come to me from a wide variety of sources via email.
• I forward the issue to the appropriate contractor and ask for it to be added to a log and regularly updated until resolved.
• some issues are escalated and require a response/update from the contractor within 48 hours. I have to keep track of those and follow-up if they don’t respond quickly.
• I upload any correspondence between myself/my company/consumers/contractors involving said issue to a specific section in onenote.
• the contractors sends excel spreadsheet logs weekly with updates on each of the issues.
• I have to manually add the updates to the previous updates on a notes page that is created for each issue in the same onenote section that I upload correspondence to.
• I read each update and determine if the issue can be closed or if we need to ask the contractor to take a specific action. I make notes in onenote and then we go over the updates in a joint meeting and I make any recommendations.

I appreciate you if you read all of that! Thanks in advance for any advice.

Im trying to update my data row here.

https://preview.redd.it/9rvdgd1dd8ge1.png?width=1010&format=png&auto=webp&s=0cd6200423f52f62a1a30e655782b84040bcdcd8

Like this

https://preview.redd.it/9ugwcdeid8ge1.png?width=756&format=png&auto=webp&s=237f5ace853491d3d3ebfb62b54d578876eed2f8

but i have error output arguments cant have trailer.

this is my flow

https://preview.redd.it/x43wx5yld8ge1.png?width=1771&format=png&auto=webp&s=dca58bc7fd514504fa1d3ab4c10d7992570b7ebb

Hey, I have a flow which generates a report of filtered rows within a table of an Excel file on SharePoint. Each year I have to update the flow with a new file, but I'm hoping to adjust the flow so I won't have to anymore. (See attachment) 

For context, I have a folder within a SharePoint library. Each year, I create a new subfolder (2023,2024,etc), and within each one there is an Excel file. Each Excel file has a table (Orders) in it. For my current flow, I filter the columns "DaysOnSite" and "DatePickedUp" to generate a new file with applicable rows.  

I would like to have the flow look through the subfolders within the SharePoint library for any Excel files (.xlsx), and for each one: get tables from them, list rows present in any table called "Orders" ... then I should be able to also use For each to build in my current flow. If possible, I'd also like to append to each row the name of the file the row came from.  

Please let me know if you have any suggestions! 

Hi everyone,

*total power bi and flow newbie here so go easy on me :)

Im trying to generate weekly emails of data i'm getting from powerbi. I used a visual table and got the dax query from that. Then using that --> parse json --> create html table.

My problem is that in the create html table i can't select individual columns. So i'm guessing i'm inputting the data in wrong somewhere. Again.. newbie here.

I've posted this in the MS power community which explains my issue.

any help would be appreciated.

Using Power Bi data to generate weekly reports to send out by email

Hello everyone, So, I am trying to get a workflow going to automatically answer to mails and meeting invitations.

I already works with condition and a single string. Bu I would love to get it done that it gets all the possible words from an excel file.

I tried some things with get workstheets -> get tables -> list rows present in a table but I cant get the comparison.

I dont have any computational background so, I cant code. What can I do to get this done?

Thanks in advance!

Is there a way to crop receipts from one pdf page. I have sometimes 2 or 3 or even one receipt in pdf page order can be shuffled as some person uploads in such way. Is there any way extract text from each receipt present in one pdf page. Like crop the text from each receipt

I'm an individual that has made a simple microsoft power automate flow to help me post comments on my own post in a group (it's a group that sells used clothing and they have specific rules on how to list each as a comment). It saves me a lot of time.

I've created randomized wait times in between each step however FB has given me a warning that they detected automation.

Is there no way to avoid detection? I thought randomization would help - perhaps I need longer wait times? I do not want to risk my account getting frozen as it's my personal account and I'm really just looking for a way to save myself a little bit of time.

Hello,

I need help with a flow.

We have a sharepoint list where last column is as yes/no. Each row has its own email. We need to send email with options to that email in the row also with the rows data, so when receiver gets it, he can click yes/no in that email and it will be uploaded to that yes/no column.

1. Get data and email from the row

2. Send email with options with the data to person's email in row

3. Collect the response (yes or no) and upload/update it in our SharePoint list to last yes/no column

Hi everyone! I'm relatively new to powerautomate and I'm having some trouble with a flow that I'm working on. Essentially, I'm trying to create a flow that takes data from two sharepoint lists (one list has the columns "Person", "Department", and "Access Rights", and the other list has the columns "Department" and "Contactperson". I need the end result of the flow to send an (individual) email to each contactperson of each department, containing a table (also having issues with this part as it is not a predefined amount of rows, it depends on the amount of people per department) with all the people in that department along with their corresponding access rights. Might be useful to add that I'm also not sure how to reference columns of the sharepoint lists... Any suggestions on how to do this? I am really lost. All suggestions are appreciated! Thanks in advance

I'm trying to get more organized with completing assigned tasks in my email, but I can't seem to add a clickable link to reference the original email. The task only shows a basic subject line without any details from the email body. I've tried multiple ways to include notes, but there’s no option to add them in the task or description. Any help would be greatly appreciated!

https://preview.redd.it/o6dj69nm42ge1.png?width=743&format=png&auto=webp&s=7646e811ca322614f124c13e2214539d931d2c02

https://preview.redd.it/9uudsvk042ge1.png?width=675&format=png&auto=webp&s=5843436b3da2b6d50fbe99a5ef534f37fc9beacd

I am trying to coordinate availability for various events throughout the year. I want the managers/leads to fill out availability of their employees. The key is I want to have automatic email reminders sent out if they haven’t filled out the form.

I tried to use a “list all shifts”, get the user ID, and then put that in “get manager” or “get user details”, but it fails. My thought is if the manager isn’t found, the email can keep being sent out.

Any other ideas how I can get something smart enough to know if leads filled out their teams availability so email reminders can be sent?

I have a flow (from my question earlier today) that has nested api calls. I have two variables that I am attempting to output to a file i can pull into PowerBI (so if you have an alternative that's not a string I am open to that but I couldn't get a csv or a xlsx document to not create a corrupted version).

I have two string variables that I am attempting to append an array (output of select) to in the "for each" loops. However, the only data available is the output of the last loop for both files. I am not sure what I am doing wrong as they are within the loops, so I assumed each loop would append.

I have checked each individual loop and all of the correct data is pulling in, and within each loop the append has the appropriate values for that loop, but once I compose the variable outside of the loop it only has the last loop's data.

Compose formula is json(replace(variables('Data String'),' " ][" ' , ' " , " ')) because my latest attempt was to output to a .json value

(Top right is continuation from bottom left in picture)

how do I to setup a power automate Flow so if a status of an item in Sharepoint list changes to something like Obsolete, Broken, or sold then the whole row of that item will be removed from existing Sharepoint list and added to a excel list

I need to set up a call to a vendor for some data. The way they have their endpoint set up i need to first call for all of the location IDs of ours, then using those individual IDs call for all of the equipment IDs in each location, then from there I need each pairing of locationID and equipmentID to call for the data itself.

I am struggling to figure out how to accomplish this. I can call for the buildings with no problem, then have a "For Each" to call for the equipment, but I'm not sure how to get the flow to retain the locationId and equipmentID into another, nested "For Each" to make the call for data for each piece of equipment and append it all together.

I brought Power Automate to my organization for supervisors in my organization to approve submissions from their team. These submissions on a Microsoft Forms have a file attached to them. When the supervisor receives the approval in Microsoft teams, the flyer is not viewable. For now, I've just given them access to the folder in my one drive. However, please help me fix the flow I've built so that the flyer or any attachment is clickable and viewable within the approval the supervisor receives. Photo of the flow I've built is attached.

The 'apply to each' selects the outputs from the compose action, uses get file content to pull the content from my one drive and then uses the 'append to array variable' to pull that content into the array (as I understand it.) However, when I add the variable to the 'start and wait for approval action' I get the following error message: : 'InvalidAttachmentName'. Error Message: 'The attachment name '<null>' is invalid.'

So basically I have no idea what I'm doing. Please help, or please let me know if more information would be helpful.

https://preview.redd.it/alxlx8r8jzfe1.png?width=624&format=png&auto=webp&s=237e3438d8eaef2a70d1ccf3d6726e8a5df465fd

Hey guys, I really need your help I have created some flows for my company and they want me to add a variable at the beginning of the flow (after recurrence) that when the flow is running as scheduled based on recurrence Will return a value automatic but if a use Wil click on top right corner test and run it manually to return manually.....I have try a lot of different expressions but either they return manual In both scenarios or return automatic in both scenarios (the variable will be used as an output in an excel action) please does anyone know a simple way to do this? Thank you

Hi everyone, I'm learning Power Automate to create an automated workflow to collect feedback from our organisations' workshops using Sharepoint MS Forms.

Goal: To collate feedback data across our different classes' workshops (e.g. Analytics class, Soft skills class, etc.) in a PBI dashboard

So far, I've managed to create a scheduled workflow that collects the feedback data stored as Excel files (i.e. when you click on "Open in Excel" in MS Forms) into a Sharepoint List.

Flow: Triggered by "Recurrence"; first action is "List folder (SharePoint)" action, then "Get file content" (within an "Apply to each" loop), then "List rows present in a table", and into "Create item" to add them into a Sharepoint list.

However, this solution requires other people in my department to actively create Excel files of their forms' responses once they have feedback, which isn't fully possible given that 1) they tend to make the form and leave it on its own after being newly created, and 2) there's no "Open in Excel" option for newly created forms.

I've tried looking up different ways to collect feedback data without relying on actively created Excel files in Sharepoint, but am really lost. I've found solutions like using MS Graph API, but that requires: 1) org. approval which can take a while in my organisation, and 2) time to learn, but I have a small timeframe to create a POC. To add on, there's at least 50-100 forms created in every financial year, so it wouldn't be possible for me alone to create a flow for every single form; and that each class would have 3-4 unique questions, i.e. not all classes will share a 1:1 template.

I hope you guys can help me out with this as I am really lost, and I am fairly new to Power Automate :(

I have a pretty simply flow that is emailing some people. It was erroring occasionally because the users can decide to turn off the email with a user property setting defined in an SP list.

The flow was failing when all possible recipients turned the flags off.

So I added a Condition to check if the Items returned was empty but the check fails.

I have a Get Items action that works correctly. In this scenario, it returns an empty array. The actual body of the output is:

{
  "value": []
}

The Condition check is this:

outputs('card')?['body/value'] in not equal to ""

With the double quotes representing nothing at all being in the Choose a value section of the property.

The condition check is returning a true when I expect it to return false.

Any idea why?

I have a desktop flow that I created a shortcut for on my desktop. If I run the flow from the PA window it starts quickly, but when running from the shortcut it could take 15+ seconds to start running. Is there anything I could do to minimize the delay?

I know I can use the various "Send Email" actions to send email from a Flow. However, the gotcha is I need the "from" email to be the email of the person completing a form. That requires the Flow owner has "send as" permmissions for every user who may use the form. Not a great idea, especially in a high security environment. Are there any ways around this? Can a Power App do this? Any creative solutions (One cludgy idea is to have it send to the person's email then have them forward that email to where it needs to go).

The big picture is I'm looking to build a form for people to request IT help. In some cases it is handled internally and I have it opening a ticket in our internal IT Help Team (creates a planner task). However for level 2 and up incidents it goes externally to a third-party. Their ticket system assigns the contact based on the email address it is from. They won't want a flood of tickets from the service account I'm using to build the form/flow.