Forum Discussion
meagain
5 years agoNew Member
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 ...
MFelix
Super User
5 years agoHi meagain ,
Using the Power BI you may try and use the Power Automate visualization, that allows to create custom automations based on Power BI data.
Using this you can create/update a file or a list in sharepoint that saves returns the Query2 data.
Another option on Excel is using VBA.
meagain
5 years agoNew Member
Miguel, thanks for the tip about Power Automate. I'll check it out.