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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / suppress no data from ...
Power Apps
Answered

suppress no data from server error

(0) ShareShare
ReportReport
Posted on by 24

I have a combo box of locations. When you select a location it returns currant orders for that location. When a location has no orders I get this error.

"message": "BadGateway", "innerError": { "error": { "code": "NoResponse", "message": "The server did not received a response from an upstream server. 

 

I understand my SQL stored procedure is returning an empty record set that's why the error is happening. I'm ok with receiving an empty record set, how do I let Power Apps know not to display this error?

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @RogerHar ,

     

    Could you please share more details about your scenario? 

     

    Assuming that you are working on a Canvas App, locations are in Combo Box, and orders in the selected location would display in a Data Table or Gallery, then you could leverage a IsEmpty function in the Items of the Gallery or Data Table, looks like below:

    If(IsEmpty(Filter(Table,location = ComboBox.Selected.Location)),Blank(),Filter(Table,location = ComboBox.Selected.Location))

     

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard