Hello community!
I have the following issue:
There is a sharepoint list with limited access.
I need an app with that every user in the organization will be able to create an item to this list, without actually being able to edit this list directly. That's why I was not able to use forms, because it requires all the users have access to that list.
As a solution from forums, I tried to create a PowerAps triggered flow, so the process is:
In powerapps there are fields, respective to SPO list fields. PowerAutomate is assigned to a Submit button.
On button click, power automate takes this fields data as input and creates a new item in SPO.
PowerApp is shared to all users in organization
PowerAutomate has two co-owners
Both co-owners have edit access to target list.
On testing it worked OK for me and co-owner.
On testing by users - power Automate shows the following error:
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
clientRequestId: 60f43419-648d-4a3a-9be5-e875ea13eead
serviceRequestId: 60f43419-648d-4a3a-9be5-e875ea13eead
Any thoughts to solve this?