web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / List rows throws an er...
Power Automate
Unanswered

List rows throws an error when no result is found

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I am new here and today I designed my first flow 💪

 

Unfortunately it sometimes throws unexpected errors: 

 

  • I use the list rows command to search for an external ID within the contacts table
  • everything is fine, when a contact is found
  • If list rows doesn't find a contact it throws an error. See an example output here:

 

 

 

{
 "statusCode": 400,
 "headers": {
 "Cache-Control": "no-cache",
 "x-ms-service-request-id": "......",
 "Set-Cookie": ".........",
 "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
 "REQ_ID": ".........",
 "CRM.ServiceId": "framework",
 "AuthActivityId": "........",
 "mise-correlation-id": "......",
 "X-Content-Type-Options": "nosniff",
 "X-Source": "...........",
 "Public": "OPTIONS,GET,HEAD,POST",
 "Date": "Mon, 05 Feb 2024 14:20:57 GMT",
 "Allow": "OPTIONS,GET,HEAD,POST",
 "Content-Type": "application/json; charset=utf-8",
 "Expires": "-1",
 "Content-Length": "340"
 },
 "body": {
 "querycontext": null,
 "error": {
 "code": "SearchableEntityNotFound",
 "message": "No entities were found to be searchable. Please make sure that you have at least one entity selected. Please see this link for more details: https://go.microsoft.com/fwlink/?linkid=2154384"
 },
 "value": null,
 "totalrecordcount": 0
 }
} 

 

 

 

  • Totalrecordcount = 0 is absolutely OK when no dataset is found
  • But instead processing the rest of my flow which checks exactly this, it throws an error

     

    I haven't found any option to control whether zero results is allowed or not.

     

    What am I doing wrong?

     

    Best Regards and thanks a lot for each hint

    Peter

     

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Expiscornovus Profile Picture

Expiscornovus 199 Most Valuable Professional

#2
David_MA Profile Picture

David_MA 194 Super User 2025 Season 2

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard