Notifications
Announcements
I need to hide items in gallery which has a field filled in the SP list How can I do that
@aswin12345 ,
Make the Visible property of the Label false - is this what you are asking?
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Do you mean you want to hide if the field is not blank?
If that is so, on the Visible of the Field put; ! IsBlank (ThisItem.column)
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
I think you should try using the Filter formula to filter the items that have the required field filled.
You can use the formula below if the field that you are trying to check is a string.
Filter(<SharePointList>, !IsBlank(FieldName))
Hi @Anonymous I would like to have the reverse of this formula I want the item to be hidden if there is any text in the list
The reverse of the formula would be this:
Filter(<SharePointList>, IsBlank(FieldName))
This will filter out (hide) whenever the FieldName has text in it, and only keep (show) the items where FieldName is empty.
@WarrenBelz Hi Warren, the situation is i want to hide items in gallery if there is text value in a column called 'end_time'
Hi @aswin12345 ,
You need to use the control (text box or label) - the Visible of the Gallery needs to be
IsBlank(YourEndTimeTextBoxName.Text)
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Hi @WarrenBelz I am afraid thats not the solution as I am getting error that "The function 'IsBlank' has some invalid arguments".
I assume you replaced YourEndTimeTextBoxName with your actual control name?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 739 Most Valuable Professional
Michael E. Gernaey 343 Super User 2025 Season 2
Power Platform 1919 268