---
title: "Discussion on \"Get distinct values from a column and add them to a dropdown.\" | Hashnode"
description: "Discussion on \"Get distinct values from a column and add them to a dropdown.\". When any SharePoint list column is assigned to a Drop down it shows all item in it, unique and duplicates. this is really annoying in situations where we use the dropdown to filter a gallery.\nIdeally the drop down as the drop down supposed to show on..."
url: "https://hashnode.com/posts/get-distinct-values-from-a-column-and-add-them-to-a-dropdown/65a3e298aadaa04b44649049"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Get distinct values from a column and add them to a dropdown.](https://appylittle.hashnode.dev/get-distinct-values-from-a-column-and-add-them-to-a-dropdown?utm_source=hashnode&utm_medium=feed)

When any SharePoint list column is assigned to a Drop down it shows all item in it, unique and duplicates. this is really annoying in situations where we use the dropdown to filter a gallery. Ideally the drop down as the drop down supposed to show on...

Jan 14, 2024 · 2 min read · appylittle.hashnode.dev  
Updated Jan 16, 2024  
Read the article

-   [#powerapps](https://hashnode.com/tag/powerapps)

## Written by

[Viraj Rathnayaka](https://hashnode.com/@VirajR)

@VirajR · Sri Lanka

  
[View profile](https://hashnode.com/@VirajR)

Data Analyst

Self-taught Data Analyst specializing in Power BI

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
