cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmccully
Helper I
Helper I

Power Automate button in Power BI does not send data

Hello

 

I have a Power Automate button in Power BI that triggers a flow to add an item to a SharePoint list. This works but I am not able to pass a field through the button to SharePoint.

 

The field is the result of a measure and has a single value as shown below:

 

cmccully_0-1634148731233.png

 

When I try to add this value to the SharePoint list in Power Automate I do not see a way to add it.

I see the column I want it added to in the SharePoint list and I see the automated fields like User Name and User Email but not my field I am passing through.

cmccully_1-1634148883686.png

 

 

1 ACCEPTED SOLUTION
cmccully
Helper I
Helper I

After poking around a bit more and reviewing the connection between the button and my flow

cmccully_0-1634150648607.png

 

I was able to get to another view that showed more data options:

cmccully_1-1634150702588.png

When hovering over the selected variable I could see it was the field I passed in from Power BI. I was able to select it and add it to the SharePoint list.

After saving the flow and then going back in I could see another step added as shown below

cmccully_2-1634150936843.png

Marking as answered!

View solution in original post

2 REPLIES 2
HarrievandeSun
Frequent Visitor

Hi,

 

I got this problem as well after I turned on Concurrency Control in Power Automate.

Since it is not able to turn off concurrency control again, I built a new flow and applied it to the button and everything worked again.

cmccully
Helper I
Helper I

After poking around a bit more and reviewing the connection between the button and my flow

cmccully_0-1634150648607.png

 

I was able to get to another view that showed more data options:

cmccully_1-1634150702588.png

When hovering over the selected variable I could see it was the field I passed in from Power BI. I was able to select it and add it to the SharePoint list.

After saving the flow and then going back in I could see another step added as shown below

cmccully_2-1634150936843.png

Marking as answered!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!