Hi All,
I have an app that that is used to quote the cost of Wire Harnesses. I have a Dataverse table named AUNA Wire Harnesses that currently contains every part associated with our Wire Harnesses, and it contains data like the "Category", "Wire Harness Number", "Price", "Description", etc.
I would like help trying to figure out how to get a distinct list of my part numbers based on their category. Currently in my radio box, I am using Filter('AUNA Wire Harnesses', Text(Category) = "Connector") to pull in all my parts marked as connectors. My issue is the same connector can be used in multiple different wire harnesses, so there are multiple rows with the same part, resulting in duplicates in my radio box. I would like to have each part number appear only once in the radio box. My goal is to later on have the app figure out which wire harness is being produced based on the selected choices. Connectors are the very first part that needs to be selected. I have tried using the Distinct function but have not had success.
Duplicate parts have a red dot next to them.
Any assistance is greatly appreciated!
