Answered

How to set a duplicate value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

Im a creating a app for vacations, I have an scroll menu with this dates:

14 ENERO 2021 / 30 ENERO 2021 (FT)
02 FEBRERO 2021 / 18 FEBRERO 2021 (FT)
22 FEBRERO 2021 / 10 MARZO 2021 (FT)
13 MARZO 2021 / 31 MARZO 2021 (FT)
03 ABRIL 2021 / 20 ABRIL 2021 (FT)
23 ABRIL 2021 / 11 MAYO 2021 (FT)
14 MAYO 2021 / 01 JUNIO 2021 (FT)
04 JUNIO 2021 / 23 JUN 2021 (FT)
04 JUNIO 2021 / 23 JUN 2021 (JR)

What I have done to avoid duplicated values, its to set on my SP list, unique values for this columns, but I want it to show an error message that alets that this option its already choosen.

Thanks for your help

Vacaciones BOG 1 - Guardada (no publicada) - Power Apps - Google Chrome 14_04_2021 12_38_15 p. m.png

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

You could customize the error message of the data card and set the text property to what you want
Example

In the visible property of the Error, you can add the condition
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

My apologize, I want to know wich formula it would work before to submit form, I have my submit button with this formula "SubmitFomr(form2);;Navigate(correct)... I need to check before to upload the info to check for duplicates
Verified answer

indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Do you mean that you have a scroll menu with custom date. So I'm assuming user can select only one date and you want to check from SP List if the date selected is already selected by another user.
In the submit button, you can set the verification as below and you can also set a popup msg if duplicate is there.

Also better you put a filter to remove the duplicate data from the scroll menu too.

in the submit button put the below code
If
(
!IsBlank(LookUp(SPList, SPListColumnDate=ScrollMenuDataCardValue34.SelectedDate)),
Set(ShowPopUp,true),
SubmitForm(form2)
)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
If(!IsBlank(LookUp('Solicitud de vacaciones', periodos=DataCardValue20.periodos)),Set(ShowPopUp,true),SubmitForm(form1);;Navigate(Correcto)

I tried with your formula but appears all this error messages in English "unexpected characters" and "invalid number of arguments on this formula".

Sorry for the inconveniences
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

i see the closed bracket missing from your If Statement

If(
!IsBlank(LookUp('Solicitud de vacaciones', periodos=DataCardValue20.periodos)),
Set(ShowPopUp,true),
SubmitForm(form1); Navigate(Correcto)
)