Map/Selecting Bubbles, Updating SharePoint from Button

[fancylad-1138]

Hi,

I would like to select and multi-select bubbles and from there, update a SharePoint list.  I believe I have created a button within Power BI, created a flow.  I just do not know how to code the selection of the bubbles.  Appreciate any direction to start my learning process and eventual solution.

Thanks in advance.

[Shai_Karmani]

The pattern you want is the Power Automate visual (Insert > More visuals > From AppSource if it is not already in your default list). Drop it on the report and add the fields that identify each bubble to its Data well, so when users select bubbles on the map the visual receives the filtered selection through cross filter.

Then edit the visual, choose Power Automate template, and build a flow with the "Power BI button clicked" trigger. The "Power BI data" output is an array of the selected rows that you can pass into an Apply to each loop calling Create item or Update item on your SharePoint list.

The native Button visual cannot pass the current selection to a flow, only the Power Automate visual can.

If this helped, a thumbs up and accepting the solution would be appreciated.

Best,
Shai Karmani

Let's connect in LinkedIn

[fancylad-1138]

Am I using "Filter Array"?

[fancylad-1138]

Sounds good.  I have a field I called "full address" which includes address, city, state and added it in to the cross-filter.  Do I need do add anything on the main "add data fields here" on top (e.g. full address) or just the cross-filter?