cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
damien007US
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
v-siky-msft
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
v-siky-msft
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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,127)