Filter PowerApps Gallery using Dataverse Views from Dropdown

(0) Share

Report

Posted on by ell10706

112

Hi all,

I've looked around a bit for an answer to this one and can't find anything that matches my exact scenario, so I'm wondering if this is possible:

I have a Dataverse table called "Reservations" that I'm showing in a Gallery. I want to use a drop-down on the same page to filter the gallery based on predefined Dataverse views I've created.

I'm able to populate the combo box with the view names (Choices('Reservations (Views)'); however, when I try to use Filter() to compare them, I get a data type mismatch (View vs. ViewValue).

Filter(Reservations, 'Reservations (Views)' = filterReservations.Selected.Value)

If I try to use the property selector on 'Reservations (Views)', I can only select existing views (i.e. "My Reservations).

I know I could probably get around this by just writing a complex Filter statement, but I'd prefer that Dataverse does the work for me. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@ell10706

A Dataverse view is a filtered/sorted table. If you use your selector on the right side of the screen and select the table in the top dropdown and the view in the dropdown below it, PowerApps will create the correct formula and show it in the window.

In the screenshot below, I used the view as the table to be filtered by the value in the dropdown.

Was this reply helpful? Yes No
ell10706 112 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the response, @Drrickryp. This is almost what I'm going for, with one difference. In your dropdown, you're filtering on a choice value in Dataverse. I want my dropdown to be a list of Dataverse views that I can select which will in turn change the filter applied to the gallery.

i.e. "Active Reservations", "Expired Reservations", etc.

I know I can choose the "View" from the PowerApps menu, but I see no way to dynamically change the view this way:
Filter(Reservations, 'Reservations (Views)'.[varViewName])

Was this reply helpful? Yes No
Verified answer

ell10706 112 on at

Like
a
(1)

Report
Copy link

Link copied!

I was able to resolve this by changing Choices('Reservations (Views)') to Choices('Reservations (Views)').Value. Then, when using Filter(Reservations, filterReservations.Selected.Value), the data types match.

Was this reply helpful? Yes No