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.
ORYou 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 pickerSo whenever there is a user of the same email id appears, It displays user exist. You can disable buttons to save the forms .
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.