We are developing a timesheet App that we wish to roll out for different BU's. Mainly Due to Data integrity and Dashboard, we want the Data(SharePoint Lists in this case) to be placed for each BU at different locations, maintained by their own admins.
The SharePoint Lists will have same Name and same structure (tables, columns, etc.). To do this we know one option is to save the app with another name and replace the data source manually inside the app editor.
It would be perfect to have just one single app where we can give the SharePoint site URL for different BU's in the app or in a table linked to app, and on User's selection for particular BU the SharePoint list is picked dynamically from that mapped SharePoint site location.
Do you know if this is possible?
Please let us know if this can be done! and if yes How ?
Thanks in advance from our team !