web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Modern dropdown distin...

Power Apps

Answered

Modern dropdown distinct functionality issue in powerapps

(0) Share

Report

Report

Posted on by EvanAffleck

14

Hi,

I have used a MODERN edit form and I have a City column in my SharePoint which have duplicates values that I pull into my form, initially the City is a text field, and I wanted a dropdown, so I imported a modern dropdown in City DataCard. The formula I used to display values is

SharepointList.City
and this displays the values in my column but also the duplicates so i tried using the distinct functionality but that didnt work, then i used Choices

Choices([@'SharepointList.'City')

this doesnt throw the error but the values displayed are empty, i made sure that the field value has city column, still doesnt work

So can you please help me with this? Let me know if you need more inputs

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
HI @EvanAffleck,

Your City column is a single-line-of-text type, the Choices() function does not apply to a non-Choice column.

For a modern dropdown control, to display diplicated cities, you need to set the Items property as:

Distinct(SharepointList,City)

A tip for your reference, modern controls are unstable, if it is not necessary for your scenario, I strongly suggest use the Classic instead.

Was this reply helpful? Yes No

Join the conversation