Post
Ask Question

PowerApps - How To Filter Data Verse Choice Field In Gallery

Introduction

In this article, we are going to see about what PowerApps Filter will work for Choice field in the dataverse and how it is useful to develop Power Platform Applications.

PowerApps is a service-oriented application used for developing custom apps for your organization.

Easily develop mobile and web apps for any business need—even if you have no technical or development experience—with Power Apps. 

PowerApps helps us create simple apps quickly. Through PowerApps templates, we can customize our applications. With PowerApps, we can connect to our company data coming from

  • Oracle
  • SAP
  • Salesforce
  • Office365
  • Azure
  • Excel/CSV Files

It simplifies the development cycle of the business apps and equips the business users and developers to build custom native, mobile, and web applications.

Launch Canvas App

The steps are given below to create a Power App based on On-Premises data.

  • Login to Office 365 SharePoint site and click the list, where you want to add PowerApps.
  • Click PowerApps link in the list ribbon given below.
  • Enter the PowerApps name and it will redirect to the PowerApps Studio.

Click blank App.

Create Choices Field in Data verse

Developers have trouble filtering on a choice column to display the values in drop down. I have a Dataverse table 'Demo Choice' that lists the following:

Now display the Table Values into Gallery in our Canvas APP

Add Gallery and include Data verse Table as Data Source

Now Add Combobox to load the choice Values,

Now Connect Filter with Gallery, so that Gallery will populate the values based on the combo box selected value,

Then change your Gallery Items to like this,

Filter(DemoChoices,TestStatus=ComboBox1.Selected.TestStatus)
DemoChoices=Table Name
TestStatus=Choice Field Column Name in Table

Now Select the Filter and choose the value then gallery will be filtered with selected value,

Conclusion

PowerApps gives you the ability to connect with all kinds of data, which is not only available with your Tenant but connected to it via the Data Management Gateways.

PowerApps is truly the future of building custom forms and then making them available on mobile devices for your organization.

Was my article helpful? If yes, please let me know and if not, please explain what was confusing or missing. I’ll use your feedback to double-check the facts, add info and update this article.


Similar Articles