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
4
votes
2 answers

Trello Label Id in microsoft Flow

i am trying to create a flow using Microsoft flow.The flow creates a card in Trello when an item is created in SharePoint list.I need to add a label to each card.The Flow gives me an option to specify the Label Id.How can i get the id of labels in…
Treesa
  • 383
  • 3
  • 13
3
votes
1 answer

Power Automate - Compose tool failing on blank excel rows

My compose statement is reading in excel table. However when it gets to a blank row i get error "Action 'Compose_2' failed" Is there anyway to bypass this error to deal with blank records? These compose 1 and 2s are done for 5 different date…
Jonnyboi
  • 505
  • 5
  • 19
3
votes
1 answer

Power Automate add item to Microsoft To Do "Assigned to me"

I am trying to connect to azure devops and when a work item is updated, I am adding the work items details to Microsoft Todo(to-do.office.com). I am able to push messages as Tasks or Flagged email but I do not have option to move todo item to…
Kurkula
  • 6,386
  • 27
  • 127
  • 202
3
votes
0 answers

How to create monthly approved reports using PowerBI reports? - General Question

I am trying to understand the best way of creating a monthly report which will be looking for the previous month's data and allow approvers to enter their comments and approve each slicer (location) in the filter section. I have PowerBI reports…
beginnerman
  • 29
  • 4
3
votes
0 answers

Power automate custom connector that can be used with multiple endpoints

Is there a nice way for a power automate custom connector to support multiple server addresses? The method I found on the web seems to be where each and every operation would require a URL query parameter which is used to update the host URL. Is…
rukiman
  • 597
  • 10
  • 32
3
votes
0 answers

How to read Power Bi Dataset in Power Automate?

How to read Power Bi Dataset in Power Automate ? We are trying to achieve that visually and programmatically. We need to create a flow in Power Automate based on the values we get from Power Bi Dataset. OR We would like to achieve the same from…
Elias Arellano
  • 433
  • 5
  • 16
3
votes
5 answers

Is there a way to schedule and run a Power Automate Desktop flow from desktop itself without using cloud?

I have created a desktop flow using Power Automate Desktop. But I cant schedule or make it run automatically. Is there any way to do so? I don't wish using cloud flows and connecting Desktop flow using Gateways. I need to automatically run Desktop…
user8918316
  • 31
  • 1
  • 1
  • 4
3
votes
1 answer

How can I speed up my Office Scripts code so that it doesn't fail in Power Automate?

I have been asked to pull data from an Excel online spreadsheet on Sharepoint into Power BI to create a dashboard - no problem, right? Well, one of the 'data points' is actually fill colour of the cell indicating status. I did some googling and…
RachelPillsbury
  • 33
  • 4
3
votes
1 answer

What is the iCAL property for using the user's local time?

I've created a Power Automate flow that generates an ICS file for a meeting invite that will be sent to people across the US in different time zones. Everything is working as I had hoped, but I can't find the property that needs to be set in order…
newtothis
  • 31
  • 2
3
votes
2 answers

Copy Excel OneDrive table to an specific cell on another Excel OneDrive table (Power Automate)

I need to copy data from one excel worksheet and paste (values only) on another worksheet using power automate + Office script I started to creat a flow using the answer in the link bellow. Power Automate: Copy Excel OneDrive table to the bottom of…
Thaís Ferreira Araújo
  • 33
  • 6
3
votes
2 answers

ExcelScript: getNumberFormat from column A to C

I need to get the NumberFormat from an excel file (appr. 3000 lines) and I wrote a simple Script which copy it from column A to column C each row by row. I tried to use this script with Power Automate after 10 minutes. I already set the timeout on…
Paintitblack3k
  • 77
  • 8
3
votes
4 answers

Solve Math Equation(string) in Canvas App

I have a dynamic formula that needs calculation. Here's a sample (var1 * var2) / (var3 * (23 * 100)) These variables will be replaced with actual numbers because they are user input. Currently, I am using power automate flow that connects to my web…
Crismogram
  • 906
  • 15
  • 27
3
votes
1 answer

Get first item in list in Power Automate Desktop

I'm trying to get the latest subfolder from a folder using Power Automate Desktop. I can get the list, and display it, that works fine. Then, I cant figure out how to get the first item. It's unbelievalbe that I cannot find out how to this simple…
kaze
  • 4,299
  • 12
  • 53
  • 74
3
votes
0 answers

Is there a way to resolve the flow error "Message mention text needs to be specified." when posting a message to a Teams Channel?

I'm trying to post a message in MS Teams using @ mention. So I'm using email address for this purpose. Yet I receive the flow error as shown below. flow error image
Esther
  • 31
  • 2
3
votes
4 answers

function/expression to check for blank values in power automate html table item

I have created a flow for sending an email to contract owners based on a excel if a condition satisfies. The email has a HTML table of related details attached to it. One of the required details is a formatted date value which may or may not be…
KachMi
  • 33
  • 1
  • 3
1 2
3
…
99 100