Forum Discussion
Map/Selecting Bubbles, Updating SharePoint from Button
Hi fancylad-1138 ,
Thanks for reaching out to Microsoft Fabric Community.Yes, you'll need to add Full Address (and any other fields you want to use in your SharePoint update) to the Power Automate visual's Add data fields here well. The cross-filter from your map determines which rows are passed to the Power Automate visual, while the fields you add to the visual determine which column values are available in the Power BI data output.
Regarding Filter array, it isn't required for this scenario. The Power BI button clicked trigger already passes only the rows that are currently selected, so you can iterate over the Power BI data using an Apply to each and then use Update item or Create item for your SharePoint list. A Filter array action is only needed if you want to apply additional conditions within the flow before updating SharePoint.
If you don't see the individual columns available as dynamic content, you may need to add a Parse JSON action using the Power BI data output before the Apply to each. This allows the fields to be exposed as dynamic content in the subsequent actions.
You can also refer to the following resources:
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn
Solved: Write Back data from PowerBI to SharePoint - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
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
Am I using "Filter Array"?