Power Apps offers a variety of input controls, including Text, Label, Gallery, Data Table, and more. Out of all these controls, Import and Export are the two most important for importing and exporting data in Power Apps.
This article assists you in learning what PowerApps import control is and how to work with PowerApps export data in detail.
Also, we will see the various properties of Power Apps export import control and how to work with Power Apps import data button with various examples.
Later, we will discuss the limitations of Power Apps Export import control.
Power Apps Export Import Control
Apart from the Power Apps Export Import Package, in the app, there are two types of controls available that you can use inside your app: PowerApps Export Control and PowerApps Import Control.
Data can be exported to a local file using Power Apps Export Control and imported into another PowerApps app with Power Apps Import Control.
The most important thing you should know is that when you export data, you will create a compressed file that you can copy to another machine but cannot read in any program other than Power Apps.
Let’s say you would like to create multiple apps that share the same data but don’t want to share it with anyone outside those apps. You can use the PowerApps Export and Import controls to import and export the data.
Power Apps Export Import Control Properties
Here, we will see the key properties of the Power Apps Export and Import control.
| Property | Description |
| Align | The horizontal positioning of text for the control’s center position. |
| Color | It provides the color of text in a control. |
| DisplayMode | This control has three possible states: Edit, View, or Disabled. The Edit state permits user input, the View state displays data, and the Disabled state renders the control unusable. |
| Fill | It represents the background color of a control. |
| HoverFill | The color of a control’s background when the user hovers the mouse pointer over it. |
| Size | It specifies the font size of the text that appears on a control. |
| strikethrough | Whether a line appears through the text that appears on a control |
| Text | The keyboard navigation order regarding other controls needs to be determined. |
| Visible | It defines whether a control appears or is hidden. |
These are the key properties of the Power Apps Export and Import control.
How to Use Power Apps Export and Import Control
Let’s see how to add and use the export and import control in Power Apps. To do so, follow the below-mentioned steps. Such as:
1. Open Power Apps with your respective Microsoft credentials -> Create a Blank canvas app as in the screenshot below.
2. On the Power Apps Screen, expand the + Insert tab -> Expand Media -> Select Import as shown below.
3. Once the Import control is added by default, the Text property of the Import control is “Import Data,” and the name of the control is “Import1,” as in the screenshot below.
4. Similarly, insert an Export control under the Media dropdown. By default, the Text property of the Export control is “Export Data,” and the name of the control is “Export1,” like below.
Next, we will use the Power Apps export-import control with a simple example.
Example:
I have created a manual Power Apps collection named “colTravel” using different headers/columns, as shown below.
Now, I would like to export this collection to the local device and import it from the local device to the Power Apps Canvas app.
Refer to the below image: