Gallery - Grouping Rows in Excel & Gallery Parts Going to Different Screens

[NloAH45]

Hi! I am creating an app to work as a help center and bringing in data from an Excel Spreadsheet and I right now have a gallery that is grabbing information from one column, however, there are multiples of the same text/category and I don't want them to repeat and I was wondering if anyone knows how to stop that?

And then from there I wanted some of the rows/buttons to go to different screens but I don't see an obvious way for that to be possible with a gallery, so I am hoping someone has some helpful tips! 

Ex) Coverages > Screen 1

      Hospital > Screen 2

Which is all in my spreadsheet laid out.

Thank you!

[attached is the app screen showing them repeat]

[v-bofeng-msft]

Hi @NloAH45 ,

If you want to remove duplicate items based on a specific field, you can use the Distinct function.

For example , you could set Gallery1's items property to,

Distinct(Table, ColumnName)

Gallery1 will display the deduplicated results. Then, if you need Gallery2 to display relevant information based on the selection in Gallery1, you could set Gallery2's items property to,

Filter(Table,ColumnName=Gallery1.Selected.Value)

Best Regards,
Bof

[NloAH45]

Thanks so much for your help @v-bofeng-msft !  

I got the deduplication to work, but am still having a hard them with the filtering from one gallery to another, whenever I use the formula above and plug in what I think I should it gives me an error. I am wondering if I am plugging in something wrong but I have tried swapping parts in and out to see what would work. 

If I go from categories (gallery 1) to subcategories (gallery 2) and need them to filter by what I choose (coverages > loading coverages, terming coverage, etc. and then hospital > admissions, etc.), would the formula be

Filter (Table#, Subcategory=Gallery#.Coverages.Value)?

Thanks again for your help!