{"id":16788,"date":"2021-10-07T09:00:00","date_gmt":"2021-10-07T16:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/canvas-app-troubleshooting-part-1\/"},"modified":"2021-10-07T09:00:00","modified_gmt":"2021-10-07T16:00:00","slug":"canvas-app-troubleshooting-part-1","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/canvas-app-troubleshooting-part-1\/","title":{"rendered":"Canvas App Troubleshooting – Part 1"},"content":{"rendered":"

Overview<\/h1>\n

In this blog series, we’ll discuss some strategies our support team use when troubleshooting issues in canvas apps. We’ll focus on strategies that any app maker can use to diagnose and fix issues in their apps. To illustrate, let’s start with a scenario.<\/p>\n

Scenario: A Filter() statement that returns no items<\/h1>\n

Let’s say you have a gallery, and the Items property for the gallery is something like this:<\/p>\n

Filter(MySharePointList, ContactEmail=cmbContacts.Selected.Email)<\/code><\/p>\n

Where MySharePointList is a SharePoint list containing Departments in your company, and cmbContacts is a Combo box of possible department contacts, populated from an Excel spreadsheet.<\/p>\n

Problem: the gallery isn’t showing any records. What could be causing this?<\/p>\n

\"\"<\/p>\n

Break the formula into component parts<\/h2>\n

In the Filter() statement, we have three elements:<\/p>\n