You’re offline. This is a read only version of the page.
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.
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.
Share
Report
All responses (
Answers (
155,559
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
