Power Platform Community Forum Thread Details

Hi everyone,

I'm having trouble with duplicate values appearing in lookup dropdowns in my Power Apps form.

I have a main SharePoint list ("ABCD") with 10 text question columns and 3 lookup columns (Department, Country, R-Level). These lookups pull from a separate SharePoint list called "Approvers".

The "Approvers" list structure causes my issue. It contains multiple entries for the same country based on different Department/R-Level combinations (e.g., Department P > Country India > R-Level Red, Department P > Country India > R-Level Amber). This duplication results in redundant values within my Power Apps form's lookup dropdowns for Department, Country, and R-Level.

How can I configure these dropdowns to display only unique values for each field, while still ensuring the selected values correctly update the corresponding columns in my main SharePoint list? This is crucial as a Power Automate flow relies on these fields to route approvals.

Attached are screenshots of the "Approvers" list structure and the duplicate values displayed in the Power Apps form. Any help would be greatly appreciated!