In Power BI I have a table that users can select and use a button to drill-through and pass all of the selected items. I need to pass these rows to Power Apps so that users can view the data, write a single comments that would apply to all of the items, and submit all of the data to a Sharepoint list, creating a row for each of the selected items and saving the same comment for each row.

On the drill through Power BI page I have a table to check that only the selected rows appear, and in the Power App a text field that checks that there are the same rows of data passed through:

The code for that Power Apps text box is: "Number of Items from Power BI: " & CountRows(PowerBIIntegration.Data)

How can I create a gallery or table to display this data? Since it's from a Power BI Integration I don't see it as a typical data source for those visuals.

In Power BI I have a table that users can select and use a button to drill-through and pass all of the selected items. I need to pass these rows to Power Apps so that users can view the data, write a single comments that would apply to all of the items, and submit all of the data to a Sharepoint list, creating a row for each of the selected items and saving the same comment for each row.

On the drill through Power BI page I have a table to check that only the selected rows appear, and in the Power App a text field that checks that there are the same rows of data passed through:

The code for that Power Apps text box is: "Number of Items from Power BI: " & CountRows(PowerBIIntegration.Data)

How can I create a gallery or table to display this data? Since it's from a Power BI Integration I don't see it as a typical data source for those visuals.

• powerbi
• powerapps
• powerapps-formula

1 Answer 1

Under the Gallery Data Source, select Power BI as the source:

Then, in the Gallery, add a text box for the information for each item you want to display. For example to display the Material for each item that is pulled in from Power BI, Text = ThisItem.Material