86
Hi
I have a dropdown in a canvas app. It must give me the distinct values from a SharePoint list where a the values are in a Lookup column.
The lookup in that column has 20 choices. But in this list only 3 or 4 are used.
In my dropdown I see that the user has 20 choices. I want them only have access to the distinct values that are in the list and not all possible values.
I used this code……
Choices([@Planning_1].Product)
Who can help me?
Regards
Steven
Try this:
Distinct(Choices([@Planning_1].Product), Value)
You can also review this previously solved similar question:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Distinct-Choices/m-p/694962#M222424
Share
Report
All responses (
Answers (
