Power Apps Export Import Control [How to Use]

Did you have any requirements to work with Power Apps Export Import Control and are facing difficulties using it? Then, don’t worry.

In this Power Apps tutorial, I will explain how to use the Export and import control in Power Apps and the key properties.

Moreover, we will learn to add Power Apps Export and Import controls and how to use Power Apps Export and Import Control with various scenarios.

Additionally, I will cover how to Export or Import a SharePoint List in Power Apps.

Note:

Power Apps Export control is not supported in web browsers.

Power Apps Export Import Control

Microsoft Power Apps offers two types of controls that can be used within an app, i.e., Power Apps Export Control and Power Apps Import Control.

Import and export controls for exporting data to a local file and then importing that data into another app in Power Apps.

It’s critical to note that exported data generates a compressed file that can only be read within PowerApps and not in any other program.

Suppose you want to utilize the same data across multiple apps without sharing it with external sources. In that case, you can use the PowerApps Export and Import controls to export and import data.

How to use Power Apps Export and Import Controls

This is all about Power Apps Export and Import control.

Power Apps Export Import Control Properties

Here, I will explain the properties of Power Apps Export and Import control.

Property NameDescription
AlignThe place of text concerning the horizontal center of its corresponding control.
Border ColorA user can specify the color for a border.
Border StyleThis property specifies the type of border that the control should have [“Solid,” “Dashed,” “Dotted,” “None”].
ColorWe can define the text color of the control.
DataSpecify the text that should appear on a control.
DisabledBorderColorWhen the DisplayMode property of the control is set to Disabled, it indicates a color for the control’s border.
DisplayModeDetermines whether it enables user input (Edit), only displays data (View), or is disabled (Disabled).
FillWe can define the background color of the control.
HoverBorderColorBorder color of a control when the user hovers their mouse pointer over it.
HoverColorColor of a text when the user hovers their mouse pointer over it.
OnSelectWhen the user clicks on a control, it specifies what action to perform.
PressedColorWhen the user clicks on a control, specify the color of the text.
RadiusBottomRightRefer to the level of curvature present on the lower-right corner of a control.
SizeSpecify the font size of text that should appeared on a control.
TabIndexThis refers to the keyboard navigation sequence that is related to other controls.
TextSpecify the text that should appear on a control.
VisibleHere, we can specify whether the Export or Import controls can be visible.

These are the properties of Power Apps Export and Import Controls.

How to Add Power Apps Export Import Control

Here, I will show you how to insert export and import Controls in Power Apps:

  • Sign into Power Apps with your valid Microsoft 365 Credentials.
  • Create a Blank canvas app -> On the Power Apps screen, click +Insert -> Expand Media -> Select both the Export and Import Controls.
Add Power Apps Export and Import Controls
  • The Power Apps Export and Import Controls will appear like the screenshot below.
Power Apps Export Import Control
  • By default, the Export and Import control names will be “Export1“ and “Import1“; you can Rename the export control using “exp” and the import control using “imp” based on your requirement.
Import and Export controls in Power Apps

This is how to insert Power Apps Export and Import Controls.

How to use Power Apps Export and Import Controls

First, let me show you how to use the Power Apps Export and Import control individually.

How to work with Power Apps Export Control

This example will show you how to use the Export control in Power Apps.

Example:

I created a Power Apps canvas app and then added a Power Apps Export Control. On the Export control, I included the specific collection name that needs to be exported.

When the user clicks on the Power Apps Export control, the collection will be downloaded to the user’s local device as shown below:

Power Apps Export Control

Let me show you how to achieve this:

ClearCollect(
    colEmployeeDetails,
    {
        'Employee Name': "Serena",
        'Employee Department': "HR"
    }
)

Where,

  1. colEmployeeDetails = Provide the Collection name
  2. Employee Name, Employee Department = Collection column name
  3. Serena, HR = Collection column values
How to use Power Apps Export control
  • Click on the App, select the More options (…) -> Then click on Run OnStart to create a collection.
Export control in Power Apps
  • On the Power Apps screen, insert an Export control as shown below:
How to use Export control in Power Apps
  • Select the Export Control -> Set its Data property to:
colEmployeeDetails

Where,

  1. colEmployeeDetails = Collection name
How to use Export and Import controls in Power Apps
  • Once your app is ready, Save, Publish, and Preview the app. Once the user clicks on an Export control, it will directly navigate to your local device. You can save the collection in a zip file based on your requirements.

Note,

If you want to Export the data, please use the Power Apps app instead of web browser.
Power Apps Export control

This is how to work with a Power Apps Export Control.

How to work with Power Apps Import Control

This example will show you how to use the import control in Power Apps.

Example:

I added the Import control on the Power Apps screen. By selecting the control, you can navigate to your local device and choose the file you wish to import [I have selected the exported collection].

Power Apps Import Control

Follow the below steps to achieve this:

  • On the Power Apps screen, insert an Import control as shown below:
How to use Import control in Power Apps
  • Save, Publish, and Preview the app. Once the user clicks on an Import control, it will navigate to your local device and select the file you want to import.
Import Control in Power Apps

This is how to work with a Power Apps Import Control.

How to Export and Import a SharePoint List in Power Apps

This section will show you how to export or import a SharePoint List in Power Apps.

Example:

I have a SharePoint list [Loan Approval] that has various columns like:

Column NameData Type
User NameTitle
User ID ProofImage
Export a SharePoint List in Power Apps

I have created a Power Apps canvas app and connected the above SharePoint list. Then, I added Export and Import controls on the Power Apps screen. I have included the above SharePoint list name for the Export Control.

When the user clicks on the Power Apps Export control, the SharePoint list will be downloaded to the user’s local device as shown below:

Export or Import a SharePoint List in Power Apps

Later, if you want to import the same SharePoint list, click on the Power Apps Import control; it will navigate to your local device and select the file of the SharePoint list you exported.

How to Export or Import a SharePoint List in Power Apps

To achieve it, follow the below steps:

  • On the Power Apps screen, insert an Export and Import control as shown below:
Power Apps Export or Import a SharePoint List
  • Select the Export Control -> Set its Data property to:
'Loan Approval'

Where,

  1. Loan Approval = SharePoint list name
Export or Import SharePoint List to Power Apps
  • Once your app is ready, Save, Publish, and Preview the app. Once the user clicks on an Export control, it will directly navigate to your local device. You can save the SharePoint list in a zip file based on your requirements.
How to import or export a SharePoint list in Power Apps
  • Later, the user clicks on an Import control; it will directly navigate to your local device and select the file of the SharePoint list you exported.
Power Apps Import or Export a SharePoint list

This is how to export and import a SharePoint List in Power Apps.

Conclusion

I hope this Power Apps tutorial helped you to understand Power Apps Export and Import Controls.

Moreover, you have learned the key properties of the Power Apps export and import controls and how to add export and import controls in Power Apps.

Lastly, I have explained how to work with Power Apps export and import controls and export and import a SharePoint list in Power Apps.

Additionally, you may like some more Power Apps tutorials: