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
3
votes
0 answers

Why do i get a "BadGateway" Error When Running the Excel Online "Run Script" Action in PowerAutomate?

I have recently being using the new Office Scripts function on Excel Online, and when i have tried to connect this with flow and try to run the script, it results in a BadGateway Error, after it retries twice BadGateway Can anyone help with this? { …
johnk3
  • 31
  • 3
3
votes
3 answers

How to convert json to collection in power apps

I have a power app that using the flow from power automate. My flow is doing an HTTP get and respond a JSON to power apps like below. Here is the JSON as text: {"value": "[{\"dataAreaId\":\"mv\",\"AccountNum\":\"100000\",\"Name\":\"*****L FOOD…
OguzKaanAkyalcin
  • 621
  • 2
  • 8
  • 25
3
votes
1 answer

Using a Power Automate flow, how do I convert JSON array to a delimited string?

In Power Automate I am calling an API which returns this JSON: { "status":"200", "Suburbs":[ { "ID":"1000", "Name":"CONCORD WEST", "Postcode":"2138" }, { "ID":"1001", …
Doug Maloney
  • 103
  • 1
  • 8
3
votes
1 answer

How to create a WorkItem in Azure DevOps based off new email in Shared Inbox, but replies to emails stay within same task

I'm currently trying to set up a workflow within Microsoft Power Automate to do the following: If an email is sent to a shared email box create a new task in DevOps If someone replies back to that initial email - any responses to that thread will…
laxurent
  • 75
  • 6
3
votes
1 answer

Python Script in Power BI and Power Automate

I'm pretty inexperienced with Power BI and Power Automate so apologies if there is a simple answer to this question (I couldn't find it at least). I have a python script that takes data from some excel files, creates a few dataframes, and then…
Hugo Artus
  • 53
  • 4
3
votes
3 answers

Get all Files in a folder using Microsoft Graph API

Requirement - Need to access a particular File within a Document Library File Path - host-name/sites/sitename/Shared Documents/Folder1/File1 I tried with these https://graph.microsoft.com/v1.0/sites/{host-name}/sites/{site-id}:/drives Got all the…
Giri Damodaran
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

Adding a dynamic link to Microsoft Teams message

I'm using Azure logic apps to post a Teams message (using v3) to a channel that we have upon a trigger. When I'm trying to add a dynamic link to the content that I'm posting - it fails. If I use an example message like below, where the SomeAction is…
Mavi Domates
  • 4,262
  • 2
  • 26
  • 45
3
votes
1 answer

How to loop through an array in a logic app?

I have managed to get all my userdata in an array (see here) but now I cannot loop through the data. After building the array I have converted it to JSON, but I can no longer address the fields as defined in my JSON schema. The only thing I can…
Martijn Balink
  • 35
  • 1
  • 1
  • 5
3
votes
0 answers

Encode a JSON message so that it fits into a JSON value in Microsoft Power Automate

I want to add a JSON message as a value in the other JSON message in Microsoft Power Automate. In more details, I have a flow that is storing a JSON message in Azure Queue storage. This message will be parsed by another flow which is sending an…
aragorn
  • 187
  • 3
  • 18
3
votes
1 answer

Microsoft Dynamics 365 bulk update/import via Microsoft Flow

Is there a way to perform a bulk update from an CSV file into Dynamics 365 via Microsoft Flow? I have been looking at the following capability that was supposed to be released (September 2019), but could find the "Batch" action anywhere under…
noobie
  • 2,427
  • 5
  • 41
  • 66
3
votes
3 answers

Handling (read) of Base64 encoded files in a Logic App, and post to endpoint

I have a Logic App that gets the contents from a SharePoint (.xlsx) and posts the body to an endpoint to get processed. now the content I see is a base64-encoded file, what I wanted to do was to post this data as is. when I try to post it using…
Ipkiss
  • 721
  • 2
  • 15
  • 27
3
votes
0 answers

Power BI export to PDF automation

So my company won't pay out for Power BI to every user in the business. I have Power BI Pro, I have a report that I wish to create a PDF copy and sent to various recipients. Problem is that I need the data to update to each recipient which has their…
Phil Collins
  • 327
  • 1
  • 4
  • 13
3
votes
1 answer

Where to find Audience and Client id fields to use in Microsoft Flow's Azure REST API call?

I am trying to call a CDN Purge's Azure REST API url from Microsoft Flow. I found HTTP - HTTP as the best action to use as Azure with HTTP sounds to be specialized on accessing resources not on (just) calling. I created a Web app / API…
alik
  • 2,244
  • 3
  • 31
  • 44
3
votes
0 answers

Could not create SSL/TLS secure channel - Connecting Microsoft Flows with HTTP request

I am a new user for Microsoft Flows. I have a requirement for Connecting the Microsoft Flow with HTTP Request. When connecting the HTTP Request, I am using the Client Certificate with the .pfx certificate file. I am using the below format : { …
Mufaddal
  • 558
  • 5
  • 24
3
votes
1 answer

Generate JSON schema

Im trying a setup a Microsoft flow. In short, I need to take JSON data retrieved from a device, and parse it so that i could reference it in the Flows below. In order to parse, i need to provide the JSON Schema to Flow. Microsoft Flow has an option…
Joe
  • 165
  • 2
  • 13
1 2 3
…
99 100