cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ogh_sabyasachi
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.

2 REPLIES 2
rohsh354
Community Support
Community Support

Hello,

 

You can refer to the documentation below:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

 

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>
</tr>
" &
Concat(
Filter(Table5, Name in [@PowerBIIntegration].Data.Full_Name),
"<tr><td>" & FullNameOfCourse & " </td></tr>") &"

</table>"

 

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

Helpful resources

Announcements
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)