Block Permission for an employee if an item created already in Power Apps.

[sas_23]

We have an App called Leave Request Application. Where Employees will get in and apply for leave, In this we have a section called Mandatory Leave (Mandatory leave is in Dropdown )where an employee can use this only once a year. all the data submitted in the Leave Request Application will be stored in a Sharepoint list called "Leave Request Form".For ex, If an Employee apply an Mandatory Leave on 22/9/2022, next time when he try to apply Mandatory Leave it should not work because for an employee he can apply Mandatory leave only once a year. How can we Achieve this.

[v-jefferni · Accepted solution]

Hi @sas_23 ,

This is achievable but the method will based upon of your need. If you want to hide the Yes selection from the dropdown, you can modify the Items of the dropdown:

If(
   IsBlank(LookUp('Leave Request Form', Employee.DisplayName = User().FullName && 'Are you applying for mandatory leave' = "Yes") && Year('Leave Date')= Year(Today()))),
   ["Yes","No"],
   ["No"]
)

Best regards,