Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors