cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Titiwai
Level: Powered On

Duplicate Records

If, for example I have x number of teams contributing to a log at any time point and per day & I only want a single line log to be created and each is having input into its own 'team' columns.

 

Current design is I am using date as ID and preload next entire year's dates into SharePoint list. 

This is however not a dynamic choice itself.

 

And I do not know how to still maintain single row entry per day and having multiple entires without duplicate date records.

3 REPLIES 3
K-A-R-L
Level 10

Re: Duplicate Records

Hi @Titiwai ,

Instead of using Date as Id use this:

Text(Now(), "[$-en-US]mm-dd-yyyy-hh-mm-ss-fff")

That then will create a date and time stamp which is always unique.

Cheers

Community Support Team
Community Support Team

Re: Duplicate Records

Hi @Titiwai ,

Do you want to check whether there's duplicate date in the records when submitting record?

Could you tell me

1)what control do you use to update ID?

2)waht data type is the ID field?

I recommend you use the if statement to justify.

You could try this formulaSmiley Sadassume that you use date picker to update ID, the ID data type is date)

If(IsEmpty(Filter(table name,ID=DatePicker1.SelectedDate)),
SubmitForm(Form1),
Notify("This ID already exists!",NotificationType.Warning))

Best regards,

Community Support Team _ Phoebe Liu

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Titiwai
Level: Powered On

Re: Duplicate Records


If(IsEmpty(Filter(table name,ID=DatePicker1.SelectedDate)),
SubmitForm(Form1),
Notify("This ID already exists!",NotificationType.Warning))

I don't think I mean if the date already exists, I would still like to have submission if the day already exists by a second team?

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 263 members 4,110 guests
Please welcome our newest community members: