Answered

Prevent duplicate if already exists in SP list based on 2 Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

If(
 IsBlank(
 LookUp(Stemminglijst_1;Title = Dropdown.Selected.Value && Datum = IsToday(Today()) ))
 ;Patch(Stemminglijst_1; Defaults(Stemminglijst_1); {Title: Dropdown.Selected.Value})
 ;UpdateContext({varShowPopup:true}))

DropDown = List with custommers
Datum = Date

I would like to prevent a duplication in the SP list. The two conditions that are considered are the Title (dropdown) and the date(datum) of today. If these two combined do not exist then a "patch" may be performed.

Problem:
The Patch works any time, even when an item already exists. Is there a way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

As Datum is a date field

Datum = IsToday(Today()) is not correct

IsToday(Today()) - will return a true or false

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RezaDorrani , thanks for the quick response.

Datum is indeed a date field.

Do you have an idea what work? Have already used now () but that doesn't work.

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Text(Datum,"[$-en-US]dd/mm/yyyy") = Text(Now(),"[$-en-US]dd/mm/yyyy")

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the support @RezaDorrani !

Text(Datum;"[$-en-nl]dd/mm/yyyy";"bg-BG") = Text(Now();"[$-en-nl]dd/mm/yyyy";"bg-BG")
Work for us now.

Was this reply helpful? Yes No