You’re offline. This is a read only version of the page.
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?
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:
Share
Report
All responses (
Answers (
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.
