web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Table based on ...

Power Apps

Unanswered

Filter Table based on another Table

(0) Share

Report

Report

Posted on by JatinSaini

428

I have two tables, Table 1 & Table 2.

Table 1 consists of one multiselect choices column.

Multi Choices are - A, B, C, D

Table 2 consists of an ID column.

Each record has ID same as - A, B, C, D

I want to display(visible) on those ID from Table 2 in a gallery for which were same as selected from the multi-choice column in table 1.

PLEASE HELP

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Silvester. Akakpo 783 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @JatinSaini ,
I get a general idea about what you are trying to do, however am having a hard time getting what you are trying to do. Can you explain better please?
JatinSaini 428 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Silvester
Thanks for the response.
This might be different as I described but let me explain the scenario:
Left Side-
It's my gallery which display records from a sharepoint table in form of cards.
The Source Filed consist of Icons (Phone,Email,Chat,Support,Print)

Right SIde-
It's my Form Control which at top has another checkbox whithin a gallery.
The Checkboxes are same like - Phone, Email, Chat....

I want to visible only those icons on my left gallery which are checked on the right side form control for that specific record.

I hope this explains the scenario in better way.
PLEASE HELP
Silvester. Akakpo 783 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JatinSaini ,
I think I understand now. So quick question, How do you store the source in your SP list? Are they stored as boolean? (ie: Phone: Yes -Email: No... kind of?). If it is, then try this
On the left gallery, you will need to work with the icons visibility.
Let's assume we are working with the phone icon. On its visible property we do:

ThisItem.Phone="Yes"

If the condition is met, the icon will be visible, if not it wouldn't. You may need to do it for all the icons.

Join the conversation