Strategy for implementing a menu-style list that captures and saves user selections.
I'd like to create a PowerBI or PowerQuery interface that outputs a list created by a query and then allows users to select a subset of items, which are saved to new table -- or somewhere where they won't be overwritten. See simplified example below.
Would anyone have suggestions for the best way to do this? I'd prefer to use PowerBI because I could add search filters.
In Excel I can imagine these steps ...
Query #1 generates a list and loads to Column B
Place a User-Selection table in Column A that's dimensioned to match the number of rows in the query output where users can check a box indicate that an item is selected.
Place a formula in Column C that references the query output in Column B if Column A is selected.
Query #2 captures the content of Column B and filters out blank rows.