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

Renaming SharePoint files in bulk by changing the date format on Power Automate

the current file names are: DD- MM- YY Title of Document I would like to change it to: YYYY-MM-DD Title of Document For example: the title of the document is 28- 02- 2022 John Smith is ready for service And I would like to change the file name…
Summer
  • 11
  • 2
1
vote
1 answer

Can i split HTML elements into separate rows? Power automate

For a project I'm currently working on I have to get a certain part of an email message and put it into a SharePoint list, its almost fully functional but there is still one small part that doesn't work, The part of the email contains websites, so I…
1
vote
1 answer

Power Automate FIlter Array with Array Object as Attribute

i have a Object-Array1 with some Attributes that are Object-Array2. I want to filter my Object-Array1 only to these elements, that contain a special value in Object-Array2. How wo i do this? Example: { "value": [ { "title": "aaa", …
1
vote
1 answer

How to Read CSV file using Power Automate?

I have added CSV file to SharePoint Documents library. I needs to read that CSV file using Power Automate / Flow. I have created Power Automate flow. Below is the screenshot fro the same. Which CSV parser do i need to use for read data from file…
1
vote
2 answers

Power Automate flow triggerede by "When a row is added, modified or deleted" runs double when record have child records

I'm using the "When a row is added, modified or deleted" trigger in at Power Automate flow to get records, when it's a approved by a certain user: The flow runs fine, but when the record has child records, the flow runs twice. I've checked the…
1
vote
3 answers

How to query on-premises SQL Server database using power automate varible?

I am trying to query an on-premises SQL Server database using a power automate variable. Is there any suggestions or is this even possible for the time being? I have attempted the following: Using “Execute a SQL query (V2)” with an on-prem gateway…
Dylan
  • 36
  • 6
1
vote
0 answers

Is it possible to resize base64 code representing the image?

I am using power autoamte to convert an image in base64, and then I put this code in html. Here is what I do: I convert the original image to base64 I put this code in the html content in the tag. I convert the html to pdf…
Protektor
  • 31
  • 5
1
vote
1 answer

Power Automate flow to update a workitem with a custom ID for particular work item type

Power Automate flow to update a workitem with a custom ID for particular work item type. E.g. we have workitem type 'Activity' and if a user creates a new workitem Activity then update the field 'custom ID' as 'Activity - 1' then the next time a…
1
vote
0 answers

What is the difference between the "Get Flow" and "Get Flow as Admin" action?

I'm trying to set up a flow that backs up all flows in an environment to SharePoint. This is similar to the "Create a file in SharePoint to save modified Flows in JSON format daily" template that Microsoft provides. The difference is I want to…
Ivan Wilson
  • 403
  • 3
  • 12
1
vote
1 answer

Power automate - Unable to get JSON content from Sharepoint folder

I have a Power Automate flow that gets a JSON file from a SharePoint folder (when dropped into it) and I want to be able to read its contents and extract a key/value. The issue I am having is that it crashes in the second step, Get File Content,…
sugarakis
  • 117
  • 9
1
vote
1 answer

Power Automate - get categories

I'm new to Power Automate and trying to get the "Category" flag that is placed on emails after received. My number one problem is finding a connection that has the category object available. These are the objects I'm trying to find, in Outlook web…
Jan
  • 421
  • 3
  • 13
1
vote
1 answer

Issue with Graph API in Power automate

I am trying to get all users out of a tenant with power automate. But when i try to filter out users with userType Member. I keep getting the error: Enter a Valid URI ( even tough i am using a valid URI that is used inside the…
BartTechne
  • 15
  • 7
1
vote
0 answers

Updating a list item in SharePoint Online without incrementing the version

I'm working on a project with Sharepoint Online and PowerAutomate, and I have a small issue that I would like to share with you, in order to find solutions or workarounds. I have a PowerAutomate flow, which is run by a technical user (service…
1
vote
0 answers

Power automate get part of web page using xpath or id

I am using power automate to read part of secured webpage content using http with Azure AD. I am able to get whole webpage content as text. I am trying to get part of web page text inside a paragraph with id or with a xpath like the below. I tried…
Kurkula
  • 6,386
  • 27
  • 127
  • 202
1
vote
2 answers

How do I use a power apps form for a lookup column?

I have a SharePoint List (say "List-A") with plenty of columns, some of which are lookup columns. These are just used to construct a choice columns, where the items in the choice drop down are the items of a column in a different List ("List-B"). I…