Answered

Popup For Duplication

(0) Share

Report

Posted on by NitroPepsi

221

I am trying to create a popup whenever there is a duplicate added to the table. The individual would put their information in the form and submit it, if there is a duplicate detected based on the criteria, I would like a popup letting them know that one has been detected. However, I am getting an error in my formulas. I need help with this please.

Submit Button:

If(IsBlank(LookUp('[incentive_test].[Lkp_Teaching]', Provider=DataCardValue2_1.Text And PROVIDERNUMBER=DataCardValue2_1.Text And Month=DateValue2_1.InputTextPlaceholder And Hours=DataCardValue3_1.Text)),

SubmitForm('MS Data Entry'),

Set(DuplicationPopUp,true))

Ignore And Save Button:

OnSelect:

SubmitForm('MS Data Entry')

UpdateContext({DuplicationPopUp:Blank()})

Visible: LBLDup.Visible

Cancel Button

OnSelect:

UpdateContext({DuplicationPopUp: Blank()})

Visible:

'LBL Save Changes'.Visible

LBL Save Changes

Visible:

!IsBlank(DuplicationPopUp)

Rectangle

Visible:

LBLDup.Visible

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@NitroPepsi

What is the error you are getting and in which formula?

Was this reply helpful? Yes No
NitroPepsi 221 on at

Like
a
(0)

Report
Copy link

Link copied!

The first is on the submit button when they would submit the information.
First Error
It is telling me incompatible types
If(IsBlank(LookUp('[incentive_test].[Lkp_Teaching]', Provider=DataCardValue2_1.Text And PROVIDERNUMBER=DataCardValue2_1.Text And Month=DateValue2_1.InputTextPlaceholder And Hours=DataCardValue3_1.Text)),
SubmitForm('MS Data Entry'),
Set(DuplicationPopUp,true))

Second error
It does not like update Context

SubmitForm('MS Data Entry')
UpdateContext({DuplicationPopUp:Blank()})

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@NitroPepsi
Submit and Update Context you missing comma : and DataCardValue3_1 Value() wrap Hours = Value(DataCardValue3_1.Text) and why are using UpdateContext({DuplicationPopUp:Blank()}) and Set(DuplicationPopUp,true)

Was this reply helpful? Yes No
NitroPepsi 221 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried to write that in but it did not like it
If(IsBlank(LookUp('[incentive_test].[Lkp_Teaching]', Provider=DataCardValue2_1.Text And PROVIDERNUMBER=DataCardValue2_1.Text And Month=DateValue2_1.InputTextPlaceholder And DataCardValue3_1 Value()wrap HoursDataCardValue3_1.Tex))),
SubmitForm('MS Data Entry'),
UpdateContext({DeletePopup});

Now for the "why are using UpdateContext({DuplicationPopUp:Blank()}) and Set(DuplicationPopUp,true)" It is because I am playing around to try to get it to work and I cant 😞

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@NitroPepsi
Will have look your code later as am not near pc to check, maybe will do it different approach

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@NitroPepsi

The formula is not correct!

Should be changed to:

If( LookUp('[incentive_test].[Lkp_Teaching]', Provider=DataCardValue2_1.Text And PROVIDERNUMBER=DataCardValue2_1.Text And Month=DateValue2_1.InputTextPlaceholder And Hours = DataCardValue3_1.Text, true ), UpdateContext({DeletePopup: true}), SubmitForm('MS Data Entry') )

However, in your first Formula you were using Set. In this one you are using UpdateContext...which is it? One is a context variable and the other is a global variable. You should not have two with the same name!

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@NitroPepsi
The code provided by @RandyHayes should work for you, for me normally I use filter to check duplicate to avoid delegation and also show the user the duplicate information found, example like date record created, in you case PROVIDERNUMBER, Month

Was this reply helpful? Yes No
NitroPepsi 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I removed the date and time because it was saying that the text and the inputtextplaceholder were not compatible and I just left the Provider name and provider number in there. It did not give me any more errors once I removed those. However, my popup did not popup. I would make a duplicate with the same provider's name and provider number, and nothing would happen. I switch the And to OR and the same issue, the popup did not come up when I was trying to make a duplicate.

Submit Button
If(
LookUp('[incentive_test].[Lkp_Teaching]',
Provider=DataCardValue2_1.Text And
PROVIDERNUMBER=DataCardValue2_1.Text,
true
),
UpdateContext({DeletePopup: true}),
SubmitForm('MS Data Entry')
)

This is the popup
Ignore And Save Button:
OnSelect:
SubmitForm('MS Data Entry')
UpdateContext({DuplicationPopUp:Blank()})
Visible: LBLDup.Visible

Cancel Button:
OnSelect:
UpdateContext({DuplicationPopUp: Blank()})
Visible:
'LBL Save Changes'.Visible

LBL Save Changes:
Visible:
!IsBlank(DuplicationPopUp)

Rectangle:
Visible:
LBLDup.Visible

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@NitroPepsi

Keep in mind that your Lookup is very specific.

It is saying that the Provider and PROVIDERNUMBER must be equal to what you provided.

This means that any deviation in letter-case or spacing will not result in a match.

You can attempt to loosen it up a little with this:

If( LookUp('[incentive_test].[Lkp_Teaching]', StartsWith(Provider, DataCardValue2_1.Text) && StartsWith(PROVIDERNUMBER, DataCardValue2_1.Text), true ), UpdateContext({DeletePopup: true}), SubmitForm('MS Data Entry') )

Was this reply helpful? Yes No
NitroPepsi 221 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your help @RandyHayes and @Ramole I was able to get it to work! I went back and added the Hours data card and put the value part and it work! Thank you for another week of employment!

If(
LookUp('[incentive_test].[Lkp_Teaching]',
Provider=DataCardValue1_1.Text &&
PROVIDERNUMBER=DataCardValue2_1.Text &&
Hours=Value(DataCardValue3_1.Text),
true
),
UpdateContext({DuplicationPopUp: true}),
SubmitForm('MS Data Entry')
)

Was this reply helpful? Yes No