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
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

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

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (57,471)