I have a collection with 10 columns. I would like to somehow cycle that collection and get the column names to put into another collection for a drop down list. Is this possible? Any ideas?
Solved! Go to Solution.
I don't think it is possible to get the names of columns of a table. Since it is only 10 items, I recommend creating a datasource with the names of those columns as records. Using a connected datasource will allow you to update it as needed.
Otherwise, if you don't expect any changes to the column names, then use the Table() function in the Items property of your Dropdown menu.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand