web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Prevent duplicates

Power Apps

Unanswered

Prevent duplicates

(0) Share

Report

Report

Posted on by TheTurnip

17

I have created a basic canvas app. I need to prevent duplicate entries based on two columns. My thinking was to combine the created by column with the date period column using concatenation on my SharePoint list and enable unique value required, but the created by column is a lookup which you cant use in calculated columns. I created a single line text column in my SharePoint list called combined and thought that I could combine a label and a data using the concatenate function in PowerApps, as a workaround. I cant figure out the formula.

=CONCATENATE(DataCardValue10.Text,Label3.Text) Required sample output: John Smith01032022

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@TheTurnip

Calculated columns in your list are not relevant during the time a record is created.

"Created By" is not a Lookup column, it is a record that contains the Person record.

In your scenario, consider a LookUp function to perform what you need.

In general, the formula such as this:

LookUp(yourDataSource, 'Created By'.DisplayName = User().FullName && someOtherColumn = "01032022", true)

In the above, I hand-wrote the value of "01032022" because you did not provide any context as to what columns you are working with (other than Created By) and where you are getting the comparison values from.

But, the above formula will return true if such a record exists.

This logic van be used on a Visible property, or in a DisplayMode property to control the user experience when a record is a duplicate.

I hope this is helpful for you.

Was this reply helpful? Yes No
TheTurnip 17 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The second column is called Period and it contains set dates. We want to prevent duplicate entries and the only way I could think of was by linking the Created by column with the Period column and if the lookup returns a True a notification will be displayed stating that its a duplicate record instructing the user to change the date and button to accept, which when clicked will close the notification allowing the user to change the date. Time to see if I can work this out. Thank you for your help with this.

Was this reply helpful? Yes No

Join the conversation