Hi All
Need some help managing SharePoint documents through Powerapps Portal. We are doing a bit of R&D at the moment.
We have an entity which will record the uploading of files to SharePoint. I have a Dynamics CRM form which is used by a Portal page. The form contains fields which will be recorded in the entity plus a sub grid to enable the uploading of the file to our SharePoint document library. The portal page has the Table and Form layout properties set correctly
I have followed the steps in https://docs.microsoft.com/en-us/powerapps/maker/portals/manage-sharepoint-documents (Manage SharePoint documents). However found I needed to set the mode to Insert as Edit gave message "The requested record was not found", which sounds reasonable as we aren't processing an existing record, we are inserting a new record for a file upload. Also have set 'Enable table permissions' on portal page to off. This all worked nicely, a record was created in our entity and the document was uploaded to our SharePoint document library.
I then turned on table permissions on the Portal page and created a web role to use the child and parent permissions created in Step 5 of "Manage SharePoint documents" above. However I got issues with permissions for some dropdowns which we use to populate fields in our entity, so I turned off 'Enable table permissions' whilst I resolved these issues which are related to relationships.
What I have found is that the upload to SharePoint no longer works. The page works okay and gives the success message. The entity is populated correctly, but the document has not been uploaded to SharePoint. Also when the portal page loads we get a message at the top of the page "An unknown failure has occurred. Error ID #[some GUID], the GUID is different each time. Any ideas what may be causing the document not to upload to SharePoint?
Thanks in advance
