web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Hide gallery item base...
Power Apps
Answered

Hide gallery item based on selected value

(0) ShareShare
ReportReport
Posted on by Lacoste 93

Hi Community,

can you help me on which code i can use in powerapps,

in fact i have two screens and each screen has a gallery, each person has a certain tasks associated, so for example: if David has maximum 3 tasks and if you checked them via checkbox in screen 2 and click on save button, then on screen 1 David will be hidden in the gallery in screen 1 but if you checked only like 2 tasks (not the maximum i.e. as long it still one left task for him) then in screen 1 David will still appearing i.e. David will not be hidden. 

i.e. David in gallery in screen 1 will be hidden only when all his tasks have been checked.

Thank you guys.

 

SCREEN 1.jpg

 

SCREEN 2.jpg

Categories:
Building Power Apps
  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @Lacoste ,

     

    I'd suggest to add a column to your data source and link that to the checkbox, let's say it changes the value of the column when clicking the checkbox. You can then use that column to filter out any checked items in the gallery on screen 1.

  • Lacoste Profile Picture
    Lacoste 93 on at

    Hi @BCBuizer ,

    I have a column in my data source in sharepoint when you checked any corresponding checkbox it save the value as YES and if you did not checked the box it mark it a blank.

    on screen 1 is just a gallery with only a list of people with their names and screen 2 it s all about tasks and one person can be assigned 3 or 4 tasks (like David has 3 tasks: task 1, task 2 and task 3), so i want if checked all his tasks and save to sharepoint list , then in my screen 1, the name David will be hidden but if not checked all his tasks then name David in screen 1 will still appearing,

    i do not know how i can write a such code?

    Thanks.

  • Verified answer
    BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @Lacoste ,

     

    If you filter your gallery on screen 1 for Blank() values in that specific column, it will only show those. If David's tasks are all assigned, there will be none left to show, hence his name will not show:

     

    Filter(YourDataSource, IsBlank(YourColumn))
  • Lacoste Profile Picture
    Lacoste 93 on at

    Hi @BCBuizer

    Thanks, in fact your code works well but i want if on screen 2 for example if david has 3 tasks only and you checked only 1 task or two tasks then his name will not be hidden in screen 1, but if all his tasks have been checked then his name in screen 1 will be hidden or just disappear.

    In general i mean if all tasks associated to a person have not been checked then his name should still visible in screen 1.

     

    Thanks. 

     

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @Lacoste ,

     

    That part should be taken care of by updating the data source whenever an item is (un)checked in screen 2. Any changes in screen 2 should then reflect in screen 1 automatically.

     

     

  • Lacoste Profile Picture
    Lacoste 93 on at

    Hi @BCBuizer 

    Thanks a lot, the code works well, i have a last issue, actually as the code should be written in Items property for Gallery in screen 1, but in Items property for Gallery in screen 1, i have already another function filter:

     

    Filter(datasource for screen 1; StartsWith(column1;TextInput1.Text);column2=TextInput2.Text)

    and the other code is the below one,

    Filter(datasource for screen 2; IsBlank(column for Tasks))

     

    so how can i combine or write all those two filter in one Items property Gallery in screen 1?

     

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @Lacoste ,

     

    To merge the both conditions within the filter statement, you can just type a ";" and add the new condition. This will be treated as a logical And:

     

    Filter(datasource for screen 1; StartsWith(column1;TextInput1.Text);column2=TextInput2.Text; IsBlank(YourColumn))

     

  • Lacoste Profile Picture
    Lacoste 93 on at

    Hi @BCBuizer ,

    Thanks again for your feedback, i´m getting an error because i have two different datasource i.e. in screen1 i have datasource1 and in screen2 i have another datasource2, so that´s why the column of tasks is not recognized in screen1.

    Filter(datasource1 for screen 1; StartsWith(column1;TextInput1.Text);column2=TextInput2.Text)

    and the other code is the below one,

    Filter(datasource2 for screen 2; IsBlank(column for Tasks))

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Hi @Lacoste ,

     

    Got it. Try:

     

    Filter(
 //Adds a column to 'datasource for screen 1' that holds a boolean that indicates if there are unchecked tasks in the 'datasource2 for screen 2'. true for open tasks
	AddColumns(
 'datasource for screen 1';
 "_OpenTasks";
 !IsBlank(
			LookUp(
				'datasource2 for screen 2'; 
				NameColumn = 'datasource for screen 1'[@NameColumn] And IsBlank('column for Tasks')
			)
		)
	);
 StartsWith(column1;TextInput1.Text);
 column2=TextInput2.Text;
	//Filtering for the _OpenTasks column. Since this is a boolean, no additional code is required for this condition
 _OpenTasks
)

     

     

  • Lacoste Profile Picture
    Lacoste 93 on at

    Hi @BCBuizer ;

    Thanks a lot, can you let me know those columns cause i saw you mentioned more than one new column

    _OpenTasks column : which i have to create in datasource1 (this is a new column i have to create in datasource1? apart from the tasks column i have already in datasource2)

     NameColumn : which column is that?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans