Posts

Showing posts with the label SQL Server

Steps to Embed a HTML Page in a Model-Driven App Form

Image
 Step 1: Upload the HTML file as a Web Resource Open your solution, then click on + New and select Web Resource. Add your HTML code. Set the File Type to 'Webpage (HTML)', provide a Name and Display Name, then click Save. HTML CODE: <!DOCTYPE html> <html> <head>     <title>Account Info</title>     <meta charset="utf-8" />     <script src="ClientGlobalContext.js.aspx" type="text/javascript"></script>     <style>         body {             font-family: "Segoe UI", sans-serif;             padding: 20px;         }     </style> </head> <body>     <h2>Account Information</h2>     <p> <strong>Record Id:</strong> <span id="id">Loading...</span><br/> <strong>Entity Name:</strong> <span...
Post a Comment
Read more

Unleashing Power Apps with Your Local MSSQL Data

Image
  Step 1: Install LocalDB Before proceeding, make sure LocalDB is installed on your computer. You can refer to the installation guide using this link . Step 2: Install SQL Server Management Studio (SSMS) Download and install SSMS by following this link . Step 3: Open SSMS Launch SQL Server Management Studio . You will see a window like the one shown below. Then, click on Connect . Step 4: Create a Database and Tables After connecting to the server, create a new database and the required tables as shown in the image below. To create a database: Right-click on Databases in the Object Explorer Select New Database Provide a name and click OK To create a table: Expand your newly created database Right-click on Tables Select New Table , then define your columns and data types Step 5: Install the On-Premises Data Gateway To connect your local database with cloud services like Power BI or Power Apps, you need to install the On-Premises Data Gateway . 👉 Click on this lin...
1 comment
Read more