Right now, the SharePoint connection works great for simple use cases, but there are many more complicated use cases arent really working great with out of the box. A really useful feature/maybe connector would be a SharePoint HTTP action (similar to Flow) that can use the credentials of the current user to make the HTTP Rest call to SharePoint in the context of the current user. This would ensure: You only get the items that the user has access to You can get around list lookup limitations of SharePoint You can get around the delegation and large list filtering I'd imagine your source on a form or gallery might be something like this: Items: SharePoint.HTTP("https://contoso.sharepoint.com/sites/sitecollectionname/subsitename/_api/web/lists/getById('guidhere')/Items(3)", "applicaton/json;odata=nometadata") Which would return a json of of an individual list item. Items: SharePoint.HTTP("https://contoso.sharepoint.com/sites/sitecollectionname/subsitename/_api/web/lists/getById('guidhere')/Items", "applicaton/json;odata=nometadata") Which would return a json of of all the list items. Then users could tailor the content with the sharepoint odata in the URL, and you dont have to mess with connections that use admin crednetials or enterprise applicatons and keys.
... View more