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
New Member

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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.