Power Platform Community Forum Thread Details

Hello,

I have one SharePoint List named EmployeeWorkLoad.

In this list EmployeeName and ProjectName columns are lookup columns from different list and Occupied column is number format column.

I want this work as follows:
If I want to add one more project to Employee 1 then in the occupied column only 10% value should be accepted.
If I try to add more than 10% then it should give an error as Employee 1 already occupied 90% for previous projects.

Also while creating new entry, at the time of selecting ProjectName column (lookup column) it should not give the project name which are already assigned to respective employees.

For example :

For Employee 1, If I am adding new entry then at the time of selecting ProjectName It should show all project names except Project-2 and Project-5 as they are already assigned to the Employee 1.

Please guide me in this.

Thanks in advance!

Categories:

Building Power Apps