cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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

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 ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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.

Snipaste_2020-11-23_14-13-51.png

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

View solution in original post

1 REPLY 1
Community Support
Community Support

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.

Snipaste_2020-11-23_14-13-51.png

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

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (21,036)