Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Create Dropdown from specific data in collection

I have been trying to figure out how to create a dropdown from data in a collection. In specific, a dropdown with only shows the values that are not equal to "OK". I have also tried to pull from the last record in SQL, but no luck. The collection I am working with looks like this: Battery Tyres Lights OK Flat Broken I would like the dropdown to return "Flat" and "Broken". If anyone has some advice on how I could do this, it would save my remaining hair.

Super User III
Super User III

Hi @kevinsray

Can you clarify the structure of your collection?
In terms of this- "Battery Tyres Lights OK Flat Broken"
.. what are the column headers, and what are the row level items?

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,314)