Lookup Dropdown Duplicates: Solution Required for Power Apps Form

(2) Share

Report

Posted on by CU01101712-0

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!

Categories:

Building Power Apps

image.png

image (1).png

Lookup SL.png

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,392 Super User 2025 Season 2 on at

Like (1)

Report

Hi

You need to use the Distinct Function

for instance Distinct(MyList, Country)

Where Country is the Field/Column Name so change it as you need it.

Understand though, that you could also union the list to itself, which would remove the duplicates.

One thing to note, when you do this, then your Dropdowns do NOT point to a record, they point to the "string" you are doing the Distinct on, unless its a LooKup etc, in which case thats different.

Was this reply helpful? Yes No
CU01101712-0 9 on at

Like (0)

Report

Hello @FL Mike,

This code works perflectly fine(Screenshot below), How can i add distinct to this code? I've tried all AI Chatbots and none have given me the correct way to make this work with disctinct.

Was this reply helpful? Yes No