DatasetToExcel is a code component that can be used in powerapps to export any dataset to an excel file with features:
- Columns name based on selected fields in fields property
- Columns order based on selected fields in fields property
- Loading indicator
- customizable button (color,fill,font color,font size, border radius,border color)
Dataset to excel custom control is a pcf code compoent to export ant dataset within microsoft powerapps to excel file as simple as dealing with powerapps standard gallery with customizable button to match your app style.
Here is how to add the component to your microsoft dynamic 365:
- Before start using the component, you need to enable the Code Component in your environment if it is not enabled.
- from github repo releases, download the latest released solution.
- in you microsoft account navigate to powerapps, then solutions and select import solution, then continue importing the solution that you have downloaded from github.
- if solution imported successfully, open the app that you want to use the component in it, then select Insert menu form the left side bar, then in yhe bottom of the side bar, select Get more components, this will open a dialog in the right side, the dialog has 2 tabs, canvas and code, select code tab, then find DatasetToExcel component and import it.
Insert the data collection to "Items" property, once the button clicked, the component should download Excel file containing the data in collection
- Remember to add desired fields in component fields property
- You can change the apearance of button by changing the component properties for color, icon text color, etc..