PowerApps Gallery with Power BI Table visuals

Like (0) Share

Report

Posted on 21 Oct 2020 14:53:08 by oappdev

901

Happy Wednesday, Power Apps Community 👍

Wanted to see, if it's possible to just show whatever row is selected from the Power BI table visuals to show up on the PowerApps gallery to the right. Right now is showing all items.

Please, let me know if I explain myself clearly.

Thank you in advance,

Categories:

Connecting to Data

General Questions

All responses (3)

Answers (1)

v-yutliu-msft on 27 Oct 2020 at 09:14:40

Like (1)

Report
Re: PowerApps Gallery with Power BI Table visuals

Hi @oappdev ,

Do you want to display blank gallery if you do not choose any item in the powerbi visual?

The reason why you met that problem is that PowerBIIntegration.Data represents the first three items by default.

So to avoid this problem, I suggest you add a justification.

Try to set the gallery's Items like this:

If(!IsBlank(First(PowerBIIntegration.Data).Title),PowerBIIntegration.Data)

Best regards,
oappdev 901 on 23 Oct 2020 at 15:44:11

Like (0)

Report

Re: PowerApps Gallery with Power BI Table visuals

Thank you @v-yutliu-msft so much! Is was I needed.

Last question,
Just wanted to know if it's possible to show "0" item in gallery into user selected row from the visual table on the left?
Verified answer

v-yutliu-msft on 23 Oct 2020 at 03:10:35

Like (1)

Report
Re: PowerApps Gallery with Power BI Table visuals

Hi @oappdev ,

Do you want to filter powerapps visual based on selected row in your powerbi table?

If so, please notice that:
"PowerBIIntegration.Data" represent the selected row in your powerbi table.

So you could use this to filter items in your powerapps visual.

Could you tell me:
whether do you want to only display the selected row in your powerapps gallery or display related rows based on the selected row in your powerapps gallery?

1)only display the selected row in your powerapps gallery

set the gallery's Items:

PowerBIIntegration.Data

2)display related rows based on the selected row in your powerapps gallery

//I filter based on Title field (Title is equal to the Title value in the selected row)

set the gallery's Items:

Filter(fruit11111,Title = First(PowerBIIntegration.Data).Title) //fruit11111 is my sharepoint list name, please replace to your table name

Results:

What's more, this link may help you a lot:
Solved: Filtering the PowerApps Visual using Power BI Slic... - Microsoft Power BI Community

Best regards,