cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tomislav1975
Level: Powered On

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
tomislav1975
Level: Powered On

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

This is what solved my problems Smiley Happy.

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

1 REPLY 1
tomislav1975
Level: Powered On

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

This is what solved my problems Smiley Happy.

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

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 198 members 4,587 guests
Please welcome our newest community members: