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

How to add SharePoint list data or Google sheet to Active Campaign lists?

I am using SharePoint Online lists as a backend. I have requirements like when users add data to the SharePoint list, the same data needs to be added to the Active Campaign lists. There is no direct connector for Active Campaign under Power…
1
vote
0 answers

Web Scraping on Some Websites are not Working on Power Automate

I am not able to perform web scraping by using Power Automate. It did work on some websites but some are not workable. The one that I would try to scrap data from is:…
Fhankyou
  • 23
  • 4
1
vote
0 answers

GUI Scripts (Power Automate) not working in minimized Remote Desktop

Problems statement : GUI Windows Automation scripts not running when minimizing the Remote Desktop Connection. Windows scripts done in power automate. Scripts perfectly working when we open the Remote Desktop. What i have tried Tried this below…
1
vote
1 answer

How to receive list of groups that user is member of in PowerApp

currently I'm working on exercise that demands creating PowerApp that after clicking a button will trigger a flow that will list all groups that user is member of (Sorry if it's not grammar propertly). I want to create a flow in Power Automate using…
Yarensky
  • 11
  • 1
  • 2
1
vote
1 answer

Azure Cost Management API - Looking to Connect the Usage API?

So I'm using Power Automate to connect the API for Azure Cost Management Usage Specifically this guy: https://learn.microsoft.com/en-us/rest/api/consumption/usage-details/list?tabs=HTTP However, Powerautoamte, though it has an ADAuth with Oauth2…
1
vote
1 answer

Pass multiple Excel cell values to Power Automate

I'm using Office Scripts to pass an Excel cell value stored in SharePoint to Power Automate. It works great for one cell, but I can't figure out how to pass multiple cell values. Here's my current Office Script that gets the value in cell B3. When I…
Robby
  • 843
  • 3
  • 19
  • 53
1
vote
2 answers

How to use a list column value as a flag to resolve infinite loop problems in a Power Automate flow?

I am trying to resolve this error in Power Automate: Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself. This seems to be a common problem…
user1063287
  • 10,265
  • 25
  • 122
  • 218
1
vote
0 answers

Create folders and move files comparing part of the name in SharePoint

I am trying to automate a process in the company in order to organize the data and prepare it for the next project, but I am having problems as I am pretty new to SharePoint automation. I have data coming from the field teams every day on the…
Merkator
  • 11
  • 5
1
vote
2 answers

Getting an Image of a Power Pivot including Conditional formatting and send email

I'm trying to use the combination of Excel Office Script and Power Automate to send email with an image of Pivot Table. Below is the code I came up with, but the resulting image that gets sent doesn't include the conditional formatting, only the…
Nico
  • 15
  • 4
1
vote
0 answers

How to create schedule Power Automate getting data from Power BI report

I have a PowerBI report and need to run a Flow that converts the data into a Sharepoint List. I could create this flow, but the trigger is "When a PowerBI button is clicked". I would like do this with recurrence with "Scheduled trigger", but I tried…
1
vote
2 answers

Using Flow to return a SharePoint list to Powerapps

I've used this Flow to return the count of any Sharepoint list to Powerapps. https://masteroffice365.com/get-sharepoint-library-or-list-total-items-from-power-apps/ How would I modify it to return the contents of a list to Powerapps, so that I can…
AlHal
  • 361
  • 3
  • 21
1
vote
2 answers

PowerAutomate JSON - Convert Array of Object to String

So, I have a JSON object that contains an array of users who are members of a group. I would like to take all of those users and squish them into one nice string and put that string into a sharepoint list. I THINK I would use compose, but honestly…
Dan Williams
  • 55
  • 1
  • 2
  • 7
1
vote
1 answer

Unable to add attachments to a Jira issue using Power automate

For the internal communication without our organization we're trying to setup a power automate flow to get the data from a microsoft forms form and create a issue in jira. Using a Jira connector for Power-Automate we're able to create a issue but…
Collin
  • 914
  • 1
  • 9
  • 30
1
vote
1 answer

Power Apps: display stored procedure data in DataTable after button click

I have just started using Power Platform (Power Apps). I recently tried to see data (via Google Sheets) in a data table which worked fine by attaching a data source (of Google Sheets) to a data table. Now, what I am trying to do is: I added a…
1
vote
1 answer

Power Automate - Insert/ Updates rows in On-prem SQL server table

My goal is to copy data from one SQL table to another SQL Table. I'm trying to create a conditional Insert/Update statement in Power Automate based on Row ID. I have two tables right now with the same columns. Source SQL Table Destination SQL…