Solved: Power Automate - Power Bi Date to a SharePoint lis...

hchqawa · ‎05-25-2022

Can anyone advise if this is possible.

I have a report in Power Bi and I want to some of the values to be sent to a sharepoint list. I have successfully achieved this but the data that is going to the sharepoint site is the overall figures. I want to be able to filter the data for a period of time and send that data to the sharepoint list but it always wants to send the total figure unfiltered.

If it is possible, any advise on how to do it please?

Many thanks

Andrew

jennratten · ‎05-26-2022

Great - then in the visual pane (in Power BI) for the Power Automate visual, add the fields for which you'd like the data to be filtered. After doing so, you can go to Power Automate and edit the flow and you will now see those fields as dynamic tokens that you can use in your flow. Here is a good overview.

https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-automate-visual-for-power-bi-repor...

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

View solution in original post

hchqawa · ‎05-26-2022

Yes I am using Power Automate visual

jennratten · ‎05-26-2022

Great - then in the visual pane (in Power BI) for the Power Automate visual, add the fields for which you'd like the data to be filtered. After doing so, you can go to Power Automate and edit the flow and you will now see those fields as dynamic tokens that you can use in your flow. Here is a good overview.

https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-automate-visual-for-power-bi-repor...

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

hchqawa · ‎05-26-2022

Hi,

I am sending the data via power automate from Power Bi to a Sharepoint list.

Many thanks

Andrew

jennratten · ‎05-26-2022

Are you using a Power Automate visual in Power BI to do so?

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

jennratten · ‎05-26-2022

How are you sending the data from Power BI to Sharepoint? Are you using Power Automate?

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User