Filter Gallery using Dataverse Views in Power Apps

In this video, you will learn how to simplify filtering data from Dataverse by directly using Dataverse Table Views in PowerApps Gallery control.
The View based filtering technique simplifies the experience of creating filter conditions (Filter formula) in the Canvas Power Apps.
We will dynamically load the Views inside Power Apps & provide the users a View selector option. Upon selection of a View, the filtering & sorting conditions associated with the View will be applied to the Gallery or Data Table.
Advantage of this technique is simplified experience for creating filters against data (related tables, multiple filter conditions, AND & OR operations, etc.) & no changes are needed in Power App to update / create new filter conditions as all logic is driven from Views (No need to republish the App).

Video covers the following:
✅ Dataverse Views in Power Apps.
✅ Create Views in Dataverse Tables.
✅ Views - multiple filters, sorting, related table filtering, etc.
✅ Load views dynamically in Power Apps (show specific Views).
✅ Filter PowerApps Gallery using Dataverse Table Views.

✨ PowerApps Multiple Filters on Gallery:

✨ Filter Dataverse Choice column in Power Apps Gallery:

#PowerApps #Dataverse #MicrosoftDataverse #Gallery

Table of Contents:
00:00 - Intro
00:31 - Filter Gallery in Power Apps
01:24 - Microsoft Dataverse Table Views
01:44 - Power Apps use Dataverse Table Views to filter gallery
03:24 - Dynamic Views in Power Apps
05:19 - Activate / Deactivate Views
05:42 - Show specific Views in Canvas PowerApps
06:28 - Filter Gallery by Related Dataverse Tables
07:27 - Filter Gallery using Dataverse for Teams Views
08:09 - Create Views in Dataverse for Teams
10:09 - Subscribe to Reza Dorrani Channel

🤝 Let’s connect on social:

[BritonWells]

Excellent video, did not think of using a dropdown for views. Love the Dataverse content!

[sandrasoniec]

Thanks Reza for this video, exactly what I was looking for
To achieve the same in Dataverse for teams with new fluent UI components
- Choose a Combobox
- Set Items property to Choices('YourTableName (Views)')
- Edit the Field property and select "Value" to display the view names in the combobox

[fredbarnes]

This was worth the money just by understanding that populating views or collections from views requires this funky filter syntax

[berggrog]

Reza - You are the best kept secret on Youtube. 80k subs should be 800k. You make things so easy to understand and have such awesome solutions. You are a gift to the community. Thank you So much my man!!!!

[lencardinal]

The rest of the internet said a View selector couldn't be done. 🙂Thanks, Reza!

[SidhuRam]

Very informative Reza. Never leveraged the views in dataverse, as i was not very sure how to make use of them. This is a great starting point. Thank you.

[michaeljiang]

Thank you Reza, this is exactly what I want, just discussed with my colleague this morning at office, so great is your sharing.

[SandeepSingh-lgbq]

Simply amazing, plz don't stop publishing more videos. Thank you so much.

[oluwatobiyusuf]

This is so cool. The dataverse view capabilities is a plus to PowerApps

[juandavila]

Thank you for this wonderful video. I am working with dataverse tables, I like them but I need to improve more about it. Your videos are increíbles, I try to repeat your lessons

[designmycity]

This video is amazing. There are so many tips and tricks in this video. Thank you very much.

[usodaniel]

Thank you!!! I was struggling with this!

[LauraDrennen]

Thanks for the great video! Do you know if it's possible to set a default value on the dropdown when using a list of dataverse table views?

[Kim-qjvz]

Thank you so much for the great video!!!

[sundrapillay]

Thanks Reza have a great festive season

[necdetsaritas]

Learning continues. It was great information. Thanks Reza

[felixverduin]

Great stuff again Reza! This is pretty awesome and I will definitely use it. The only thing I am missing is for users themselves to dynamically make/adjust views in the application itself.. Unfortunately, I do not think there is a possibility for such a thing, is there Reza?

[AmmarRamadan]

Great Reza, thank you.
Powerful capabilities with Datavers! Can we do the same with SQL views? or we will lose this flexibility.

[RudimarPowerApps]

Tks for the nice video Reza.
Constantly I get this issue inside Power Apps when I try to use a view: "Distinct is not allowed when image attributes are selected.".
Have you ever faced this and do you know the reason and how to solve it?

[GreyDob]

Super solution to avoid the filter limitations and speed up things. Only, what if you had 2 or more filters?