Filter Data based on selected value in Option set

[vaishalivyas1]

Hi,

I have option set field on one screen based on the value selected in option set I want to filter data in gallery in other screen.

Screenshot of Logic:

Screenshot of Error:

 

Thanks in Advance

[v-micsh-msft]

Hi @vaishalivyas1,

Could you please share more details about which control you are working with?

I suspect here you are working with the Gallery2 control, if this is the case, then the formula should be changed in the following way:

if(DataCardValue5.Selected.OptionValue = 100000000, 
   SortByColumn(filter('Project Task Billing Codes', 
                        statecode=0 && _cf_projecttaskid_value= Gallery2_1.Selected.cf_projecttaskid),
                "cf_name"),
   SortByColumns(Filter('Project Task Billing Codes',
                        _cf_projecttaskid_value= Gallery2_1.Selected.cf_projecttaskid),
                 "cf_name")
)

The Error should be caused by refering the own value of the gallery control, and this is not supported.

A control can't have its own items property refering to its own property value.

Regards,

Michael

[vaishalivyas1]

Hi @v-micsh-msft

In Gallery2 I have Project Task and in Gallery2_1 I have Project case. based on value selected in option set on EditScreen1 I want filtered results on Gallery 3. 

[driverdo19]

I have had similar problems when passing a variable from screen 1 to screen 3 (by using a intermediate screen 2).

I learned to never selfassign any variables: for example don't use -> varExtern : varExtern

Try to use it as follows:

Screen1 : Navigate(Screen2;Fade;{varExtern : 'my assigned variable'})

Screen2 : Navigate(Screen3;Fade;{varExternal : varExtern})

Screen3 : here you can use varExternal