Filter (Dataverse Views) not working in PowerApp after Deployment and App Publish

(0) Share

Report

Posted on by LV

Hi folks,

i'm slowly getting grey hair with my issue.

I have a simple Powerapp with a Gallery based on Dataverse. In Dataverse i have for a table several Views which I would like to display in the Gallery as a DropDown filter. Nothing special.

So far so good. This works on my Dev, Test and Production. Then I did some changes in PowerAutomate (nothing related to that field or gallery) and suddenly the filter does not work anymore. Same changes are on Dev and Test and the filter works fine.

OnChange of the Dropdown:

Set(galleryAVFilter, Switch(DropdownFilter.Selected.Value,"My Agreed Volumes", 'Agreed Volumes (Views)'.'My Agreed Volumes',"My New Agreed Volumes", 'Agreed Volumes (Views)'.'My New Agreed Volumes','Agreed Volumes (Views)'.'Active Agreed Volumes'))

Anyone a solution what could've gone wrong with the deployment? Solution layer have been checked, it is the exact same formula statement than on Dev and Test.. anyone else had the same issue?

Thank you so much in advance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@LV

Can you check the view Ids and whether they are the same in Dev and Prod ?

Also have you tried Editing app in Prod or it is in a managed solution?

Has this views been created as part of the solution or did pre-exist and you have to recreate in Dev?

Was this reply helpful? Yes No
LV 10 on at

Like (0)

Report

Hi @Mira_Ghaly ,
thank you for your help. The App is in a managed solution and the views have been first in Dev and not being prexist in prod.

How can I check the view IDs?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@LV

From the solution -> Navigate to table , Views select the view and click Edit and the View ID should be in the URL as below:

Was this reply helpful? Yes No
LV 10 on at

Like (0)

Report

@Mira_Ghaly the view IDs are the same in Dev, Test and Prod...

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@LV

Have you checked that the app published version is the same as well?

Was this reply helpful? Yes No
LV 10 on at

Like (0)

Report

Hi @Mira_Ghaly , yes it is. i published it again. The weird thing about that is, that no changes have been made to the filter for months..

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@LV

Another thing worth checking and could be different across environments is that it might be a permissions issue so can you check the data returning from the same views ?

I am just trying to troubleshoot with you and think loud.

Was this reply helpful? Yes No
LV 10 on at

Like (0)

Report

Hi @Mira_Ghaly ,
the data is the same than a week ago, nothing changed and it was working back then..
could there be an issue because I published the app after the deployment?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@LVi really doubt that this can be an issue

Was this reply helpful? Yes No
LV 10 on at

Like (0)

Report

@Mira_Ghaly i guess I found the problem.

I have the following rules behind my gallery:

SortByColumns(Filter('Agreed Volumes', galleryAVFilter,SearchText.Text in Name||SearchText.Text in 'Agreed Volume Number'||SearchText.Text in 'Business Units'),"askam_agreedvolumenumber",If(SortDescending1, Descending, Ascending))

SearchText.Text in 'Business Units' is referring to a lookup field in the entity. We have over 500 records in the system. After removing this expression the DropDown Filter started working again..

Any clue why this searchable lookup field causes trouble in the dropdown but not in the search itself? The search was working fine and the lookup field was searchable.

Was this reply helpful? Yes No