I have a custom screen made with user input controls for onboarding employee. When the user click on "Save" button, i need to check the Employee ID mentioned is already exists in the list.
If record exists i want to show a message, record already exists, if not go ahead and save the record in the share point list.
But i am not getting the desired output from the command i try.
Set(EmpRecord,LookUp(Employee_Onboarding,'Employee ID' = 'Employee ID',ID))
On button click
If (isBlank() Emprecord,
Notify "The Employee record already exists in the system")
Solved! Go to Solution.
Hi @venka91 ,
It should. Another solution is: go to your SharePoint list setting, and make the field "Reinforce Unique Value", then you don't need to code the save button.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT