cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Display items from SourceData, filtered by Selection in Power BI

Hi,

I have powerapp visual in Power BI report. As refresh of PBI report is late, I would like to see actual state of data through PowerApp in PBI report. Problem is that I do not know how to set formula in BrowseScreen->BrowseGallery1 to display items from Source filtered by PowerBIIntegration.Data? I tried with Filter(Source1,PowerBIIntegration.Data.ID=ID) but with no successes. Thanks in advance for any help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Display items from SourceData, filtered by Selection in Power BI

This is what solved my problems :).

Search(AddColumns(PowerBIIntegration.Data, "STATUS_FROM_SOURCE", LookUp(Source1, ID = First(PowerBIIntegration.Data).ID, STATUS)),TextSearchBox1.Text,"ID")

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Display items from SourceData, filtered by Selection in Power BI

This is what solved my problems :).

Search(AddColumns(PowerBIIntegration.Data, "STATUS_FROM_SOURCE", LookUp(Source1, ID = First(PowerBIIntegration.Data).ID, STATUS)),TextSearchBox1.Text,"ID")

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

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 (10,296)