Power Platform Community Forum Thread Details

I am looking to create a PowerApps canvas control where for the 'Items' of the control, the user would enter a URL to the SharePoint list they want to target and retrieve the data. Is this possible without using the SharePoint connectors or PowerAutomate? If possible, how?

Categories:

Power Apps Pro Dev & ISV

Yes, it is possible. Most likely you will need to use Graph API in a PCF to pull the data you want the users to interact with. This is not impossible, but it does require quite a bit of work as you will need to get their current token silently, then prompt for a new token if they don't have one that is already valid for that SharePoint site. There are several blogs and past posts on this forum discussing how to call Graph API from a PCF and how to use MSAL to call Graph API from inside a PCF.

I haven't tried this second option myself, but another you might try is just iframing in the sharepoint content. That would make your coding VERY simple (just set a new src on the iframe) but it might not work if SharePoint does not have your powerapps domain in the allowfrom constraint. I know they added dynamics.com to the allowfrom about a year ago, if you're lucky, your powerapp is also allowed now. I wrote a blog post here on the community to show people how to build a sharepoint-targeting iframe pcf like this about a year ago. Can't find it right now, but here's a link to the github repo: cchannon/SharePointIFrame: A basic PCF for displaying the native SharePoint document library experience as an iframe in dataverse (github.com)