Ability to change SharePoint data source dynamically based on current Site URL

[mhl_pp]

The scenario is like this where i have multiple SharePoint sites with Same Schema. (count is more than 100 sites)

I have a list "Products" with same number of columns and their data types are also same on every SharePoint Site (Same schema again). basically its a provisioning case, user can create these kind of sites in future as well so site count keeps increasing.

The solution i am looking for that i create a standalone power app using one of the site and list and i embed power app url on a particular page of every site with query string parameter as That site URL.

When user goes to site A and click on link of Power App from site A, Data Source of that app and list of that app pointing to SIte A and user can do CRUD operation on list of Site A.

and When user goes to site B and click on link of Power App from site B, Data Source of that app and list of that app pointing to SIte B and user can do CRUD operation on list of Site B.

Basically to make this single app reusable across multiple SharePoint sites.

looking forward to have any updates on this idea.

CC: @navneet7326

[shoog]

The Power Apps SharePoint connector requires a fixed site, so you can't use this when the sites are dynamic.

However, you can create flows in Power Automate to retrieve and modify the data using the "Send an HTTP request to SharePoint" action which allows dynamic inputs.

[allthings365]

I'm currently finalising a blog that does exactly this (and much more) but for SharePoint libraries not lists.

As @shoog has already noted this is only possible using a couple of Power Automate flows inclusive of a few Send an HTTP request to SharePoint" actions.

For the purposes of my blog I only query data from SharePoint libraries for display purposes and as such it doesn't speak to create/update/delete use cases. In order to do that I would have equally had to implement that logic in Power Automate flows which would be far more difficult than using Forms in your Power App. Nonetheless possible.

I have an awesome demo app that I'll be sharing when I publish the blog (imminently) that equally showcases how you can append a query string parameter to the url for the Power App for the dynamic SharePoint library to query. The Power Automate flow used for this part of the solution is first-class, supports automatic paging for large libraries and with a few minor modifications can be adapted to work with SharePoint list instead.

My latest blog is a follow up to an earlier blog I published:

https://masteroffice365.com/viewing-word-powerpoint-and-html-files-from-sharepoint-within-powerapps/

https://youtu.be/6FVbE4zM0Zk

The follow-up blog is way better than the earlier one, displaying more types of files (PDFs, images/photos, videos) and more importantly to this topic - dynamic SharePoint library data sources. 

Watch this space...

[IvoF1]

Hello! Did you manage to post this about sharepoint libraries in your blog?