Forum Discussion
Solved
Do I have to ""Load to.. Table" to populate dropdown?
Hello, As shown in the screenshot below, I am populating my dropdown (ie data validation list applied to cell E5) from a table (Table_PPeriodQueryResults) which was a result of my query PPeriod_Q...
Yes, I mean green table.
You can't create data validation list from power query connection or data model table, power query shall return the table into the Excel sheet to use it for data validation. Another story you may place it into separate sheet and hide this sheet.
Yes, I mean green table.
You can't create data validation list from power query connection or data model table, power query shall return the table into the Excel sheet to use it for data validation. Another story you may place it into separate sheet and hide this sheet.
SergeiBaklan got it! Thank you. 🙂
Michelle99 , you are welcome