Forum Discussion
Map/Selecting Bubbles, Updating SharePoint from Button
- 1 month ago
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 ,
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.