Hello,
I created a canvas Power App connected to 4 separate SharePoint lists. There are 4 screens where a user can submit a form. Users select the form they need to complete, fill it out, and submit it. Then, the data populates on a separate screen where other users can review the data and make edits as needed. As the creator of the app, when I submit a test form, the data connects without any issues and the SP list is updated. This works on all 4 forms. However, when a user tries to submit a form, it only works on 2 of the 4 lists. I have tried setting list permissions to Edit without success, so I tried Full Control. The Full Control permission works for 2 out of the 4 lists.
Does anyone know why my data won't send to the list after submitting the form in my app? Is there something I need to do with list permissions/in the app directly to solve this issue?
We want any user to be able to use the app, but not have member access to the SharePoint site where it's housed, just the list.
This is the first app I have built so I'm not sure if I am missing something.