Site permission problems in automated ticket system

[RDinho]

Hello all,

I've constructed a ticket system using Microsoft Power Automate, Forms and SharePoint. The idea is that users create their ticket in Forms, after which Power Automate will enter the given information in a SharePoint list. All of this works perfectly, however, I am not happy with the site permissions.

In order for someone to be able to create a ticket using the system described above, I need to assign them 'Edit' rights in SharePoint or else Power Automate returns an authorisation error. Obviously, I don't want to assign 'Edit' rights to all the users of the ticket system because I don't want to run the risk that everyone can change anything they woud like. My preferred solution would be to assign them 'Read' rights so they can monitor, but not change, the tickets.

I have a solution in my head where I use Power Automate to regulate the account with which the ticket is created. I could then switch the user account to, for example, an admin account so authorisation is never an issue. However, I do need to preserve the details of the original user to know where the ticket came from.

I would love to hear your thoughts on this matter.

[v-bacao-msft]

Hi @RDinho ,

So far, have you created Flow based on your ideas, what is its current specific configuration?

For assigning permissions to the SharePoint list, please refer to this blog:

assign-unique-permissions-to-a-document-with-the-new-send-an-http-request-to-sharepoint-action-how-t...

For detailed information about getting users, you can get it through Get user profile action.

Based on your description alone, it is difficult for us to provide you with a suitable Flow template. Please try to create a similar Flow based on your own ideas. If you encounter any difficulties, please let us know.

Best Regards,

[RDinho · Accepted solution]

Hello Barry,

Thank you for your reply. Over the weekend, I began tinkering with SharePoint and I found that the solution is to create a new usergroup and assign those the exact rights that I wanted them to have. This means that I now have a custom usergroup with users who can only create and view tickets, instead of being able to edit and delete them.

That means that my issue has been solved 🙂

With kind regards,

RDinho

[v-bacao-msft]

Hi @RDinho ,

Great! If you have found a solution to your problem, please click "Accept as Solution" on the reply that describes how you were able to solve your issue!

This makes your post much easier for other members of the community to see and find when looking for a solution!

Best Regards,