Stack Overflow
Stack Overflow

Questions tagged [power-automate]

Microsoft Power Automate (formerly Microsoft Flow) is a business workflow automation tool. Use this tag for questions about issues or questions regarding building/designing Power Automate workflows, configuring them to work with additional applications in the MS Power suite, or with other MS products like Office or SharePoint. DO NOT use this tag for questions about license issues with Power Automate

Microsoft Power Automate (formerly Microsoft Flow) is a business workflow tool for automating workflow processes in an online environment. It connects with other Microsoft Power apps, Microsoft Office products, SharePoint, external services such as Twitter, Facebook, and on-premises environments to communicate with applications like SQL or Excel.

Links

2180 questions
2
votes
0 answers

Microsoft Flow - Get Query Result (DevOps) ordered hierarchically

I'm facing the problem that the result of a DevOps query in microsoft flow is ordered by ID - which is not the sorting that I see when I'm executing the same query in DevOps itself. Is it possible to get the hierarchically ordered result of the…
bloC
  • 526
  • 3
  • 16
2
votes
1 answer

How to strip HTML from RSS to Yammer message

I created a Flow that publishes RSS to Yammer. The RSS feed contains Azure DevOps status updates, provided my Microsoft. Flow definition: Actual result: Question: How can I publish this RSS message without HTML tags in the message output?
Bernard Vander Beken
  • 4,848
  • 5
  • 54
  • 76
2
votes
2 answers

How can I pad a string with a variable number of leading zeros?

We have this formula in our MS Flow - Update Item task... concat(items('Apply_to_each')['T_x002d_Code'] ,'-' ,items('Apply_to_each')['BoxNo'] ,'-' , items('Apply_to_each')['ID']) but we need to add leading zeros to the BoxNo and ID so it ends up…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
2
votes
2 answers

MS Flow: SQL Server Get_rows - We cannot apply operator < to types DateTimeZone and DateTime

Problem I am trying to write a simple Flow that gathers some rows from my SQL Server database and sends the data to me via email. However, I am having trouble filtering these records by date. I want the Flow to only retrieve the records from the…
Tanksley
  • 57
  • 10
2
votes
1 answer

Save password protected pdf file from outlook using Microsoft flow

I'm trying to automate saving of attachment from outlook.com using Microsoft flow. The attachment in question is a password protected PDF. I tried using Attachment Content as value for File Content in Onedrive Action Create File It gave the…
Alen Alex
  • 897
  • 4
  • 15
  • 31
2
votes
1 answer

Microsoft Flow hyperlink not working in Outlook client

Good morning I'm quite new to MS Flow and I came across an issue that I just can't find a solution for. I created a flow for an approval App in PowerApps and added a Link to the item on the email that is received by the person that needs to approve…
Dewald van Wyk
  • 21
  • 1
  • 3
2
votes
2 answers

Get first json element with specific ID in a JSON array - Microsoft Flow

I have a Parse JSON action with following schema: { "type": "object", "properties": { "employees": { "type": "array", "items": { "type": "object", "properties": { …
NoName
  • 7,940
  • 13
  • 56
  • 108
2
votes
2 answers

Hide "Created By" from Flow Approval e-mail

When the Flow Approval is generated, an automatic email sent to approver contains two variables: Requested for and Created By. Requested for is a person that requires the approval. Created by is a person that designed the flow and this variable…
Kirszu
  • 354
  • 3
  • 11
2
votes
1 answer

Microsoft Flow - Excel File Get Rows - Large Excel File

I am a newbie for using Flows with Excel and while Connecting Excel to Flow over SFTP, I get the below error : {{Could not retrieve values. File size above allowed value. File size:15944460, AllowedFileSize (in Bytes): 2000000.}} It says my Excel…
Mufaddal
  • 558
  • 5
  • 24
2
votes
0 answers

How to set up a microsoft flow connection to SQL server

I am attempting to set up a MS Flow to add data to my SQL Server database. To set up the Flow Connection there are only six items: Connect via on-premise data gateway Connection Name SQL server Name SQL database Name Username Password However,…
user918967
  • 2,049
  • 4
  • 28
  • 43
2
votes
2 answers

How to specify ODATA filter query for the salesforce connector in Microsoft Flow

I'm having difficulty determining the correct format for a date (not a datetime) expression. In this situation, CloseDate from the Opportunity table. I have tried multiple formats, including quotes, no quotes, timezones, no timezones. I have this…
Craig D
  • 487
  • 1
  • 5
  • 17
2
votes
2 answers

Microsoft workdflow custom connector

I am trying to develop a simple customer connector for my website on microsoft flow and so far I can't see how to use a web API that is hosted on my website every article tutorial I am coming by require APIs to be hosted on Azure, also an Azure…
Miroo
  • 795
  • 3
  • 13
  • 35
2
votes
1 answer

How to retrieve last row from Excel Online in Microsoft Flow?

I am trying to retrieve a new record inserted in Excel Online through Microsoft Flow. The new record is inserted as a last row in the Excel. Is there a function or expression which I can use in Get Row action of flow?
django-unchained
  • 844
  • 9
  • 21
2
votes
1 answer

Microsoft Flow mapping values dynamically

We are connecting one our applications to Microsoft Flow. To achieve one of our functions we need to have Microsoft Flow serve outputs to dynamic data. Let me explain what I meant, { 'Firstname': 'John', 'Lastname': 'Doe' } if this is the…
Kamal Rathnayake
  • 514
  • 3
  • 29
1
vote
0 answers

How to do I resolve Power Automate Cloud Flow Error Status Code 302 HTTP

I have a flow where the following is taking place Query an SQL Database and retrieve a dataset with 21780 records Parse the ResultSets.Table records over to JSON Using HTTP connector perform POST to an Excel worksheet This has worked in the past…
Geovani Martinez
  • 2,053
  • 2
  • 27
  • 32
1 2 3
…
99 100