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
1 answer

A question about Power Automate to proceed macro from another excel file

Hello I am a newbie that working on a project that requires to use Power automate desktop to analyze data in the excel worksheet. The project needs me to download a excel file from website and proceed with macro. Now I am able to download file from…
BestSumy
  • 23
  • 4
1
vote
0 answers

How I can Assign web roles automatically to the existing user/contact using form/flow in power pages/apps?

I'm trying to assign the web role to the existing contact by making a form/list in the power pages but I haven't found the existing power app flow to do so automatically. Please anyone can assist me in how I can assign by selecting the web role in…
1
vote
2 answers

Microsoft Power Automate - error with flow - Action 'Parse_JSON' failed

I have an error with my flow - Action 'Parse_JSON' failed: Details: Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path…
Teaquell
  • 11
  • 1
  • 2
1
vote
2 answers

Is there a way to automate webpage login and download report?

Is there a way to automate a task a webpage login and download report maybe with power-automate or some other method? open web page enter any parameters. click download button. save download to local drive. Thanks
1
vote
0 answers

Web Scrapping of dynamic form performance issues in parallel requests

I have to scrap the quotes data from an insurance company website which requires filling the form which has 12-14 fields and clicking on a button and wait for 14-16 seconds to get the results and once results are available, return them to REST API.…
Guarav T.
  • 468
  • 6
  • 20
1
vote
2 answers

Loop through drop down with dynamic html table

I'm hard stuck with this one so any advice welcome! Ive been trying to create a flow that goes to this website https://dlv.tnl-uk-uni-guide.gcpp.io/ and scrapes the data from each table in the Subject Areas drop down list. My knowledge of HTML is…
Chris H
  • 13
  • 3
1
vote
1 answer

How to invite the azure guest user for power pages - using the power pages form

My goal is to invite the guest users to the azure active directory by using the power pages user interface. I'm trying to achieve this by making Microsoft form & hitting the graph API using power automate but unfortunately, the HTTP action is only…
1
vote
1 answer

Power Automate - How to create Azure DevOps work items only once when the trigger is a work item update?

Context I want to create a Power-Automate flow that automatically creates a sub-task in Azure DevOps when the Effort of a PBI is set. When the Effort field goes from blank to a positive value, the task should be added (using the newly set Effort…
Batesias
  • 1,914
  • 1
  • 12
  • 22
1
vote
1 answer

PowerAutomate http request fails where the same request from Postman works fine

I am trying to communicate with an API using the HTTP Action in Power Automate. With this specific API I am getting the error "BadRequest. Http request failed as the content stream was not valid: 'Found invalid data while decoding.'." I have no…
1
vote
0 answers

How to render multiple selected values in a Word template

I'm trying to render multiple values selected from checkbox on a form made by Powerapps where its data source is a Sharepoint list, the type of column I'm using for this field is of choice configured to allow me to select multiple values. In my…
1
vote
1 answer

Power Automate Convert File from CSV to XLSX

Good Day!! Got a problem in Power Automate that I have played with for days now... With that, I am a hobby programmer and an accountant by day. I am attempting to use MS Power Automate to grab a CSV file from an SFTP site and save it to my…
RustyMc
  • 29
  • 1
  • 6
1
vote
1 answer

Power Automate flow cannot display ADE graph query

I have this Power Automate flow: Flow rendering a time chart then sending email It uses the action "Run KQL query and render a chart" and runs an ADE query I have made already which renders a timechart with this kql syntax: ...| render timechart…
Adam S
  • 13
  • 3
1
vote
0 answers

MS PowerAutomate check if file exists in Onedrive and rename

I have a following process to automate in my PA: When email arrives to outlook's specific folder, save email's attachment to Onedrive folder. Problem: attachment files often have same names, despite different content. I need either to : Check if…
1
vote
2 answers

Power Automate - Wait till Power BI dataset refresh completes\fails

I have created a Flow in Power automate, have used a Refresh a Power BI dataset component , there is no issue in terms of functionality as such and I am able to refresh the dataset successfully - so far so good (till the time the dataset gets…
Joseph
  • 530
  • 3
  • 15
  • 37
1
vote
0 answers

Merge or delete semi-duplicates in an array

I need to either merge or delete semi-duplicates in a Dataverse table. I looked into duplicate detection there, but I couldn't figure it out. I want to point out that that might be the solution to this and might be easier than what I'm asking for…
Robby
  • 843
  • 3
  • 19
  • 53