Displaying the image in the gallery

[Viatsyk]

Dear community
I am trying to create an application that will display the values in the gallery based on filters.

The formula for "grouping" dropdown (Items):

Sort(Distinct(MenuCard;GROUPING);Result)

The formula for "Event Category" dropdown (Items)::

Distinct(Filter(MenuCard;GROUPING=DropDown_Grp.Selected.Result);'EVENT CATEGORY')

The formula for Gallery(Items)::

Distinct(Filter(MenuCard;GROUPING=DropDown_Grp.Selected.Result);'PREFERRED Platform')

I want the values in the gallery to be filtered based on the drop-down list "Event Category". Basically, it works, but the images are not displayed. I have added links to them in the excel data table that I use:

If I create a new gallery without linking it to the result of the "Event Category" dropdown list, then there are images:

How can I make images visible?

One more question: 

How to make this invisible before it will show results? 

[v-xiaochen-msft · Accepted solution]

Hi @Viatsyk , 

Could you tell me: 

• Do you want to filter the data in the gallery control by ‘GROUPING’ and ‘EVENT CATEGORY’ fields? 
• Are there records with the same value in the ‘PREFERRED Platform’ field? Do you want to de-duplicate them and get the first record?
• Do you want the gallery control to be invisible when the values of two dropdown controls are blank ?

If the above assumptions are true , let me explain why you encountered this problem: 

The formula of the items property in the gallery cannot meet your needs.

• Firstly, this formula only filters records through the GROUPING field.
• Secondly, after using distinct() function, the data in gallery only has the 'PREFERRED Platform' field.

So, the key is to use forall() function and lookup() function to make the record contain two fields (Image and 'PREFERRED Platform' ) while removing duplicate records.

I've made a test for your reference:

1\ Show my test list

2\ Add a dropdown control 'DropDown_Grp' to screen and set its Items property to:

Sort(Distinct(MenuCard,GROUPING),Result)

3\ Add a dropdown control 'Dropdown2' to screen and set its Items property to:

Distinct(Filter(MenuCard,GROUPING=DropDown_Grp.Selected.Result),'EVENT CATEGROY')

4\ Add a gallery control to screen and set its Items property to:

ForAll(

    Distinct(

        Filter(

            MenuCard,

            GROUPING = DropDown_Grp.Selected.Result,

            'EVENT CATEGROY' = Dropdown2.Selected.Result

        ),

        'PREFERRED Platform'

    ),

    LookUp(

        MenuCard,

        'PREFERRED Platform' = Result

    )

)

5\ Set visible property of the gallery control to:

If(IsBlank(DropDown_Grp.Selected.Result)&&IsBlank(Dropdown2.Selected.Result),false,true)

6\ The result are as follow:

Best Regards,

Wearsky