Newform sharepoint list

[Veblitz]

I created new form canvas app and I have New user button and its basically new form so when user John from SharePoint user group(Contribute permission) submits the new form for the first time using PowerApps then if approvers from SharePoint approvers group(full permission) set the status of item  as Removed then that user John should be unable to submit  new form anytime in future .so my query is  how to restrict the user John  to access the New user button via PowerApps based on status "Removed" when he tries to access either it should be restricted or it should not be visible (recommended)

Kindly suggest and thanks in advance.

[Anchov · Accepted solution]

One suggestion.

On the OnVisible event on the Screen, create a collection filtered on the user and status.

ClearCollect(colUserRemoved, Filter(Submissions, UserEmail = User().email && Status.Value = "Removed"))

 Then, on the New User button, Visible Property:

CountRows(colUserRemoved) = 0