Excel is one of the most common Data Source for Power Apps, that can have more than 2000 rows. End Users are continuously updating existing rows or adding new rows into it, which again increases its size.
Please note that my Excel file is stored in OneDrive for Business and I am using Excel Online (Business) connector.
We already know that Canvas Power Apps has a limitation to access only 2000 at one time. Hence, if we want to access 2001th row, we need to be careful while selecting the formula to get that row because of Delegation warning.
If we use Filter function, we can only get up to 2000th row. To resolve this issue, we can use Search function, even for the dropdowns.
We can write below code on OnChange event of the Text Input or DropDown or ComboBox.
Create a folder where you want to store all the files of your project. I have created a folder named DemoPCFProject. Open NodeJS Command Prompt and navigate to the newly created folder using cd command.
Below are the steps to Setup the environment to create PCF Code Components. You will be creating your first pcf code component.
System Setting when developing this component:
Machine OS: Windows 10
System Type: 64-bit OS
IDE: Visual Studio Code
Below are the steps to setup the environment. This is the one time setup and don’t need to repeat this again.
NPM is Node Package Manager. npm is world’s largest Software Library. This is free to use. It includes CLI developers can use to download and install software. npm is installed with Node.js, which means we have to install NodeJS first.
Navigate to https://nodejs.org. Install the LTS version even if it is older then the latest version. The version keeps on changing. I will be using NodeJS version 18.13.0
Click on the LTS version. This will download the node-v18.13.0-x64.msi installer. Click on it and it will open the Installation wizard. The wizard is pretty straight forward. Click Next and install NodeJS. This installation will take a couple of minutes.
Install Power Apps CLI (Command Line Interface)
Click here to install Power Apps CLI. This will download .msi file. For me it downloaded powerapps-cli-1.0.msi. Click it and install CLI. It is a simple wizard, follow it and install it.
Install Visual Studio Code
I will be using Visual Studio Code for development purpose. It is free of code and you do not need a license for it. Download Visual Studio Code from here.
Power Platform Extension
Once you install Visual Studio Code, install Power Platform Extension. Open Visual Studio Code, go to Extensions, type Power Platform Tools. If you see 2 results of the same name, choose the one which is not in Preview mode. Preview Mode releases you can use for development/testing purpose, but they should not be used in Production. Click on Install. This will install the extension.
We use HTML, CSS and TypeScript to create code components.
Developers can also use ReactJS, AngularJS, Fluent UI. These are optional, but are preferred.
3 areas in code component: Manifest File, Component Implementation and Resource Files.
Manifest File has properties about the component like Name, Description, Version, Resource Files etc. App Makers can statically set the value of these properties or dynamically bind it to any available data columns of the application. These properties help the application and component to communicate with each other.
Resource Files has static resources like libraries used, CSS files, Images used at various places etc.
There is a SQL Server Table Project_Details with a column Due_Date of type datetime. In Canvas Apps, we have a collection named projectDetailsColl in which we are collecting Projects Details like txtProjectName as Text Input, dtpDueDate as Date Picker. The requirement is to save the values from collection to SQL table.