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 35
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 82
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 1,800
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
Dataflows 1
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 15
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,850
General Flow Idea 8
General Power Automate Feature Idea 1,901
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 69
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
MySQL 2
NDR 1
nested condition 1
Nested Conditional Steps Limit 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
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
parallel branch 1
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 19
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 Apps Build Tools 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
Solutions 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 392
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 630
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

AI Builder Form Processing - needs a feature to de...

Modern Approval page as Iframe

Adding an Attachment to an Approval Email In Flow

Include Checklist Within Planner Task When Created...

AI Model should detect different form types and or...