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

Power Automate Desktop - Create library of subflows or stored functions

Still coming up to speed on Power Automate Desktop - I'd like to create a utility library with functions that can be called from different flows in Power Automate Desktop. Maybe starting with something simple, like creating my own HashSet with a…
Dan
  • 21
  • 1
2
votes
0 answers

How to get rows containing both date and "null" with ODATA filter query? (Power Automate)

I´ve been trying to create some customer reports but I keep getting stuck on trying to retrive rows that matches two arguments. I need to retrive all rows containing both the OUT_DATETIME where it matches the current date and if the OUT_DATETIME is…
Zapher
  • 21
  • 3
2
votes
1 answer

Converting a SharePoint List Item to form format and print it

I want to retrieve an item from a SharePoint Online list (Office 365) and print it out in a form format. I have looked at a few ways which involve using power automate and third party tools which such as Muhimbi and Encodian to put the item's values…
Maanoj Kumar
  • 53
  • 1
  • 2
  • 7
2
votes
2 answers

How to set user field in SharePoint Online with Power Automate HTTP Request to _vti_bin/client.svc/ProcessQuery?

I'm trying to figure out how to set a user field value in SharePoint with Power Automate. I need to use the SystemUpdate method so I'm forced to use the CSOM XML Request approach (_vti_bin/client.svc/ProcessQuery) but I can't make it work.. Using C#…
2
votes
1 answer

Refresh All Queries and Connections of an Excel Workbook (Excel Online) using Office Scripts and Power Automate

I started using the new Office Scripts in Excel on the web. I was wondering if anyone knows if it´s possible to Refresh the Queries and Connections of an Excel Workbook saved on SharePoint Online. I would like to run the script utilizing a Scheduled…
SLazz
  • 21
  • 1
  • 5
2
votes
1 answer

PowerAutomate - Docusign Integration

Does anyone get this code when connecting to DocuSign Triggers? I purchased the DocuSign Pro account and although I can connect I keep getting this error when I am trying to use the DocuSign trigger with…
2
votes
2 answers

"The API-version is not valid

I'm trying to make a PowerShell script, which will be run from a power-automate flow, and which in turn is supposed to call different power-automate flows via a Http request, the Url used here is generated by power-automate flow. My issue arise when…
2
votes
1 answer

Custom connector action webhook error handling

We are currently implementing a custom connector to retrieve data from a legacy system. Since these queries take a long time we use the ApiConnectionWebhook pattern for actions. like described here:…
Alex Doe
  • 300
  • 2
  • 8
2
votes
1 answer

Microsoft Flow with File Created Action is not triggered all the time

I have one drive synced local folder and the files will be synced with a SharePoint site when we add files to this folder. I also have a Flow that gets triggered for every file added. The detailed article about what I am achieving here can be…
Sibeesh Venu
  • 18,755
  • 12
  • 103
  • 140
2
votes
1 answer

Can't get a response value from Power Automate

I have a flow that executed in Power Apps and the result of Power Automate will store to collection, but after executing the flow, the collection still empty of rows. Here is my code in Power Apps ClearCollect( collTest, …
farid wahyu
  • 81
  • 1
  • 11
2
votes
0 answers

Use input for update message in a Teams Flow - Post Adaptive Card action

With the "Post an adaptive card" action in Flow / Power Automate -> Microsoft Teams there's the option to specify an "update message" following the user response to the card. How can I access the data inputs and the submitActionId for use in this…
2
votes
2 answers

Bad Request Issue with Manual Trigger Input but testing is successful

I had a child-flow that was working. I changed some of the input parameters using the usual Power Automate editor. I then went and adjusted the 2 flows that called this child flow. When testing this child-flow, it is successful. When the other 2…
Matty Bear
  • 517
  • 1
  • 4
  • 16
2
votes
2 answers

How to capture the output of a previous action in power automate

I want to capture the output of an action in a variable, in Power Automate. I am using body('action name'), but getting an error: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Create…
Ishita
  • 109
  • 2
  • 10
2
votes
0 answers

Is there a way to collect the first file attached to an item in a sharepoint list?

I have a sharepoint list whose items are always created with a single attachment. Subsequently, any number of attachments may be added. A flow that works on this list sends emails to different people as appropriate. Most of these emails must have…
akorejwa
  • 137
  • 7
2
votes
1 answer

Total a SharePoint Column to include in an email sent by Power Automate

I've built a SharePoint calendar that I'm using to track employee vacation time. The employee logs into a PowerApp, enters their information (including the amount of hours they are requesting off) and clicks a submit button. When the submit button…