Announcements
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
