Get Popup Alert window to show

(0) Share

Report

Posted on by AH-22100006-0

Hi there,

I am having issues getting a pop up to work the way I want it to.

I have a New Client form - when 'save' is clicked - I want it to check if the first name & last name OR the address already exist. If not, save, if so, display a popup that let's the user know this is a duplicate record.

This is my code: (it works - if the client doesn't exist, the new record is created, and if the client does exist, no record is created - but the notification never pops up)

  If(IsBlank(LookUp('Food Bank Clients', 'Last Name' = txtClientLastName.Text && FirstName = txtClientFirstName.Text || Address = txtAddress.Text , 'Last Name')),
    SubmitForm(frmClientNew), 
    Set(varShowDuplicateRecordPU, true)
    ;
 
Thanks!

Amber

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report
Hi @AH-22100006-0,

Maybe some bracketing needed
If( IsBlank( LookUp( 'Food Bank Clients', ( 'Last Name' = txtClientLastName.Text && FirstName = txtClientFirstName.Text ) || Address = txtAddress.Text ).'Last Name' ), SubmitForm(frmClientNew), Set( varShowDuplicateRecordPU, true ) );

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
Hi @AH-22100006-0

Try this:

If( IsBlank( LookUp('Food Bank Clients', ('Last Name' = txtClientLastName.Text && FirstName = txtClientFirstName.Text) || Address = txtAddress.Text) ), SubmitForm(frmClientNew), Notify("This is a duplicate record.", NotificationType.Error) );

Use the Notify function to notify the user in the app. If this works it means that the varShowDuplicateRecordPU is not in the correct order or effected in someway to not show.

Was this reply helpful? Yes No
AH-22100006-0 93 on at

Like (0)

Report

Hi SpongYe,

That was how I originally had my code - when I couldn't get the notify() function to work, I created a pop up.

It's like that last 'false' portion of the statement never executes.

But a duplicate record is never created...

I'm confused LOL

And WarrenBelz, it doesn't like the bracket before the || I don't think?

Amber

Was this reply helpful? Yes No