Announcements
Hello,
I want to use lookup to check if one item exist in my list,
When I use：
However when I add "IsBlank" or "=Blank()", it shows false...
Anybody knows why?
Hi @Mmaayy999 ,
What do you get when you use
With( { _Data: LookUp( 'List', 'Number' = Gallery1.Selected.Number ).Title }, Len(_Data) = 0 )
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.
MVP (Business Applications) Visit my blog Practical Power Apps
Wow it returns true, thank you I think I can use it! do you know what's the problem on using Isblank()?
Not precisely, although you may have an empty string "" in the field, which is not blank. I always use Len() as it covers both empty and blank. I also tend to use the lookup structure I posted (I know the views on data retrieval), but it always works.
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 610
Haque 317
WarrenBelz 315 Most Valuable Professional
