Create form with multiple criteria

Question

Hello,

I need to create a form with the following requirements:

1. User A fills the form and Submits.
2. Upon Submission, the form is sent to User B.
3. User B reviews, adds comments and sends it to User C.
4. User C reviews, adds comments and sends it to Users A and B.

User B should not be able to change the data entered by User A.

User C should not be able to change the data entered by User B and A.

I have no knowledge of how to do all this. I'm just beginning to explore Power Apps and Microsoft 365.

So if anyone can help me figure out how to do this without involving a lot of e-mails and coding, it would be great.

Answer 1

Without Power Apps, you could achieve this through default SharePoint list form and alert.

Here're steps:

1.Create a SharePoint list with columns you required. When the user creates a new item, it means that the user submits a form.

2.Go to the newly created list -> Manage my alert -> Add alert -> Choose the newly created list.

(1)Send Alerts To: User A; Change Type: Existing items are modified; Send Alerts for These Changes: Someone else changes an item created by me.

(2)Send Alerts To: User B; Change Type: All changes; Send Alerts for These Changes: Anything changes.

(3)Send Alerts To: User C; Change Type: Existing items are modified; Send Alerts for These Changes: Someone else changes an item.

3.Go to List settings -> Advanced Settings -> Item-level Permissions -> Create and edit access -> Set Create items and edit items that were created by the user. After setting, only the creator can edit items.

4.Users will receive corresponding alerts. Users click the item in the email, then could make comments to the item.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Power Apps is currently not supported in the Q&A forum.

Please start a new discussion via the Power Apps Community so that you can get dedicated support on this issue.

Thank you for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.