Answered

Filter Gallery by dropdown value cross multiple entities

(0) Share

Report

Posted on by Pontus Leppaniemi S...

Hi,

I'm building my first PowerApp to automate the invitation process to our portal, and i want to achieve the following:

Based on the account (entity 1) selected in a dropdown, the gallery should then filter out all contacts (entity 2) that has a value in a specific field (entity 3).

So basically, when the account is selected, the code should filter on all contacts within that company that has a record in the Web Role section of the customer card.
Note: Web Role is not a normal field in Customer Engagement. It's more like a table.

Hope someone has an idea and thanks in advance
//Pontus

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Florian_Kleinz 227 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

it is hard to help with having this Little Information about your data structure.

But for my understanding FILTER and COUNTROWS should do the Job.

FILTER(employees, account = Dropdown.Selected) or maybe Dropdown.Selected.Text
This delivers a table filtered by your Dropdown value.
If you want to have the number of rows for this table just wrap it with Countrows
COUNTROWS(FILTER(employees, account = Dropdown.Selected) )

Best regards
Florian
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @pontusspringer ,

Do you mean you want to filter the Contact entity by selected account and assigned WebRole, right?

I have tried, but can't find a clear way to apply a logic in filter function to check if web role is assigned to contact.

What I can achieve is to create a ReferenceGallery, filtered by selected account.

ReferenceGallery.Items: Filter(Contacts,'Company Name'=Dropdown1.Selected)

Inside the Reference Gallery, there is a Label to display the assigned WebRole by setting Text property to

Concat(ThisItem.'Web Roles',Name)

Then Set the Items of your target gallery as follows to filter on ReferenceGallery by checking wether the Label is blank.

Filter(ReferenceGallery.AllItems,!IsBlank(Label1.Text))

Then the target gallery will show as you expected. in addition, try to set the Visible of ReferenceGallery to false to hide it.

Hope this helps.

Sik
Pontus Leppaniemi S... 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much, it did the trick!