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

1 REPLY 1
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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors