Unanswered

How to extract one column of data from a collection, to be used in a dropdown.

(0) Share

Report

Posted on by bennkingy

Hey, thanks for checking out my question. This is the first power app that I built, but I have realized I could improve it if I knew how to manipulate the collections a little better. Hence I am asking the question below:

I have a collection called "filteredSKUsCol" which is shown in the image above.

I would like to know how to extract the column of data called "XYZ_Calibre" which are all numbers.

The data/numbers are going to be used on the items property of a dropdown.

Thanks for the help! 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Vijay Tailor 2,961 on at

Like (2)

Report
Hi @bennkingy ,

You can use like below -
Sort(Distinct(filteredSKUsCol,XYZ_Calibre).Result,Ascending)

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Try

filteredSKUsCol.XYZ_Calibre

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No