site inspection demo power app - as a reference guide for making a company visitor app

[damien007US]

site inspection demo power app - as a reference guide for making a company visitor app

We ideally would like to make a company visitor app and have that sitting along side our leave app, building repair app etc. 

When looking at the site inspection demo power app we noticed the data source seems to be sitephotos and siteinseption are both collections saying that they are imported from excel as we are wanting to add and remove from the collection how can we get to the actual said excel file to add in the additional values we want to record like time in and time out etc ? 

Also how would one go about taking an existing excel driven powerapp and make that an ms sql driven power app ? Is there ms utility that would do this ? 

Lastly the app could only be accessed by AD users and when they choose who they are visiting it can only be from a valid AD user. 

Can anyone assist and point me / us in the right direction ? 

[v-siky-msft · Accepted solution]

Hi @damien007US ,

When first open the site inspect template app, you have a chance to make template to your own version by connecting to a real data source connection.

The data source(excel) can be found as follows if you choose OneDrive for business Connection.

Then you are able to add more columns for table to store the time in and time out value you want.

If you want to migrate the app to SQL base from Excel,  first you need to create the SQL table with the same data structure as the Excel Tables. Make sure the column types, column names, table names consistent.

When all tables are created, First Delete OneDrive for business connections for the Tables, and then add SQL connection to connect to three lists with the same connection name as previous. All data sources referenced in the formula can be automatically adapted to the new ones.

I suggest you first practice in your custom app and get to know how to migrate the data source from OneDrive for business to SQL Server based on above steps.

Hope this helps.

Sik