Restrict Who Can Submit Forms Based on a SharePoint Column Value

(0) Share

Report

Posted on by PatrickMcLeanGL

I have a tracker with 19 stages, where different departments are responsible for different stages. Is there a way set a button that it will only submit a form that the department is responsible for?

For example, if I press Submit, it checks what "Stage" the item is in, if its stage 10 for example, only Bob from Finance can submit the form, and if Sue from HR tries to submit the form she gets an error.

All responses (1)

Answers (0)

WarrenBelz 146,522 Most Valuable Professional on at

Like (0)

Report
Re: Restrict Who Can Submit Forms Based on a SharePoint Column Value

Hi @PatrickMcLeanGL ,

You will need a reference list with the Stage and a list of the emails (separate with spaces or commas) that can access that Stage. You can then look for User().Email - this will return true if the user is in the Stage permissions and false if not.

With( { _Data: Filter( YourList, Stage = YourStageValue ) }, !IsBlank( LookUp( _Data, User().Email in YourList.EmailField ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps