Join the discussion

Getting err 'The key didn't match any rows in the ...

by on Latest post on by

9 Replies 2433 Views

9 Replies

2433 Views

SQL get rows returns no rows on select * from on p...

by on Latest post on by

10 Replies 4997 Views

10 Replies

4997 Views

Helpful resources

Labels

302 error 1
400 2
400 error 1
403 1
404 3
404 error 2
502 1
502 Bad Gateway 1
502 error 1
[Rss Feed Auth] 1
Access 2
Access Denied 1
Accounts 2
Action 5
actions 1
active directory 1
activity suspended 1
add connection 1
Add Item 1
admin 1
Admin Center 1
Adobe Sign 1
AEMET API 1
AI 1
alert 1
anonymous 2
api 14
API key authentication 2
App usage report 1
Application Insights 1
Apply to Each 2
Approval email 2
Approval Flow 2
Approvals 3
Approver task 1
Aria 1
Asana Integration 1
Asana Projects 1
assigned to 3
Attachements 1
Attachment 1
attachment content 1
attachments 1
attchments 1
auth token 1
authentication 6
authentication error 6
Authorization 5
auto-increment 1
ax 1
azure 5
Azure AD 3
Azure Analysis Services 1
azure api management 1
Azure Automation 2
Azure Blob Storage 1
Azure Blog Storage 1
Azure cosmosdb 1
AZURE DATABASE 1
Azure DB 1
azure dev ops 1
azure devops 1
Azure File Share 1
Azure Logic Apps 1
azure resourcemanager 1
Azure Run Book 1
azure sql 2
AzureAD 1
Bad Gateway 4
bad request 1
Bad_Request 1
BadRequest 1
bandwidth 1
Barcode 1
Bearer 1
Bing Maps 1
bitbucket 1
blob storage error 1
Bot 2
Box 3
box.com 1
broken connector 1
buckets 1
Bug 2
business central 3
Business Central Connector 3
calculation 1
Calendar 5
calendar events 1
call 1
CallStack 1
CDS 2
CDS for Apps 1
CDS2.0 2
cell update 1
certificate 1
channel 1
Chatter 2
Chatter Connection 1
Check Out 1
Choice Fields 1
cognitive services 1
cognito 1
Collections 2
columns 1
Common Data Service 5
Community Guidelines 1
compare 1
completed tasks 1
connect 2
Connect to data 12
Connecting Planner 1
Connecting to Data 324
Connecting to Forms 1
connection 6
Connection Error 4
connection issue 1
connections 9
Connector 9
connector error 3
Connector IP 1
connectors 7
Consumption 1
Content Types 1
cookies 1
Copy File 1
Corrupt Excel files 1
cosmosdb 6
coverter 1
create 2
create item 3
creating connectors 1
Creating flows 163
credentials 4
CRM 3
CRM Dynamics dynamic values to a sharepoint List item. 1
CRM security role flow 1
CSV 4
CSV Table (Flow) 1
Custom API 6
Custom Connector 27
Custom Connector Push 1
custom view 1
d365 1
D365 Business Central 1
D365 for operations 4
d365 to planner 1
D365FO 2
data 5
Data Collection 1
Data connection 5
data connections 2
Data Connector 3
data entity 1
DATA GATEWAY 3
Data mash-ups 1
Data Operation 1
data source 2
database 3
datasource 2
DataSourceInfo SharePoint Permissions 1
datatable 1
Date 1
Date and Time 5
datetime 2
Decryption 1
Default Environment 1
delegation 1
Delete Action 1
delete files 1
Delete list item 1
detect faces 1
DevOps 2
displaying information 1
DLP 5
Document Library 1
documentation 1
drive 1
dropdown 1
Dropdown control 1
dynamic content 4
Dynamics 4
Dynamics 365 11
Dynamics 365 for Operations 2
Dynamics GP 1
Dynamics NAV 1
e-mail 1
Email 8
Email attachments 1
email flow 1
Email HTML table 1
email trigger 1
emails 1
Entities 1
Entity 2
Environment 2
ERROR 9
error 400 1
error 500 1
error 502 1
error 520 1
Error code 3
error Connection. 1
error message 3
Event 1
Event list 1
Excel 19
Excel (business) 1
Excel (OneDrive) 2
Excel Business 5
excel connector not available 1
excel get formatted rows 1
Excel get rows 6
Excel import 1
Excel Insert Row is looking for a deleted Manual Trigger Input Text and causing Flow error 1
Excel Online 6
Excel Sharepoint 3
Excel Source 1
Excel update rows 1
EXCEL_UPDATE 1
execute 1
expand query 3
Export 2
Export Email flow 1
external users 1
Extract Folder 2
Extract Text 1
Facebook 1
FaceBook Get Page Feed 1
facebook pages 1
failed 1
failed to fetch 2
field 1
fields 2
File 2
file content 1
File Properties 1
File System 8
Filter 4
Filter query 1
Filtering 1
Firewall 1
Flickr 1
flow 70
Flow & Dynamics 1
Flow & Planner 2
Flow Action 23
Flow Action HTTP 1
Flow Actions 13
Flow Bug 1
flow button 1
Flow Changes 2
Flow Condition 6
flow connecting to data 3
flow connector 4
flow data 1
flow data connection 2
Flow dynamic field not available 2
flow dynamics 365 connector error 1
Flow editor 1
Flow email 1
Flow Error 12
Flow Errror 5
flow excel 2
flow failed 1
Flow Feedback 1
flow ideas 1
Flow Mobile App 2
Flow Operations 2
flow runs 1
flow sharepoint 1
Flow Trigger 8
FLOW Use 9
flow using 2 data sources 1
flowm connecting to data 1
Flows 10
Flows Sharepoint list 2
folder 1
folder management 1
forbidden 1
ForEach 1
Form Data 3
form responses 1
format text 1
Formatting 2
Forms 14
forms flow 1
Forum Help 4
Freshdesk 1
FTP 5
Function 1
functions 1
gallery 1
gateway 9
Gateways 3
GCC 1
General Discussion 1
General Questions 83
Get calendar view of events (V2) 1
get file content 1
Get File Properties 1
get items 2
Get Manager 1
Get page feed 1
Get records 1
get row 1
Get rows from Excel table 4
Get User Profile 1
Get_Files 1
getmails 1
Getting problem when connect with datasource 1
github 1
Google 4
Google Calendar 1
Google Keep 1
Google Sheets 3
Graph 4
Graph API 1
Group 1
header 1
Help 4
Help needed 1
help wanted 1
How To 1
How to trigger azure webjob in flow 1
How to use MS flow without Office 365 1
html 1
HTML Table 1
html to text 1
HTTP 6
HTTP Action 7
HTTP Action Failed 1
http authentication 1
HTTP Get 1
HTTP Post 1
HTTP POST Custom API 2
HTTP Request 4
HTTP SharePoint 1
HTTP Workflow 1
HTTPS Request 1
hybrid 1
Hyperlink 1
I Found A Bug 7
id 1
Images 1
Import 1
Import Package 1
Increment 1
Info 1
InfoPath 2
InfusionSoft 1
Insert Row 1
insert text 1
Insights 1
Instagram 2
Instructure Canvas 1
Integrate 1
invalid property 1
IOS Authorization Errors 1
IP Whitelist 1
IS 1
Issue Building a Custom Connector 297
Issue Making a Connection 889
Issue Using a Connection 792
javascript 1
Jira 1
JSESSIONID 1
JSON 5
JSON Error 1
JSON Parse 1
Json parze xml 1
Kusto 1
le 1
leankit integration 1
Limit 3
limits 1
link to a file 1
Link to Item 1
Linked missing 1
LinkedIn 1
list 3
List Files in Folder 1
list form 1
list of stored procs 1
List Records 1
list rows present in a table 1
ListItem 1
local folder 1
log in error 1
Lookup Column 1
Lookup function 1
mail merge 1
mailbox usage report 1
mailchimp 1
Managed Metadata 1
Manifest 1
Mentions 1
message 1
Microsoft Flow 7
Microsoft Project Online Connector 1
Microsoft Word 1
missing 1
Mission Control 1
Mobile Apps 3
Ms Flow 5
MS Flow Approvals 1
MS FLOWS 1
MSFlow 6
multi-select 1
multiple dlp 1
multiple values 1
MySQL 1
name 1
Nav 2
NAV FLOW 2
Need Help 1
netsuite 1
Network 1
NetworkError 1
New Item is Created 1
new user 1
No values matching your search 1
NotFound 2
notifications 1
Null reference exception 1
Number 1
O365 1
oauth 3
oauth2 6
ODATA 9
Odata filter 1
OData Filter Query 6
odata filter query single quote apostrophe 1
ODBC 1
Off Topic 2
Office 365 4
Office 365 error 1
Office 365 groups 1
Office 365 Outlook 3
Office 365 Users 1
Office 365 Video 1
Office365 3
Office365Users 1
office365users in the block list 1
offline 1
On Prem data 1
On-Prem 2
On-Premise 3
On-Premise database 2
on-premise gateway 8
on-premise sharepoint 1
on-premises 1
on-premises APIs Windows Authentication 1
one drive business 2
one drive for business 1
OneDriive 1
onedrive 3
OneDrive (ForBusiness) 4
OneDrive for Business 4
OneNote 4
Open API 2
openapi 1
OperationNotFound 1
Opportunities 1
ORACLE 1
Outlook 8
Outlook 365 6
Outlook contact 1
outlook integration 1
Outlook.com 3
Outloot Calendar Accept Decline Request 1
output 1
pageextensions 1
Parameter 1
parameters 1
parameters extraction 1
parse JSON 1
Parser 1
Parsing fromdata key value 1
path.$. Table 1
PDF 1
pdf conversion 1
Permission 2
permissions 3
pinterest 1
planner 6
Planner Trigger 1
Post 1
postgres 1
posts 1
Power Apps 1
Power Automate 2
Power BI 7
Power Query 1
PowerApps 17
PowerApps SharePoint 1
PowerAppsFlow 4
PowerBI 2
Powershell 1
privacy 1
profile 2
Project 1
project online 2
public folder support in flow 1
pwa 1
QnA Maker 1
Query 5
Question 1
QuickBooks Online Integration 2
r 1
Read Content 2
Recurrence 1
REMOVE function 1
Resources 1
REST 2
REST API 8
Row ID 1
RSS 2
RSS Trigger 1
runbook 1
Runtime sproc 1
SAharePoint List Get Items 1
Salesforce 6
Samanage 1
Save record from jot form 1
Schedule 1
search 1
Security 2
Security Role 1
send an email 1
Sending emails 1
Server Response 1
Service 1
SFTP 3
shared mailbox 1
shared_office365 1
shared_office365_1 1
SharedMailbox 3
SharePoint 36
sharepoint "calculated column" 1
SharePoint 2013 2
SharePoint 2016 5
SharePoint Calendar 1
SharePoint Connection 5
SharePoint Connector 1
SharePoint copy file 1
SharePoint Document Library 4
SharePoint File Updated Trigger 2
Sharepoint Files 1
SharePoint Flow 8
Sharepoint Get Items 2
Sharepoint library 1
SharePoint List 18
Sharepoint List Custom Value 1
SharePoint List Item 3
Sharepoint Lists 1
Sharepoint online 6
SharePoint Tasks 1
Sharepoint to Azure DevOps 1
SharePoint Views 1
sharepoint-online 1
Sharepoint365 1
Sharing File Connector 1
Sheets 1
Shoutouts Powerapp 1
Sign in 1
simple quote 1
Site Address 2
Skipped 1
Skype for Business 1
slack 1
Slow 1
smartsheet 3
smartsheet integration 1
social media 1
SP 1
SQL 16
SQL -FLOW Error 2
SQL connection 1
SQL connector 2
SQL Connector Issue 4
sql database 2
SQL GET ROW 1
SQL GET ROWS 3
sql insert row 3
SQL Patch permissions 1
sql query 1
SQL Server 9
SQL Server Views 1
SQL Stored Procedure 4
SQL table 1
Squarespace 1
Staffhub 1
Start an Approval 1
status 400 2
stored procedure 8
Stream 1
Subscriber 1
subsite 1
survey monkey 1
Survey Monkey Flow Creation 1
Suspended flow 1
swagger 3
Sync 1
Table disappearing 1
tableextensions 1
Tables 1
Task 1
Task List 1
tasks 1
teams 3
Teams Flow Catch All 1
Template 1
Templates 1
tenant 1
text 1
The action could not be completed 1
Time Format 1
Timezone 1
To-Do 1
To-Do's 1
todoist 2
token 1
Token Error 2
Track data 1
Trello 4
Trello inputs 1
trigger 6
Trigger Failed 2
Triggers 9
troubleshooting 1
try again 1
Twitter 6
twitter connection 1
Twitter Connector 3
Typeform 1
Unable to connect to On Premise SharePoint 2013 1
unattended 1
Unauthorized Error 2
UniVerse 1
update field from another list 1
Update File Properties 1
Update Item 4
update list item 1
Update row 1
Updates 2
upn 1
Urgente 1
url 2
User Profile 1
UserInfo 1
Using flows 49
utcNow() 1
Variable 1
variables 2
Visual Studio 1
Visual Studio Online 1
VSTS 3
VSTS Connector 2
VSTS Integration 2
WEB API 2
Web Automation 1
WebDav 1
webhook 5
Website 1
Websites 1
why release a beta product to paying customers as if it is ready for primetime 1
Work Item 1
Workflow 1
Wrong database 1
wunderlist 1
Xero 1
XML 1
Yammer 6
yammer api 2
Yammer Connector 1
YouTube 2
zendesk 3
Zendesk Dynamics CRM 1