Please, help with a Lookup formula

[Galina73]

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?

[eka24]

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.

[Drrickryp]

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).  

[v-qiaqi-msft · Accepted solution]

 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)​

Any screenshots about your scenario will be appreciated.

Best Regards,

Qi

[Drrickryp]

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

[v-qiaqi-msft]

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