Unanswered

Notify function with LookUp

(0) Share

Report

Posted on by aaaaaaaDDD

Hello,

I want to Notify user if Lookup does not find a matching value in the Dataverse. So far I have managed to write below code on OnChange event of a txtSearch but I am not sure what is wrong. DelayOutput is set to true

If(
 !IsBlank(""),
 With(
 {
 wRecord: LookUp(
 'Owners',
 'Owner Email' = txtSearch.Value
 )
 }, 
 If(
 IsBlank(wRecord.'Managers-Email'),
 Notify(
 "No matching email found in the tool.",
 NotificationType.Error
 );
 Reset(txtSearch)
 )
 )
)

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Rahman1005 109 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
can you please refer article examples are covered, hope is will helpfull.
https://www.inogic.com/blog/2018/12/notify-functions-in-canvas-power-app/

Thanks,
aaaaaaaDDD 34 on at

Like
a
(0)

Report
Copy link

Link copied!

How is this even related to my question?
aaaaaaaDDD 34 on at

Like
a
(0)

Report
Copy link

Link copied!
Ah, I fixed by removing "!" on line 2
IsBlank(""),
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

At present this code is not running at all due to your first condition within the If statement, as it will always evaluate to false:

You should be able to change this to refer to the length of the search text so that it only does the lookup when the search text input has a value in it:

If( Len(txtSearch.Text)>0, With( { wRecord: LookUp( 'Owners', 'Owner Email' = txtSearch.Text ) }, If( IsBlank(wRecord.'Managers-Email'), Notify( "No matching email found in the tool.", NotificationType.Error ); Reset(txtSearch) ) ) )

Also it looks like you are referring to txtSearch.Value but I think this should actually be txtSearch.Text if it's an actual text input control.

Try modifying the above code to meet your needs,

Cheers,

Sancho
aaaaaaaDDD 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Yes, I realized mistake in the formula. I am using PowerApps for Teams and hence I think textbox does not have "Text" property.
I was expecting the "OnChange" event to be fired when the focus is moved out of the text input however it is getting fired every time a text is added in the textbox. Any thoughts?