Flow Ideas

New Idea

The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection. 


The "Get rows" action allows users to pull records from a single table, but there is currently no way to pull records from multiple on-prem SQL tables. To avoid executing a complex query from Flow, some users have combined "Execute a stored procedure" to build a single table with "Get rows" to query it, but this workflow is also not supported with an on-premises data gateway.


Adding this functionality would create a great deal of opportunities for automation of testing and reporting on complex data structures.

Executing a Flow with this connector yields the following error:
  "message""Gateway ExecutePassThroughNativeQueryAsync\r\nclientRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7",


 Flow Error.PNG


Currently I'm receiving Flow approvals via email inside the Windows 10 action center.

In Windows 10 I can take direct action on incoming items, e.g. delete or archive an email. The same way I just want to approve an approval notification shown in the Windows 10 action center.


A mockup is shown in the following picture:

Flow Approve request using Windows 10 notification in the action center.png

I'm looking for a way to quickly approve multiple items. So I'm thinking about an option to select multiple pending approvals and take batch actions e.g. approve all my selected pending approvals.

I'd like the ability to export a SharePoint online list to Azure Data Lake whenever a change is made to the list.

It would be good to have an option within the planner update that allows a change of bucket and a change in status.  This could then be used to automate the bucket in relation to external events.   Useful if using buckets for managing types of task. 


i.e. on completion all tasks could be moved to a completed bucket 

I want to control my Google Chromecasts by Microsoft Flow.


My scenarios:

1. Every monday, Play a YouTube video at 6:00am, and Stop the video at 6:10am for wake up

2. Every lunch time, Play a YouTube channel at 11:30am for checking news.

3. Every Night, Play a YouTube video for going to sleep.



Yoshihiro Kawabata

Trigger a flow when an email is sent to an Office 365 group mailbox.

This will be helpful to:

- Save attachments sent to a group to team document library or one drive (something like incoming emails on SharePoint on prem)

- Automate creation of events based on email sent to a group mailbox

Hello, can we get a assigned to field with get task/get task details action. There is a assigned to field in Create task action, it doesnt make sense to me that its not included in other task related actions in ms planner connector.


My goal is to have a flow that sends an email or teams msg to assigned user (preferably users).

Resubmit multiple failed flow runs at once

Status: New
by maarteneekels ‎10-02-2017 04:38 AM - edited ‎10-02-2017 04:40 AM

I love the "resubmit" feature! But... wouldn't it be nice to be able to resubmit multiple Flow runs at once? Here's an example of a Flow of which one of the connections has expired:



After updating my Connection, I would like to rerun all of these failed Flows. Now I have to click the > sign, resubmit, go back to the list, remember which failed Flow I clicked last, click the next one, resubmit, etc.


Would be great if I could just select multiple failed Flows and click a resubmit button from right here.

Trigger for new item in planner

Status: Started
by InterestedBloke on ‎07-27-2017 03:51 AM

It'll be useful to have some Triggers for tasks in Planner, not just actions that are executed based on triggers from elsewhere.


Potential triggers:

  • When a new task is created
  • When a task is assigned to you
  • When a task is put in a category
  • Etc.



Status: Started

We are currently rolling out this feature.

Currently only the owners of a flow are able to run it, this is a huge this advantage, this means only the people that is creating and modifying the flow are the only people that is able to use it.


I'm aware about the sharing option for the button triggered flows, however, I'm talking about all the other triggers, the ones that work based certain thing changing or something new being added to the platform, the kind of things are actually worthy to automate.


Image a simple scenario, there is a SharePoint Library where an approval process must run when any internal user with access to the library creates a new document, surprinsily, even that users have the proper license for MS Flows, the flow is not triggered, only the flows owners are able to run it.


For sure the previous example can handled by using the classic workflows, however, this is about of evolving, taking advantage of new technologies and opening the door for new possibilities.


I don't understand why this extremely elementary functionality was not included in the first place.

Flow provides a feature to perform content approval via Mobile App or Email, however, it cannot update the "Approval status" field back to the list.  This is great if we could have this feature because it will virtually lock the item from updating again, or it will require to be re-approved.



I'd suggest adding the possibility to initialize more than one variable in the "Initialize variable" action.

Currently the initialization of variables it taking up quite some space in the flow designer window making it difficult to have a nice overview.



The User returned by the office 365 action have birthday information.


The Person returned by get relevant people does, but it doesn't have value.


Is important to return all the information from user profile, from all input sources. Adding missing fields will help very well for company climate campaigns.





Version Control on Flow Definitions

Status: Under Review
by ianroseman on ‎08-15-2017 09:20 AM

As would any decent tool where users make changes to code or configuration changes, implementing a version control component, would allow a user to a) rollback, and b) reference back to code.  Optional additional features show which user performed the edits, datetime stamp of changes, and code diff tool between versions.

Status: Under Review

I would like to set up some flows to broadcast that a page within a communication site has been initially published. The only options available at the moment are created and modified. 



It would be really useful to have a Graph API endpoint for a users Flow Approvals.

Something like this:


This would allow users take action on approvals inside an application, lets say a MVC web app or SPFx web part.


Best Regards,


When I am using approvals I'm 99% of the time approving them using my phone (iPhone). But I also receive an email, which is clutter for me.


Can you make it possible to make the approval system smarter, so it only sends out a notification to your Phone when you have the Microsoft Flow app installed? Or it sends out the notification first to your mobile phone and if you don't respond within X days, it sends a reminder of Flows waiting for approval to your email?


It would also be great when you can define your settings e.g.: I want to get approval notifications using (checkboxes):

  1. Mobile Microsoft Flow app
  2. Email
  3. Using the online flow.microsoft.com approvals page only

Additional Planner Task Functionality

Status: New
by DeliriumTremens 2 weeks ago - last edited 2 weeks ago

It would be useful to have a few additional actions and features included in flows for Planner tasks:


  1. When creating a task from a flow, it's unfortunate that you cannot also add a checklist to the task.  This is a pretty useful feature in Planner, and seems to be a glaring omission from the Create a Task action.
  2. It would be very useful to have an action for copying a task.  We currently have tasks that are set up as templates of sorts, and then copy those tasks to a new bucket and assign them to users.  This cuts down on task creation for common tasks, however it would be much more beneficial if we could automate copying and then assigning those tasks when certain conditions are met.

It would be useful to have a flow that either creates a new task -- including checklist -- or preferably can copy an existing task with checklist already set up and assign it to a user. Currently you can create a task, but I have a usecase for the Planner Task Checklist functionality and it would be great to have that as part of a flow.



Idea Statuses