I am looking for a way to let users create items in a list with the following Criteria:
User can only add Items.
No view access to the list items including created items by the user.
I've tried the following steps:
SharePoint Workflows and Microsoft flows.
-Issue: It is slow to set item permission and it causes a security risk for the business. Also, the Risk of workflow failure.
Site Custom Permission does not allow the creation of add-only permission.
Read items that were created by the user from advanced Sharepoint list settings.
To Sum up: I would like to create a form that user can submit queries. After submission, depending on the business flow a series of processes (Sending emails, Approval Tasks, etc.) require to start. The solution is fully implemented but I am looking to find a way to fix the item permission security issue.