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

Microsoft Flow SharePoint to Teams HTTP 413

I have a Microsoft Flow which pulls a SharePoint List item and it's attachments, creates a message, then sends that message to Teams through a Webhook connector. In order to send the attachments, I am required to send the Base64 representation. I…
chriscam85
  • 66
  • 1
  • 7
3
votes
5 answers

Get Yesterday's Date (MS Power Automate)

In Microsoft Power Automate, using the expression utcNow() you can get the current date (and time). I am trying to get yesterday's date. I tried dateadd(utcNow(), -1) and similar code, but nothing works. Anyone know how to work with dates in…
SUMguy
  • 1,505
  • 4
  • 31
  • 61
3
votes
0 answers

How can one connect Microsoft Flow directly to Azure SQL DB?

I am trying to connect to Azure SQL database and retrieve the manager's email of every user that submits a response in Microsoft form. The flow is as below: Microsoft Form(user fills in personal details) --> When response is submitted I need to…
django-unchained
  • 844
  • 9
  • 21
3
votes
2 answers

Sending Images from PowerApps to Microsoft Flow

Is it currently possible to send a captured image from PowerApps to Microsoft flow? The basic idea of the app is to take a picture with the camera control then pass the image to a Microsoft flow which will then send an email with the image as an…
M0rty
  • 985
  • 3
  • 15
  • 35
3
votes
1 answer

How use OData $filter query dynamic date

I'm trying to use Microsoft Flow to fetch all my calendar events for the past two weeks, and do this every two weeks. The problem is that the "get all events" outlook action only accepts an ODATA $filter query and it's not clear how to filter it…
Tupaschoal
  • 476
  • 1
  • 5
  • 13
2
votes
1 answer

Power Automate - Action Export_To_File_for_Paginated_Reports failed

I am using Power Automate to Export an Excel file from a Paginated Report and then emailing that Excel report to a user. It works 100% for small data sets, but when I use a large data set where the Excel file size will be 7mb I get the below…
Etienne
  • 7,141
  • 42
  • 108
  • 160
2
votes
0 answers

How to change the row color on the basis of column value in power automate "Send Email" action?

I want to attach excel table in email body via power automate which I was able to do. But I want to highlight rows that contain specific column value. Something like this. My current flow looks like this. Compose code looks like…
Abhils
  • 333
  • 2
  • 8
2
votes
1 answer

how to write datatable in excel using power automate desktop while preventing large numbers to be converted to an exponent

I am having an issue when writing a datatable to power automate desktop, the issue occurs when a cell has a large number, since it converts the data to exponent. Below is how I am writing the datatable to excel. The datatable as it appears on PAD…
mulikevs
  • 181
  • 2
  • 17
2
votes
0 answers

power automate return multiple response to virtual agent

I have a power automate flow that is triggered from a chatbot flow (as part of virtual power agent). The data being generated from power automate output is more than 256KB in size. So, my requirement is to split is data into 2 parts and return them…
2
votes
2 answers

How to Import/Export Power Automate flow with AI Builder Custom Model?

I have created Power Automate Flow with AI builder custom models to read data from PDF and add that data to SharePoint list in my office 365 tenant (For example: https://contoso.sharepoint.com/). Now, I need to add that flow with AI builder custom…
2
votes
1 answer

Power Automate Adaptive card does not display in my email

Hi I have been working with power automate to create an approval flow that is triggered by a power apps app. The email contains the json for an adaptive card used for storing responses. When I receive the email I cannot see the adaptive card. I…
2
votes
1 answer

Power Automate: Send eMail mit Sharepoint attachement

I have a problem creating a flow. All files for the flow are in a sharepoint. In an Excel list, I call up various information such as name, surname, e-mail and also the file name of the e-mail attachment. The e-mail attachment is also stored on the…
Andreas
  • 147
  • 3
  • 17
2
votes
1 answer

Is there a way to capture what have been changed inside Dataverse tables and update sharepoint lists accordingly using Power Automate flow

We have 2 data-verse tables named:- Invoices Accounts Also we have 2 SharePoint lists named:- Invoices_Logs Accounts_logs The dataverse tables will contain the actual values and the SharePoint lists will act as the logs for the updates. now we…
John John
  • 1
  • 72
  • 238
  • 501
2
votes
1 answer

Is there a way to run the python scripts through Power Automate without Azure?

I want to automate my python script to run on everyday basis. Is it possible to automate them using Power Automate but without Azure? I tried with Azure but i wanted to know if there is any way that i can use it without Azure.
Being_shawn
  • 122
  • 9
2
votes
1 answer

How can i convert Details form into a json in powerapps?

'PowerApp->Content'.Run(JSON(DetailForm1,JSONFormat.IncludeBinaryData) I am trying to put this action on a button but im getting an error the json function cannot serialise objects of type control Is there any workaround to this? I want to send…