News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Lookup returns blank b...

Power Apps - Building Power Apps

Answered

Lookup returns blank but Isblank returns false

(1) Share

Report

Report

Posted on by Mmaayy999

19

Hello,

I want to use lookup to check if one item exist in my list,

When I use：

LookUp('List','Number'=Gallery1.Selected.Number,'Title'), it shows Blank.

However when I add "IsBlank" or "=Blank()", it shows false...

Anybody knows why?

All responses Img

All responses (3)

Answers Img

Answers (1)

WarrenBelz 146,702 Most Valuable Professional on at

Like (1)

Report

Re: Lookup returns blank but Isblank returns false

Hi @Mmaayy999 ,

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.
Mmaayy999 19 on at

Like (1)

Report

Re: Lookup returns blank but Isblank returns false

Wow it returns true, thank you I think I can use it! do you know what's the problem on using Isblank()?
Verified answer

WarrenBelz 146,702 Most Valuable Professional on at

Like (1)

Report
Re: Lookup returns blank but Isblank returns false

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