cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Switch Template to use SQLServer

Hi

there are a few interesting templates (for example the Property Management)  that don't have any Data Connectors. How can I convert the template to work with mssql?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Hi @Mrrcomp ,

 

First of all you need a connector to your mySQL database.

The structure of mySQL table  has to be identical to TenantCollect collection or Excel file (called Suites) from where data was imported to app. You can see all columns by writting in formula bar "Suites." 

After that, from VIEW menu -> DataSource  you need to create a connection to the database table.

After all this are done, all you have to do is to modify the "Suites" word from the OnVisible property of the first screen with the name of the new connection created.

 

Capture.PNG

 

Hope it helps !

    

View solution in original post

1 REPLY 1
Highlighted
Memorable Member
Memorable Member

Hi @Mrrcomp ,

 

First of all you need a connector to your mySQL database.

The structure of mySQL table  has to be identical to TenantCollect collection or Excel file (called Suites) from where data was imported to app. You can see all columns by writting in formula bar "Suites." 

After that, from VIEW menu -> DataSource  you need to create a connection to the database table.

After all this are done, all you have to do is to modify the "Suites" word from the OnVisible property of the first screen with the name of the new connection created.

 

Capture.PNG

 

Hope it helps !

    

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (13,046)