cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kevinsray
Level: Powered On

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.

1 REPLY 1
Super User
Super User

Re: Create Dropdown from specific data in collection

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

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,484)