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 ?
@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.
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 .
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
266 | |
91 | |
78 | |
68 | |
67 |