Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

How can we filter PowerBIIntegration data from a sharepoint list?

Hi community,


I was able to filter the powerBIIntegration populated data with a local microsoft excel table using this link for an html text input box.  I have to connect it to a sharepoint list instead of the excel table.  I am getting the error (attached screenshot).  Please suggest how to fix this issue.

Community Support
Community Support



You can refer to the documentation below:


This formula joins Power BI data with the Customer data. You can try something similar for Sharepoint.

source: LookUp(Customer,Customer_x0020_Name=First(PowerBIIntegration.Data).Customer_Name)




I not able to make this work.  Can you suggest the required change in the html text please?

"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
"<tr style='background-color:#efefef' >
<td> Course Name </td>
" &
Filter(Table5, Name in [@PowerBIIntegration].Data.Full_Name),
"<tr><td>" & FullNameOfCourse & " </td></tr>") &"



Here, table5 is imported from a local excel file.  I want this to be a sharepoint list. 

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,516)