Unanswered

How to display the data if I select two checkboxes at one time?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I am new to Power Apps. Please help me with a solution to my problem.
I have two Sharepoint lists : EmpDetails (Employee Form) and TechForm (Department Form).
I have 4 columns in EmpDetails list. The fourth column (Department) is a look up column which is connected to the other list TechForm. In TechForm lilst, I have one column only with 4 rows.

I have 3 galleries :
1. For selecting the Department (HR/Admin/etc)
2. For displaying the names associated with the Department and also selecting it.
3. If we select the checkbox in Gallery 2, the details are displayed in Gallery 3.

When I select HR, then a new checkbox appears associated with it (Atul), as circled in the image above.
What I want is that when I select on two checkboxes, like HR and Admin, it should display the checkboxes associated with it(both HR and Admin). Is it possible? If possible then how to do it? please help.
Here is the tree view of my Department Form :

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Set the Items property of the Gallery 2 to
Filter(EmpDetails, Department in (Filter(Gallery1.AllItems, CheckboxName.Value).Department)

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

Thank you for the reply, but I am facing some errors. I have attached the screenshot below.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you verify the field names bound to the control based on your data source? For example, looks like the Checkbox3 name is not valid.

Please share the column names if need help.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

I have 3 galleries. Gallery1 is at the top of the screen, Gallery3 is at the middle of the screen and Gallery2 is at the bottom of the screen. (sorry for the gallery number order)
Gallery1 has a checkbox (checkbox2). Datasource is Techform (Department Form itself).
Gallery3 has a checkbox (checkbox3). Datasource is EmpDetails (Employee Form).
Gallery2 has 2 labels (TechLabel and EmpLabel). Datasource is EmpDetails (Employee Form).
WorkFlow :
So, when I select a checkbox (checkbox2) in Gallery1 (like HR/Admin/etc), another checkbox (checkbox3) appears in Gallery3 (Employee Name attached to it). And when I select the checkbox (checkbox3) attached with the name in Gallery3, EmpLabel and TechLabel appears, displaying the Employee ID and Technology associated with the name or checkbox (checkbox3) in Gallery2.
I want to select multiple number of checkboxes in Gallery1 and the checkboxes or data associated with it should display in Gallery3.

Here are column names of the two lists.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Set the child gallery items property to
Filter(EmpDetails, Department.Value in (Filter(Gallery1.AllItems, Checkbox1.Value).Name))

Reference

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No