Power Platform Community Forum Thread Details

I have a form with multiple options for a user to select. The only way I can think to show this to the user is to allow them to drill down into the data and filter a level, select what they want then filter another level and select again.

The issue I am encountering by doing this is either
I can only collect what is currently showing in the gallery
OR

duplicates are added to the gallery

Solving either of these issues will resolve my issue so I'm just looking for the best way to go about it.

I've mocked up an example using made up data.

The user will only choose one gallery title and shop, but they can filter the Product column to drill down as there's hundreds of rows to choose from. If I remove their ability to filter Product, I can collect everything I need - but this will spoil the user experience and make it difficult to use.

I've tried to use distinct on the collection but I didn't get anywhere so I'm now looking to have another gallery in the background (on a page the user cannot see) which just holds anything which is selected in this gallery below?

Can anyone tell me how to do that or suggest a better way of going about it?