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
1
vote
0 answers

remove illigal char in power automate output from base64ToString

I have created a workflow in power automate where I'm decoding a base64 encoded xml string using the base64ToString() function. The string is decoded, but a little illegal character is added, and because of that I can't parse the xml. I get this…
Kresten
  • 810
  • 13
  • 36
1
vote
0 answers

How do I send link to sharepoint file as an attachment via power automate?

I have a file on sharepoint and I would like to send an email with this file where the attachment would open the sharepoint. At this moment the attachment opens a hardcopy of a file. How do I attach a link to a sharepoint file in power automate so…
1
vote
1 answer

Unable to add Parse_JSON schema in power automate

I have an error with my flow - Action 'Parse_JSON' failed I'm getting an validation failed error when adding the following schema. { "type": "array", "items": { "type": "object", "properties": { "id": { …
Inforex
  • 11
  • 2
1
vote
2 answers

Power Automate - How do I write a FLOW that waits for a site to be provisioned before copying files?

How can I write a flow that 'waits' for a site to be provisioned before continuing to copy files to it? I need to ensure that any site is fully provisioned and available before copying template document libraries to it.
1
vote
2 answers

Ways to receive notifications in Microsoft Teams when tagged in Azure Devops?

I want to set up an integration between Microsoft Teams and Azure Devops so that when someone is tagged in a work item in Devops, they receive a message in MS Teams about it. What is the most straightforward way to accomplish this? I'm attempting to…
Dina
  • 11
  • 1
1
vote
1 answer

Trying to get a specific element from an array column in SharePoint get items

So I am a PA beginner and I am trying to generate an csv report to send out in weekly emails from a SharePoint view and I have noticed that one of my columns in that report is not generating data the right data. Come to find out this column is an…
1
vote
0 answers

How to use Power Automate "uriQuery()" function on an url that contains special characters

Due to some odd circumstances I have the necessity to use uriQuery() in a Power Automate flow in order to extract the query string from an url. This works as expected in most circumstances, except when the url contains special characters like…
SPArcheon
  • 1,273
  • 1
  • 19
  • 36
1
vote
1 answer

Filtering JSON based on sub array in a Power Automate Flow

I have some json data that I would like to filter in a Power Automate Flow. A simplified version of the json is as follows: [ { "ItemId": "1", "Blah": "test1", "CustomFieldArray": [ { "Name": "Code", "Value": "A" …
Zarek
  • 939
  • 3
  • 13
  • 21
1
vote
1 answer

Power Automate: Create_Item Failed

I am trying to create an intake process where where a response from a Microsoft Form creates an item into our SharePoint queue for my team to work. This workflow has some branching so some questions may not always need answers. When the "Date of…
Johndolacjr
  • 21
  • 1
  • 3
1
vote
0 answers

Generate notification when Power Automate fails to run a Flow for Desktop

I have created a flow in Power Automate for Desktop on a server. This flow is scheduled in Power Automate (cloud) to run every hour. Some times there is an error running the flow on the server side, and I want to get a notification in email each…
paalg
  • 11
  • 2
1
vote
1 answer

Power Automate - Need help sorting an array based on one field that's a number in string format

I have an array of data and all values are in string format due to some prior JSON operations in the flow. I need to sort the array based on one field which are numbers (in string format). I'm using the sort function and it currently sorts the…
1
vote
1 answer

read an excel sheet which have multiple sheets and without table

I have an excel sheet which contain 10 sheets and saved inside SharePoint document library. and i want to do the following:- read the data of a single sheet named "CompnayInfo" , the sheet contain the first row as headers and have filters but the…
John John
  • 1
  • 72
  • 238
  • 501
1
vote
1 answer

power automate xpath problem with 0 results on namespaces input

I am working on implementing a small test case for power automate for which in part I am getting data from a website in the xml format. Am getting 0 results though. Worked through a lot of documentation and guessing its something with the…
eskay
  • 23
  • 3
1
vote
1 answer

How to retrieve Dynamics 365 Security/Team members in Power Automate Approval?

I'm new to Microsoft CRM and Power Automate. I'm trying to implement the Quote approval process. As per the requirement, I have to create a team in Dynamic 365 > Security > Team (as below) Then I created a 'Start and wait for an approval' action…
Isanka Thalagala
  • 1,625
  • 3
  • 16
  • 32
1
vote
0 answers

Power Automate: not recognising anchor and hence unable to extract href

So I was watching this video and trying doing something similar in my power automate space. However, I am not able to get extract href option. I have tried it multiple times and the only 3 options I get are extract text, extract ("") and…
Ram
  • 11
  • 1