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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 326 Most Valuable Professional
11manish 168
sannavajjala87 75 Super User 2026 Season 1
