Forum Discussion
Map/Selecting Bubbles, Updating SharePoint from Button
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.
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.
6 Replies
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 KarmaniSounds 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?
Am I using "Filter Array"?
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.Hi fancylad-1138 ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
Hi fancylad-1138,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
