cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yoursnani
Post Patron
Post Patron

Submitting data is new ( not duplicate)

Hi 

I am creating a form that hold employee details . we have text columns,people columns,and date columns 

My scenario is 

When user save data people columns is submitting person columns . when user first time submit form it should save, if user submit with same name in people columns ,form not to submit ? 

 

how can we achieve this ? 

1 REPLY 1
Abhilash_Swain
Super User
Super User

@Yoursnani ,
 One way of restricting -> If this is a share point list declare the column as Unique and required. It will not save the record.

Abhilash_Swain_0-1641292154147.png

 

OR
You can get the current employee names into a collection on APP Start. validate the textbox if the employee exist

 

I have used this in a Label control - Text.

If (!IsBlank(First(Filter(Employee_Office,Ename.Email = User().Email)).Ename.DisplayName ),"User Exist","")

Employee_Office:- is my SharePoint list and Ename is a people picker
So whenever there is a user of the same email id appears, It displays user exist. You can disable buttons to save the forms .

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (5,130)