cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Please, help with a Lookup formula

Hello, 

 

I have a lookup formula, which is working. Please, advise, how to put wording "Is not found", when lookup formula does not find anything?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

 Hi@Galina73,

Based on the issue that you mentioned, do you want to display the word "Is not found" when LookUp formula return blank?

Could you please share more about your scenario, where do you want to lookup, a gallery?

If you want to show this message in the gallery, I think If() and IsBlank() can achieve your needs.

  • Set the Text property of the Label within the gallery as below

 

If(IsBlank(LookUp(Opportunities,Title="Peking")),"Is not found",ThisItem.Title)​

 

0001.png

Any screenshots about your scenario will be appreciated.

Best Regards,

Qi

View solution in original post

5 REPLIES 5
Super User III
Super User III

Kindly show the formula you are using to enable add that feature

------------

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.

Super User II
Super User II

Hi @Galina73 

You can place a Label control on the screen with a Text property "Is Not Found"  and set the visible property of the label to IsBlank(Yourlookupformula here).  

Community Support
Community Support

 Hi@Galina73,

Based on the issue that you mentioned, do you want to display the word "Is not found" when LookUp formula return blank?

Could you please share more about your scenario, where do you want to lookup, a gallery?

If you want to show this message in the gallery, I think If() and IsBlank() can achieve your needs.

  • Set the Text property of the Label within the gallery as below

 

If(IsBlank(LookUp(Opportunities,Title="Peking")),"Is not found",ThisItem.Title)​

 

0001.png

Any screenshots about your scenario will be appreciated.

Best Regards,

Qi

View solution in original post

If() is redundant since IsBlank() reduces to true or false.

Community Support
Community Support

Hi@ Galina73,

Have you solved your issue?

If it solves your request, Mark it as a Solution to enable other users to find it.

Best Regards,

Qi

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (78,564)