/r/MicrosoftFlow
A place to discuss, share, and problem solve all things Microsoft Power Automate formerly Microsoft Flow related. Be sure to check out the links in the sidebar, be respectful, and let's all go with the Flow!
A place to discuss, share, and problem solve all things Microsoft Power Automate formerly Microsoft Flow related. Be sure to check out the links in the sidebar, be respectful, and let's all go with the Flow!
Be sure to check out the other Flow Communities, learning and social media.
/r/MicrosoftFlow
20,959 Subscribers
Compare last with present revision of 60 workitems
Hello I'm working with azure devops and I need to check if a field's value has changed, but I don't think that is possible to insert in a trigger condition (right?).
So I'm thinking of having last and present revisions of the same work item at the beginning of the flow to compare field values.
I know this works, but the client wants to check for changes In 60 different fields, so I wanted to reach out to this group to know if you have a better and more efficient way of achieving this.
19:56 UTC
Invalid Expression error when expression is correct. (Only appears when Change is made down the line.)
So I'm getting this error:
The expression is correct, but I only get the error after I make a change way down the line to my Update Event.
(One that I wouldn't think shouldn't make a difference...?)
When I undo the change, the error goes away.
Is this just a bug in PA?
(Edited to add that Condition Data does not change with Update Event change.)
----------
The Details:
Pre-Update Event Change:
The Condition contains:
Everything saves correctly when my "Update event (V4)" is as follows:
When the flow is in this state, it mostly does what I want but running a Test I get the following:
I had a hell of time figuring out why it was saying it wasn't getting data when there is a Compose (With the input of 'body(Get_Events_(V4)')') right underneath that I use to validate what is getting pulled. The Input and Output from the test is pulling all the info I need.
So, I changed the "Update Event (V4)" to reference this Compose instead of the Get Event.
Post Change:
Condition: (No change)
Thats when I suddenly get the Condition Error.
16:20 UTC
Renaming all files in a sharepoint folder with AI Builder
Hi everyone,
Im working on a flow that looks at all files in a sharepoint folder, runs it through an AI builder invoice template I created to rename (create a new file with the appropriate name that includes the invoice content) and then deltes the previous file.
I tried many things over the last few weeks and nothing works. I have about 380 invoices to rename frequently coming from a PDF document that I split.
At first, I tried to do it with an automatic trigger where, as soon as a file is moved or created in a folder, it would trigger. Apparently that is impossible with Cloud flow.
I then switched it to a manual trigger. I managed to get the files renamed at some point but the file was empty.
I then proceeded to change the flow entirely based on google research but now, the flow seems to work but stops at creating the file for some reason.
I read online using an HTTP request might work but I never figured out how to set it up properly.
Here's a couple picture of my flows...If someone can show me the way... My team is discouraged and I really would like to help them.
BTW, I know my flows are in french...sorry about that...My company blocks me from translating my programs in english :(
I can't use the Desktop Power automate app as the AI Builder isn't available (I'm not premium and won't be able to get it).
14:04 UTC
Flow to automatically forward an email after x number of days
Hi,
I am brand new to Power Automate and I am having trouble with a flow I am putting together.
I've been assigned a task to automate the sending of follow up emails, so I've come up with the below flow. The idea is that the trigger will be when an email is flagged and moved to a folder named 'For follow up'. After a delay of x amount of days, if the email is still flagged and in the folder, the email should be forwarded to the original recipient, and the flow should run indefinitely until the flag is removed & the email is removed from the folder.
The problem I am having is the flow is being triggered twice when the email is flagged first and then moved to the 'For follow up' folder, resulting in the email being forwarded twice. However if the email is moved first and then flagged, the flow works as it should.
Is there a way to make the flow only trigger once, no matter if the email is flagged first or moved first? Or is there a better way of going going about this? Any help would be greatly appreciated!
10:10 UTC
How to import from Share with Me flows to a solution
Hi, I just want to ask how to export from Share with Me flows to a solution. I tried to export my created flow and when I import solution it shows error
“The solution file is invalid. The compressed file must contain the following files at its root:”
Thank you!
01:00 UTC
Testing/debugging flows?
I am still learning the in and out (and many quirks) of making Flows. once thing I can't work out is how to best test nd debug my flows.
The flows i create it mostly to automate emails to lots of people at once, or post in teams groups, but while I'm testing I often find that I need a place to just run the flow and see the outputs. Right now I send myself an email each time but it seems like there should be a better way?
Coming from other programming languages I am used to a debugger or console I can output too while testing, is there something like that I'm missing?
16:41 UTC
Post an Excel file saved on BOX to MS teams every morning
Does anyone have any idea how to create a flow to post an Excel file, which is saved on BOX, to an MS teams channel every morning? I tried to get help from co-pilot but it seams pretty useless 🤣
15:00 UTC
Flow Suddenly Unable to Interact with Application Despite Admin Rights
I have a desktop flow that runs an application requiring elevated rights. The flow has been successfully running multiple times, with the most recent run about a month ago.
However, now the flow opens the application but is no longer able to interact with it. I’ve encountered similar behavior in the past when creating flows without sufficient permissions, but this time, the user account has admin rights, and Power Automate Desktop is being run as an administrator.
The flow itself hasn’t been edited since it last ran successfully. The only change I can think of is that I updated Power Automate Desktop recently.
Has anyone experienced something similar or have ideas on what might be causing this issue?
13:09 UTC
JSON output shown but null in next step
I am hoping this is an easy one for one of you legends.
I have a Webhook on a gravity form sending form data to a flow.
In the flow is a response request catching the Webhooks and outputting the JSON.
The output looks correct, all the data I want is in there and the fields are available as dynamic fields.
In the next step I have Salesforce Create Record to create a lead and I have the dynamic fields mapped to the salesforce create record step.
The problem is that the Salesforce step is saying the fields are null but the output on the response request is showing them as filled.
What am I doing wrong?
Output
{
"headers": {
"Accept": "*/*",
"Accept-Encoding": "deflate,gzip,br,zstd",
"Host": "prod-26.australiasoutheast.logic.azure.com",
"Max-Forwards": "10",
"User-Agent": "WordPress/6.6.1; xxxxxxxxxxxxxxxxxxxx",
"X-ARR-LOG-ID": "e8c03334-3e94-4eda-9566-b94125842baa",
"CLIENT-IP": "xxxxxxxxxxxxxxxxxxxxx",
"DISGUISED-HOST": "prod-26.australiasoutheast.logic.azure.com",
"X-SITE-DEPLOYMENT-ID": "flowfe-prod-ml-rp00-app-01",
"WAS-DEFAULT-HOSTNAME": "flowfe-prod-ml-rp00-app-01.flow-prod-ml-rp00-ase-01.p.azurewebsites.net",
"X-Forwarded-Proto": "https",
"X-AppService-Proto": "https",
"X-ARR-SSL": "2048|256|CN=Microsoft Azure RSA TLS Issuing CA 08, O=Microsoft Corporation, C=US|CN=australiasoutheast.logic.azure.com, O=Microsoft Corporation, L=Redmond, S=WA, C=US",
"X-Forwarded-TlsVersion": "1.3",
"X-Forwarded-For": "xxxxxxxxxxxxxxxxxxxxxxx",
"X-Original-URL": "/workflows/b997319239dd427f93ec0a88b6bf3499/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=DnQuE_4hmlHPCsp-ksg9-Qayd0Y2tLmTqIjUYYtoPSI",
"X-WAWS-Unencoded-URL": "/workflows/b997319239dd427f93ec0a88b6bf3499/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=DnQuE_4hmlHPCsp-ksg9-Qayd0Y2tLmTqIjUYYtoPSI",
"Content-Length": "890",
"Content-Type": "application/json"
},
"body": {
"6": "description",
"8": "",
"9": "0400000000",
"10": "email@test.com",
"17": "Multiple Rooms (e.g. Bathroom & Kitchen)",
"18": "Other",
"24": "",
"id": "11",
"form_id": "1",
"post_id": null,
"date_created": "2024-11-27 06:06:33",
"date_updated": "2024-11-27 06:06:33",
"is_starred": "0",
"is_read": "0",
"ip": "58.96.80.0",
"source_url": "xxxxxxxxxxxxxxxxxxx",
"user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15",
"currency": "AUD",
"payment_status": null,
"payment_date": null,
"payment_amount": null,
"payment_method": null,
"transaction_id": null,
"is_fulfilled": null,
"created_by": "4",
"transaction_type": null,
"status": "active",
"1.3": "First",
"11.6": "Last",
"23.3": "suburb",
"23.6": "Australia",
"1.2": "",
"1.4": "",
"1.6": "",
"1.8": "",
"11.2": "",
"11.3": "",
"11.4": "",
"11.8": "",
"23.1": "",
"23.2": "",
"23.4": "",
"23.5": ""
}
}Schema
{
"type": "object",
"properties": {
"body": {
"type": "object",
"properties": {
"6": {
"type": "string"
},
"8": {
"type": "string"
},
"9": {
"type": "string"
},
"10": {
"type": "string"
},
"17": {
"type": "string"
},
"18": {
"type": "string"
},
"24": {
"type": "string"
},
"id": {
"type": "string"
},
"form_id": {
"type": "string"
},
"post_id": {},
"date_created": {
"type": "string"
},
"date_updated": {
"type": "string"
},
"is_starred": {
"type": "string"
},
"is_read": {
"type": "string"
},
"ip": {
"type": "string"
},
"source_url": {
"type": "string"
},
"user_agent": {
"type": "string"
},
"currency": {
"type": "string"
},
"payment_status": {},
"payment_date": {},
"payment_amount": {},
"payment_method": {},
"transaction_id": {},
"is_fulfilled": {},
"created_by": {
"type": "string"
},
"transaction_type": {},
"status": {
"type": "string"
},
"1.3": {
"type": "string"
},
"11.6": {
"type": "string"
},
"23.3": {
"type": "string"
},
"23.6": {
"type": "string"
},
"1.2": {
"type": "string"
},
"1.4": {
"type": "string"
},
"1.6": {
"type": "string"
},
"1.8": {
"type": "string"
},
"11.2": {
"type": "string"
},
"11.3": {
"type": "string"
},
"11.4": {
"type": "string"
},
"11.8": {
"type": "string"
},
"23.1": {
"type": "string"
},
"23.2": {
"type": "string"
},
"23.4": {
"type": "string"
},
"23.5": {
"type": "string"
}
}
}
}
}UPDATE 1
Added in compose with dynamic field. Looks like its getting null value
09:53 UTC
beginner here, need some help
Hi folks,
I'm too stupid to find the solution:
I want to read a date from an invoice using the AI-Builder, but I keep getting the problem that it doesn't recognize the date correctly. However, if I have the date displayed as a notification, it works, but if I want to change the invoice properties, it does not
Where is my mistake?
Thanks in advance!
08:38 UTC
Is there a character limit for the power automate text input field?
03:45 UTC
Multi-page Power App populating email from Power Automate
I'm in desperate help please!
I have a process whereby a Sharepoint list is updated when someone submits a form created in Power Apps. The form in question has a front page with a question where users can choose a 'type' of printing they need. What they select will then take them to a subsequent page with specific questions.
When a user submits that form, the Sharepoint list is updated, but I need an email to be sent to a specific email address with the details of the new request. I'm getting stuck in Power Automate with how to populate the 'Send email' body field so it only sends information from the specific print type page selected.
That probably makes no sense, but any questions please ask. Help please!
01:29 UTC
Hyperlinks - populate word template action
23:20 UTC
One drive actions not working
Has anyone ran into the issue with One Drive file creation and file conversion not working since Mondays outages? The flow runs successfully but the outputting file information never shows up in the one drive file location. This was working fine.
18:57 UTC
Can you have a document embedded on a question in Microsoft Forms?
Basically building a Microsoft form, one of the questions I plan to ask would require an outside document (specifically an excel sheet) to answer a series of questions. I want to embed the document, either an excel sheet or even pdf into the question (not to have a user upload a file). From what I understand this isn’t possible with forms. Anyone have any suggestions? I’m trying to turn the excel sheet into a one drive link so I can link that, but having issues :(
18:55 UTC
Any Microsoft 365 license that includes Power Automate Premium?
I am a trying to convince my company to get a premium license for Power Automate, for which we currently have a basic version as part of a rather limited Microsoft 365 for Education subscription.
I was wondering, is there any Microsoft 365 subscription plan that includes a premium license for Power Automate or does it always have to be subscribed to separately?
I was hoping that is the case as we might profit from unlocking more advanced/developer features for Excel, Word, Sharepoint and so on, but I am finding licensing guides rather obscure.
18:16 UTC
Using Microsoft Forms to Autogenerate Answers
Hi, sorry if this has been asked before! But essentially I am working on a Microsoft form that ideally would autogenerate sections and questions based on the users answers. For an example lets say I have 6 sections of questions in a single form, if the user selects an answers to the first question (a kind of what do you need question), after that answer, it’ll automatically take that user to that corresponding section and questions based on that first answer. Rather than having like 6 separate forms, it can be accomplished in one.
Is there anything in Microsoft forms, or in power apps, or even a third party app that would allow me to do this?
Please let me know, thanks!
15:50 UTC
Need help creating a Form for Daily Christmass Raffle
Ive created a Christmas calendar for my co-workers and wanted to have a daily QR code they could scan from a Microsoft form that would enter them in the raffle and a random person is picket at lunch time.
I have very limited Power Automate knowledge.
This is what ive gotten so far:
Microsoft Forms
- Created a form:
- Question: "Enter your name to participate in the draw".
Power Automate Flow 1: Add Responses to Excel
- Set up a trigger: When a new response is submitted in Microsoft Forms.
- Action: "When a new response is submitted" from Microsoft Forms.
- Selected the form I created.
- Configured to get response details from Microsoft Forms:
- Action: "Get response details" from Microsoft Forms.
- Selected the form and the question "Enter your name to participate in the draw".
- Added responses to Excel:
- Action: "Add a row into a table" from Excel Online (Business).
- Configured the action:
- Location: OneDrive for Business.
- Document Library: Documents.
- File: Christmas_Calendar.xlsx.
- Table: Selected the table in the Excel file.
- Name: Mapped the question from Microsoft Forms to the "Name" column.
Power Automate Flow 2: Draw a Winner Every Day at 12:00 PM
- Set up a scheduled trigger: Scheduled flow that runs every day at 12:00 PM.
- Action: "Scheduled flow".
- Configured to list all rows present in the Excel table:
- Action: "List rows present in a table" from Excel Online (Business).
- Configured the action:
- Location: OneDrive for Business.
- Document Library: Documents.
- File: Christmas_Calendar_Draw.xlsx.
- Table: Selected the table in the Excel file.
- Generated a random number:
- Action: "Compose".
- Expression:
rand(0, length(body('List_rows_present_in_a_table')?['value'])).
- Retrieved a random row:
- Action: "Compose".
- Expression:
body('List_rows_present_in_a_table')?['value'][outputs('Compose')].
- Displayed the winner's name:
Action: "Compose".
Expression:
outputs('Compose_2')?['Name'].
I get error on adding the names to the file with error:
This won't work because it would move cells in a table on your worksheet.
anyone willing to help? :)
13:19 UTC
Dataverse - Upsert a row - Is anybody using this?
I noticed a new "Upsert a row" action for the Dataverse connector, but I can't figure out how to use it. The row ID is still a required column. How can you upsert if you're required to provide a GUID? That operation has another name........it's called "UPDATING" lol. I'm really hoping I am missing something. Thanks.
13:16 UTC
Downloading Photos from Image columns ins SharePoint using PowerAutomate
Hello. I am looking for a solution to download images from a SharePoint list using Power automate. Although I reach the point where I get all column data, for some reason Image columns don't appear. Any solutions?
10:39 UTC
Check if a dataflow has data
Our dataflow queries from a database table. At times, the database table refresh fails due to overlap with refresh times with its source.
When this failure happens, our dataflows gets blank data. Is there a way in power automate to detect blank dataflow and serve as a trigger to not refresh the semantic model (dataset) using the dataflow?
Thank you so much.
10:18 UTC
Forms attachments to a single PDF
I have a simple form, four questions with background info about the person filling in the form, and a possibility to attach up to 10 attachments.
I want to take the attachments, convert them to a single PDF using Power Automate and no premium connectors. Ideally, I also want to make a sharepoint list with the combined PDF as an attachment.
I am new to Power Automate, so mainly used youtube for help so far.
Any ideas? Thanks in advance
09:22 UTC
MS Form Quiz Score into a SharePoint List (Form sync with excel no longer working)
I have a Flow that recorded Quiz Form results into a SharePoint List that worked great when the sync to Excel was working. There doesn't seem to be any way to use power automate to get the Score from the Quiz Form so the answers I've read on other posts talking about the sync issue aren't helping me.
I was using a Flow that got the responses from the Form, used an Excel Get a Row step to grab the data from the synced excel spreadsheet and then Create item into the SharePoint list using the Get a Row dynamic content which would allow me to get the Total Points from the spreadsheet.
Using the Record Form Responses template works for every other type of flow from Forms to SharePoint but with this particular detail of needing the Total Points response I relied upon that Synced form.
Can anyone help with a simple solution?
I don't know advanced scripts.
Referring to this update https://techcommunity.microsoft.com/blog/microsoftformsblog/update-to-the-new-solution-for-syncing-forms-responses-to-excel/4229844
The flow that worked with forms automatically syncing to excel:
06:06 UTC
Do until not looping through all rows- List Rows Dataverse
I have do until List Rows equal to 0 , however it's only looping until 10000 records. List Rows has pagination turned on and set to 100000. What could be the reason it's only looping twice I have about 18000 records in the dataverse table:
01:49 UTC
Send email for FOLLOWING month
Hi everyone, I'm a bit stumped. I have an excel spreadsheet with expiring projects. I'd like to send out a list of the expiring projects to the corresponding manager the month before they expire. E.g. On May 15th, I'd like to automate an email listing all the projects that expire in June. Any suggestions?
01:29 UTC
Get emails (V3) returns only a few emails when it should return more
I'm creating a flow that gets some emails, then saves each email into onedrive.
What I've noticed is that the "Get emails (V3)" module often returns very few emails, for example, my search query is "from:someone", there should be hundreds of emails that match the query, but it only return around 3 emails.
It seems to me that the response of "Get emails (V3)" contains the entirety of matched emails, so maybe there is a limit to how large the response can be? for example, when an email is huge, it will only return this one email and not include the other emails that also match the search query? Could this be the case?
Is there a way to make "Get emails (V3)" return 25 emails (which is its upper limit)?
00:23 UTC
When excel file is added to a folder - make list item help
Hello! I'm new to using power automate and I'm trying to create a flow that works like this:
- an excel file is added to a specified folder
- the file content is extracted
- a new sharepoint list item is made from the content
I know that I'm missing steps but I am having a very difficult time finding out what those steps should be. Can someone point me to the tutorial I need, please? Thank you!
18:18 UTC
Flows slow to download/launch.
Hey. I have a simple flow that clicks a few buttons in a window on my desktop. The flow itself executes very quickly, but the time between I hit the hotkey combination, and the flow actually starts executing is often like 10 seconds. I will press the hotkey, and maybe 5 seconds later I'll get the popup that says "downloading flow", and then another 5 seconds later, the flow will actually run.
Is there a way to speed this up?
14:48 UTC
Automation testing in Power Automate
Hi fellow devs, My team recently started working on automation testing for PowerApps (MDA, Canvas, Pages) and we also want to do Automation testing in Power Automate.
I know there are different scenarios in a Flow but is it really possible to do for automated and scheduled flows because instant flows with trigger on screen can be handled in testing the app
14:16 UTC