Power Automate Ideas

Share your ideas and vote for future features

Suggest an idea

Hot Ideas
Top Ideas
New Ideas

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: { "status" : 400 , "message" : "Gateway ExecutePassThroughNativeQueryAsync\r\ncli entRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7 " , "source" : "sqlconnectionprovider-westus.tip0-westus.p.azurew ebsites.net" }

Status:

I want to get values of a row of array with no-expression. for reduce the expressions, for reduce Apply-to-each, for easy, for simple. Scenario: - Get some values from SQL Server by multiple queries, and use these values without the apply-to-each operations Problem: - A query of SQL Server output a recordset as array, even if only one row. - the query like: select top 1 Name, Value from table1 order by orderid - To use these value, need to the 'Apply-to-each' operation, and use each value in the scope. - When there are multiple queries, need to Nested 'Apply-to-each' operations, - In each scope of 'Apply-to-each' operation, can use each value with no-expresson Therefore: - I want the operation 'Get values of a row of array' Regards, Yoshihiro Kawabata

Status:

Labels

Action 30
Admin Center 3
Admin Portal 2
Agile 1
aha 1
AI 3
AI Builder 14
Airtable 1
ali 1
All Users 1
Amazon 1
android 2
Any.do 1
Anytype 1
Apache 1
api 6
app 2
appendix 1
Apple 1
Apply to Each 3
appointment 1
approval 8
Approval email 5
Approval Flow 15
Approval Flow reply from Outside Organization 1
Approval Requester 2
Approval Status 2
approval table 1
Approval Workflow 2
Approvals 17
Approve 4
Archive 3
Array 2
Array Queries 1
asana 1
Asana Integration 2
Asana Organization 1
Assign Action in Flow - Dynamics 365 1
assigned trigger 1
attachmens 1
Attachment 7
attachments 4
authentication 1
auto delete 1
Auto save 2
automatic deployment 1
Automatic Replies 1
automation 4
azure 12
Azure AD 2
Azure Analysis Services 3
Azure Analysis Services Connector 1
Azure Blob Storage 1
Azure Blog Storage 2
Azure Data Box Edge 1
Azure Data Factory 1
azure devops 4
Azure devops to SharePoint Flow 1
Azure Event Grid 1
Azure Files Storage 2
Azure IoT Hub 1
Azure Log Analytics 1
Azure Maps 3
azure resourcemanager 1
Azure SQL Database 2
Azure Stream Analytics 1
Azure Subscription 4
Azure Table Storage 2
Azure Virtual Machine 2
Azure VM 1
Azuren 1
backup 1
batch 2
Batch Processing 3
better life 1
bigcommerce 1
BIM 1
BIM360 1
bing 2
Bing Maps 1
Bing Search 1
Blink 1
Bookable Resource 1
bookmark 1
boolean logic 2
branching 2
Bug 6
Building Flows 1
bulk delete 1
Business Cards 1
Business Central Connector 1
business process 223
button 13
Buttons 5
calculated field 1
Calendar 10
Calendar Event 4
calendar events 1
calendar invite 1
Calendar resources 1
Calendaring 1
Camera 1
cancel 1
cancel flow 1
Capture EmailAddress of ActingUser 1
categories 3
category 1
CDS 1
CDS2.0 1
channel 3
chat 2
check 2
Cherwell 1
Chromecast 1
client 2
Clio 1
CMS 1
Cognitive 3
cognitive services 1
Collections 1
Color Categorisation 1
column 1
columns 1
Community Chat 1
Community Site Idea 44
compare flows 1
Completed 1
Compliance 2
Compose 1
Compose action output naming 1
Concert CSV to Excel format 1
Condition 5
Condition Builder 1
Condition error 1
Condition Field 1
Condition on flow 3
conditional logic 3
conditions 3
Connecting Planner 1
Connecting to Data 6
connection 3
connections 2
Connector 28
Connector Feature Idea 958
Connector identification 1
Connector Improvement 1
connectors 7
Contacts 10
Content 1
Content Approval 2
Content Conversion 1
Content Moderator 1
controller 1
conversion 1
convert 1
Convert to PDF 1
copy 4
Copy File 3
copy flow 3
copy flow actions 2
copy folder 1
Copy item to folder 1
Copy items from one sharepoint list to another 1
Copy to SharePoint server from Cloud 1
Copy-paste 1
correction 1
Cortana 2
cosmosdb 1
create 1
Create Content 1
create file 3
Create Flow 1
create item 2
Create JWT 1
create list 1
Create Planner tasks 1
Creating Apps 1
Creating flows 7
creator 1
credentail 1
CRM 11
CRM connector 1
CRM SQL on-premise Query with MS flows 1
CSV 3
Cube 1
currency 1
custom 1
Custom Connector 3
Custom Fields 3
custom view 1
d 1
D365CE 1
data 3
data alert 1
Data connection 2
data connections 1
Data Connector 1
Data Mapping Conversion 1
Data Operations 1
data sources 2
data type 1
Data Warehouse 1
database 2
Date 2
Date and Time 1
Date and Time difference 1
date list element 1
Datei 1
dates 2
Days between 1
de-duplicate 1
Debug 1
debugging 2
default 2
degreed 1
Delegates 1
delegation 1
delete 4
Delete All Records 1
delete email attachment 1
delete flow 1
delete owner 1
deleted 2
deleted list 1
deleting steps 1
dependent actions 1
deployment 2
description 1
Design Experience 1
designer 2
Desk 1
desktop application 1
Detect 1
detection 1
development 1
Device 1
Device orientation 1
DevOps 2
direct 1
direct record link 1
directory 1
disable 2
display text 1
DisplayName 1
distribution lists 1
DLP 7
DLP auditing 1
Do Until 2
Docgen 2
document assembly 1
Document Library 3
Document Set 2
Document Template 2
documentation 8
Documents 2
DocuSign 3
Drag and drop 1
drop down 1
Dropbox 3
DropBox action 1
dropdown 1
Drupal 1
due date 1
Dupicate 1
duplicate 1
Duplicate Item 1
duplicates 1
Dyanmic Content 1
dynamic content 6
dynamic expression 1
dynamic link 1
Dynamic parameters 2
Dynamics 6
Dynamics 365 13
Dynamics 365 Attachments 1
Dynamics 365 for Operations 1
dynamics 365 for talent 1
Dynamics 365 Operations 1
dynamics crm 3
Dynamics NAV 1
Dynamics365 1
ease-of-use 1
ecomm 1
ecommerce 1
Edge 2
Edit 2
Editing 1
Editor 1
Efficiency 1
Elevation 1
Email 26
Email actions 1
email address 1
Email attachments 2
email attachments with different FROM address 1
Email Failure 1
email from 2
Email Saving 1
Email Thread 1
email trigger 1
Email with options 1
emails 3
Empty 1
EN-GB 1
EN-US 1
enable flow 1
Enabling Single Sign-On 1
Encode Strings with signing algorithms 1
end event 1
enhance keyboard usage 1
enterprise 2
ents 1
Environment 1
Epic 1
ERROR 2
Error code 1
ERROR handling 1
error message 1
error save flow 1
errors 1
Event 8
event finish 1
event organiser 1
Eventbrite 1
Events 2
Evernote 1
Excel 16
Excel Business 5
Excel Connector 1
Excel import 1
Excel Online 3
Excel Sharepoint 4
exchange 2
Exchange Online 7
execute 1
Export 4
export flow 3
Expression 2
Expression Evaluation trigger 1
expressions 2
Expressions Mobile app 1
Facebook 8
Facebook comment 2
Facebook Events 1
Facebook Page 2
Facebook timeline 1
Facial Recognition 2
fail 1
failed 1
failed flow 1
failed flow details 1
failed flow runs 1
Failed Flows 2
Failure Notification Email 2
Fax 1
features sensitivity calendar 1
fields 2
File 3
file content 1
File Converter 1
File Created 1
File ID 1
File System 5
File Systems 1
filename 1
files 4
files need attention 1
Filter 1
Filter A 1
Filter array 1
Filtering 2
Find actions in search 1
firebase 1
Fitness Tracking 1
flag 1
Flag property 1
flagged e-mails 1
Flexible interface 1
Flickr 1
flow 59
Flow & Teams 4
Flow - BPF 10
Flow Action 19
Flow Actions 14
FLOW ACTON 1
flow admin 2
Flow Android 1
flow backup 1
flow building 1
flow button 2
Flow button for mobile 1
Flow button trigger 2
Flow Changes 3
Flow Collections 2
Flow Community Blog 1
Flow Condition 1
flow connecting to data 1
flow connector 2
Flow creator information 1
Flow Dashboard 1
flow description 1
Flow Designer 1
Flow e-mail meeting room 1
Flow editor 3
Flow email 3
Flow email from O365 Group 1
Flow Emails 2
Flow Error 2
Flow Error. FlowAction 1
flow export 1
Flow Fail 2
Flow Feedback 2
Flow history 4
flow ideas 5
flow list 1
Flow Mobile App 1
Flow Modern Approvals Requester 1
Flow Operations 5
Flow Properties 1
flow reports 1
flow runs 2
Flow Start An Approvals 1
flow state 1
Flow Sub Task 1
flow templates 3
Flow Trigger 10
flow usage 2
FLOW Use 9
Flow website 1
Flow-App 2
FlowBot 1
Flows 16
flowtermination 1
FME 2
Focus 2
folder 9
folder management 3
folders 3
Follow 1
ForAll 1
Force Touch 1
ForEach 1
Form 2
Form Data 1
form for metadata 1
format 2
Formatting 5
Forms 9
Formula 1
formular 1
Forum 1
FreedbackHub 1
Freigabe aufheben 1
Freigabe löschen 1
french 1
from email address 1
From Field 1
FTP 1
Function 1
functions 2
gal 1
gallery 2
Garbled characters 1
Garmin 1
gateway 2
General Discussion 1
General Flow Feature Idea 1,776
General Flow Idea 9
General Questions 2
get 1
get calendars 1
Get File Properties 3
get items 2
Get page feed 1
Get records 1
Get rows 3
Get rows from Excel table 1
Get Task 1
GetEventsCalendarViewV2 1
GetGroupsAsAdmin 1
Getting the items in an Office 365 OneNote Table 1
GIF 3
github 1
gmail 1
Go back in FLOW 1
Go back to a previous action 1
Go back to a previous step 1
Google 8
Google Calendar 4
Google Cloud Print 1
Google Drive 4
Google Drive to One Drive for Business 1
Google Photo 1
Google Sheets 2
Google Sheets to Excel Triggers 1
Google Sheets Triggers 1
google+ 1
GPS 2
Graph 1
Gravity Forms 1
gremlin 1
Group 1
grouped conditions 1
Grouping 1
groups 3
Guest access 1
GUID 1
H 1
Harvest 1
Help 2
history 1
History View 1
hive 1
Home 1
html 2
HTML Table 2
HTTP 3
HTTP Action 4
HTTP Request 1
Hubspot 1
Hyperlink 1
I would like to add "when changed" to SharePoint trigger. 1
iCal to google 1
iCloud 1
IcM:IncidentType 1
icon 1
Idea 4
ideas 6
Image 1
Images 2
IMAP 1
import flow 2
In 1
inactive flow 1
Info 1
Informatica 1
initialize 1
Initialize variables 1
Input Fields 2
Instagram 3
Instapaper 1
Integrate 1
Integrating Microsoft flow with DocuSign Rest API 1
Integration 1
Intralinks 1
invite 1
Invoice 1
iOS 5
IoT 4
iPhone 3
Issue 1
Item 1
item level permissions 1
item modification 1
Japan 1
Jira 5
Join 1
jpeg 1
JSON 3
JSON Web Token 1
Kalenderansicht von Terminen abrufen (V2) 1
Kanban 1
KeyVault 1
labels 1
landscape 1
Language 2
Late Assignments 1
Layout 1
lead 1
Leads 2
Learn 1
learning 2
Library 2
license 1
Limit 2
LINE 1
lines 1
Link Target 1
LinkedIn 2
LinkedIn Actions 1
LinkedIn Connector 1
LinkedIn Learning 1
LinkedIn Triggers 2
Linken In data 1
Liquid Planner Connector 1
list 4
List Files in Folder 1
List item email with multiple attachments 1
list items 1
List Project Connector 1
list rows present in a table 1
List tasks 1
lists 2
Live 1
ll 1
Loading Time 1
local 1
local folder 1
localization 1
localize 2
location 3
Location Services 1
logging 1
logic Apps 3
lookup 1
loops 1
M365 O365 service health 1
macro 1
Mail 7
Mail alert 1
mail merge 2
Mail Reply 1
mailchimp 2
major 1
manage flows 1
Managed Metadata 1
Management 1
manager absent 1
manager sick 1
manual flow 3
map columns 1
MariaDB 1
mark 1
Marketo 1
MC166007: Updates to Microsoft Flow and PowerApps licensing in Office 365 1
Meeting Request 1
MeetingIDOffSystemAccounts 1
meetings 1
Mejora en la plataforma de la nuve 1
merge flow 1
message 2
Message Center 1
Message creater 1
Message ID 1
Messages 1
metadata 2
MetaData Modification 1
Metadata trigger 1
mfa 1
Microsoft Flow 10
Microsoft Flow (Mobile) 1
Microsoft Flow app 1
Microsoft Forms 2
Microsoft Security Update 1
Microsoft Teams 13
Microsoft Teams connector 1
Microsoft To-Do 2
Microsoft Word 2
Minecreaft 1
minor 1
mix 1
mobile 1
Mobile App 1
Mobile App Idea 35
Mobile Apps 2
Mobile button 2
Mobile Notification 1
mobile share 1
model-driven app 1
model-driven app execute flow 1
Modern Approvals in HTML 1
Modern Site 1
modification triggers for SharePoint 1
modified 1
Modify 1
mongodb 1
Monitor 1
Move 5
Move emails folder 1
move file 1
Move file to folder based on file name 1
move item 1
Move Yammer 1
MS Dynamics 1
Ms Flow 3
MS Flow App 2
MS Graph 1
MS teams 2
MS To Do 1
MSA 1
MSFlow 3
MSOMS 1
Multipart 1
multiple approvals 1
Multiple Assignees 1
multiple flows 1
multiple values 1
Multiuser flow 1
MultiValued fields 3
My Day 1
my flows 2
My Flows view 1
MyFlows 1
MySQL 2
NDR 1
nested condition 1
Nested Conditional Steps Limit 1
Nested flows 1
Netatmo 1
netsuite 1
New 2
new connections 1
new contact 1
new file 1
New Flow 1
New Idea 5
new items 1
New member in yammer group 1
new user 1
new user story 1
News Content 2
Newswire 1
no longer empty 1
notification 9
notifications 8
Notifications Flow PowerApps 1
O365 1
O365 Admin Center 1
O365 group mailbox 2
O365 Outlook 1
o365 Profile 1
O365 Tasks 1
O365 Video 1
Object Recognition 2
obtain user response status for outlook calendar events 1
OCM 1
ODATA 3
OData Filter Query 1
ODBC 1
Office 2
Office 365 13
Office 365 Group 1
Office 365 group email 1
Office 365 groups 3
Office 365 Outlook 9
Office Group 2
Office Lens 1
office mix 1
Office365 1
Office365Users 1
On-Premise 4
on-premise gateway 1
one email 1
OneDriive 2
onedrive 8
OneDrive (ForBusiness) 6
OneDrive for Business 9
Onedrive for Business Connector 1
OneNote 21
OneNote Todoist 1
ONNX 1
oof 1
ORC 1
Ordner 1
Organization 1
Organizer 1
original 1
Out of Office 3
Outlook 42
Outlook 365 14
Outlook contact 1
Outlook Task 2
Outlook to excel 1
Outlook365 contacts trigger 1
Outputs 1
Overwrite SharePoint file 1
owner 2
Page revise 1
page templates 1
pagerduty 1
Parallel 2
Parameter 1
parameters extraction 1
Parent ID 1
parrallel 1
parse JSON 1
parsing http body 1
Partner Center 1
Paste 2
path 1
Pattern Matching 1
pause 1
PDF 8
pdf conversion 1
pdf from lists 1
pdf merge 1
pdf printer 1
pdf to archive 1
pdfs 1
Permission 1
permissions 2
Personal 1
phone 5
Photo 2
Photos 1
Physical button 1
Pipedrive 3
planner 20
planner action 1
Planner Connector 5
Planner dynamic content 1
Planner Email Reminder Flows 1
Planner Flow 12
Planner List Tasks Bucket 1
planner sharepoint 1
planner task 2
Planner Trigger 7
Play 1
please 1
Please implement the item "When deleting a task" as trigger of Wunderlist. 1
Plug-ins & Workflow and Web Services 1
PnP 1
Pocket 1
POL 1
pop3 2
populated 1
popup 2
portrait 1
Post 1
posting to 1
Power BI 13
Power Bi Content Pack 1
Power Query 1
powerapp 1
PowerApps 11
PowerApps SharePoint 1
PowerBI 1
PowerPoint 1
PR Newswire 1
printing 2
process automation 1
Project 4
project online 13
Project Online ID 1
Project Site 1
property 1
Provider 2
Provisioning 1
prowl 1
prowlapp 1
publish 3
Publishing 2
Push notification 3
pwa 1
QnA 1
QnA maker approval with flow 1
Quckbooks 1
Query 3
Queue 1
Quick 1
QuickBooks Online Integration 1
quote 1
Read Content 1
Read-Only 1
realtime 1
reassignment 1
recommendations 1
record url 1
record variable 1
records 2
records management 1
Recurrence 4
recurrence time 2
Recurring Events 2
Recycle Bin 1
refresh 1
regex 1
Reject or Approve 1
Related links 1
reminder 1
Reminder approval & notifications 1
reminders 1
remote control 1
Rename 4
rename actions and trigger 1
Rename files in SP 1
reorder 1
replace email attachment 1
Report 1
Reports 1
Request 4
Request Sign-Off 1
Resize 1
resize picture 2
ResourceMailbox 1
Resources 1
responses 2
resubmit 2
Resubmit flow 1
retweet 3
room 1
route to second approver 1
rsa 1
RSS 5
RSS Trigger 1
run 1
run history 5
run history - apply to all - no drill down possible 1
running 1
safari 1
SAharePoint List Get Items 1
sailpoint 1
Salesforce 4
sap 2
sap ariba 1
SAS 1
save 2
save as 1
Schedule 3
Scrum 1
search 5
Search and Discover 1
search flows 1
Searching 3
second approver 1
Section 1
Secure 1
Security 5
select 2
send an email 1
send email 1
Send Email with Options 2
send email with options comments 1
send from O365 group 1
sender 1
Sending emails 1
Sensors 1
sent emails 1
Service 4
Service account 1
Service accounts 1
Service Bus 2
Service Calendar 1
service request 2
servicenow 1
ServiceNow SharePoint Connector 1
services 1
Setting 1
Settings 1
SfB Presenters 1
SFTP 1
share 4
Share and Embed 1
Share SharePoint Connection 1
shared folder 1
shared form 1
Shared Lists 1
shared mailbox 6
SharedMailbox 1
SharePoint 48
Sharepoint & OneDrive talking to eachother 1
Sharepoint - Get content approval status 1
SharePoint 2016 1
Sharepoint Admin 1
SharePoint Calendar 2
SharePoint Connection 1
Sharepoint Create Lookup Field 1
sharepoint delete file 1
SharePoint Delete Item 1
SharePoint Document Library 2
SharePoint Document Update Properties 1
SharePoint File exists 1
SharePoint File Updated Trigger 1
Sharepoint Files 6
SharePoint Flow 8
SharePoint Flow email attachment 1
SharePoint Get Item 1
sharepoint group 1
SharePoint group membership 1
sharepoint item security 1
Sharepoint library 1
SharePoint List 25
SharePoint List Item 1
SharePoint List Item Fields 2
SharePoint List Item Update 2
Sharepoint Lists 4
sharepoint lists flow 1
Sharepoint online 12
SharePoint Online List 1
SharePoint Permissions 1
SharePoint share 1
SharePoint Site Template 1
Sharepoint site workflow 1
SharePoint Task List to Planner 1
sharepoint trigger 1
SharePoint type float column 1
SharePoint Update Item 1
Sharing Connections 3
sharing powerapps 1
sharing read-only 2
Sheets 1
Shopify 1
sign-off 1
Simple 1
Single Line 1
Skype for Business 5
slack 6
Slack Attachment Posts 1
SmartScreen 1
smartsheet 3
smartsheet integration 1
smartsheet trigger 2
SmartThings Tracker 1
sms 3
SMS Trigger 1
Social Engagement 1
social media 3
Software 1
Software Development 1
Sorting 3
Speech-to-text 1
Speed 1
SQL 2
SQL Connector Issue 2
sql output 2
SQL Server 1
SQL Server trigger 2
staff hub 1
Staffhub trigger 1
Staging 1
start options 1
state machine 1
status 6
Stop 1
storage 1
Stream 1
Studio 1
subfolders 1
submission 1
submit to gallery 1
Subscriptions 1
substring 1
subtasks 1
Suggestion 3
Support Ticket 1
survey 1
survey monkey 1
SurveyGizmo 1
switch 1
switch case 1
switches 1
Sync 6
syntax 1
Tables 1
Task 6
Task Content Type 1
task finish 2
Task List 1
tasks 8
Team 1
team flow 2
Team Services 2
Team Site 1
teams 13
Teams Actions 3
Teams Extended Flow 1
Teams Planner 2
Teilen 1
telegram 1
Template 7
Template Idea 187
Templates 2
Terminate 1
Terminate Flow 2
Terraform 1
tesla 1
test 1
text 2
text array 1
Text Editor 1
Text Fields 1
tfs 1
The OneDrive for Business action requires the ability to retrieve multiple items. 1
there are variations in time. 1
Thumbnail 2
Time Before 1
timed out 1
timedout 1
Timeout 1
Timesheet 3
Timezone 1
Timezone connectors 1
to do 1
To-Do 9
todoist 3
topic 1
Topics 1
Transcoding Connector 1
Transcoding Templates 1
translate 2
Translation 1
Transport 1
Trello 4
TRello Connector 1
trigger 36
Trigger by folder 1
Trigger Failed 1
Trigger not working 1
Trigger on Folder 1
Triggers 42
troubleshooting 1
tumblr 1
Tweet 4
Twilio 1
Twitter 9
twitter connection 1
twitter media 1
twitter quota 1
txt 1
TypeError 1
Typeform 1
typo 1
UI 3
undelete 1
unique id 1
update 6
update document 1
update Entity 1
Update Item 6
update item in sharepoint list 2
Update Item NULL 2
update last modified 1
update planner labels 1
Update SharePoint List Item 1
update Word 1
Updated 1
Updates 1
Usability 2
user 1
User Experience 1
User Interface Idea 258
User-Defined Field 1
UserInfo 1
Users 1
Using flows 2
Using&Running Flows 3
utc 1
Varbinary 1
Variable 4
variables 7
Version 4
Version Control 1
Version management 3
versions 2
Vertical Scroll Bars 1
Video 1
view 1
virtual desktop 1
visibleselections 1
Visio 2
Visual Studio 2
Visual Studio Online 2
Visual Studios 5
Voice 1
volume 1
Vote 1
VSTFS Connector 1
VSTS 12
VSTS Connector 1
Wait for task completion 1
WDL 1
webcal trigger 1
webhook 1
Website 1
weekends 1
when a new email arrives 1
When an event is added 1
When you create "Do until" and start Flow 1
Widgets 3
Wiki 1
Windows 1
Windows File Manager 1
Windows Phone 1
Word 3
Word Connector 2
Wordpress 1
Work Item 3
work items 1
workchat 1
Workday Integration 1
Workflow 4
Workflow Changes 1
workflows 1
Workfront Connector 1
workplace 1
wunderlist 4
Yammer 13
Yammer Connector 4
YES NO column 2
YouTube 2
Zeitzone 1

Share your ideas and vote for future features

Support "Execute a SQL query" action through an on-premises data gateway

Get values of a row of array with no-expression

Helpful resources

Make it possible to duplicate actions in a Flow

Copy action - time saver

Sharepoint Create Folder

set item level security in SharePoint

Need Triggers for Dynamics 365 Operation