cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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
Highlighted
Microsoft
Microsoft

Re: How can we filter PowerBIIntegration data from a sharepoint list?

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)

 

 

 

Highlighted
Helper II
Helper II

Re: How can we filter PowerBIIntegration data from a sharepoint list?

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,601)