Power Apps - Add and manage data sources Tutorial

Unlock the potential of your applications with our tutorial on "Add and Manage Data Sources"! Discover how to seamlessly import Excel files into Power Apps, integrate multiple data sources, and visualize key information effortlessly. Whether you're a novice or looking to enhance your skills, this guide will empower you to create dynamic, low-code applications. Dive in now!

02:58
0 views

Available in Microsoft365

00:00:02

step in building interactive and dynamic applications.

00:00:06

This feature allows users to integrate various types of sources,

00:00:10

such as SharePoint lists,

00:00:11

Excel tables,

00:00:12

and other providers,

00:00:14

although some of these may require premium access.

00:00:17

In this tutorial,

00:00:18

we will focus specifically on importing an Excel file.

00:00:22

Before integrating an Excel file into power apps,

00:00:24

it is essential to follow certain rules.

00:00:27

First,

00:00:27

the data must be organized in a table

00:00:29

format as Power Apps only recognizes this structure.

00:00:33

Additionally,

00:00:34

it is recommended to rename the table to make

00:00:36

it easier to locate during the import process.

00:00:40

In this tutorial,

00:00:41

we will use a commercial database that includes key information,

00:00:44

such as the salesperson's name,

00:00:46

the revenue generated,

00:00:47

and the date of the transaction.

00:00:51

There are several ways to import an Excel file into Power apps.

00:00:54

The first method involves using a gallery to display the imported data.

00:01:00

To implement this,

00:01:00

the user must access the insert menu and add a gallery.

00:01:05

Once the gallery is added,

00:01:07

Power Apps automatically prompts the user to select a data source.

00:01:13

The second method is based on adding a new screen

00:01:16

that contains a gallery or list to display the data.

00:01:20

During the screen setup process,

00:01:22

the user simply selects the data source when prompted by power apps.

00:01:28

The 3rd and recommended method is to use the add data button.

00:01:32

In this approach,

00:01:33

the user begins by clicking this button

00:01:34

and then selects the Excel Online connector,

00:01:37

which is the option used in this tutorial.

00:01:41

After selecting the connector,

00:01:43

the user must connect their account and specify

00:01:46

the location of the file to be imported,

00:01:48

such as OneDrive.

00:01:51

Once the file is located,

00:01:53

the user selects it and chooses the name of the table

00:01:56

that contains the data to be integrated into Power apps.

00:02:00

After completing the import process,

00:02:02

the user can verify the presence of the data by navigating to the data tab.

00:02:07

This step ensures that all the necessary information

00:02:10

has been correctly integrated into the application.

00:02:13

It is important to note that Power Apps allows multiple

00:02:16

data sources to be added to a single application,

00:02:19

enabling cross-referencing of different types of information.

00:02:24

Once the Excel data has been successfully imported,

00:02:27

it can be displayed on screen.

00:02:29

To achieve this,

00:02:29

the user must insert a gallery into the interface.

00:02:33

And then select the imported data source.

00:02:37

Allowing the information to be visualized directly within the app.

00:02:42

Through the steps detailed in this tutorial,

00:02:44

Excel data has been successfully integrated into Power apps.

00:02:48

In the next guide,

00:02:49

we will explore the various ways to

00:02:51

manipulate galleries in order to present information

00:02:54

in an interactive and optimized manner.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

0 Views

Video Training Microsoft PowerApps : Create your first applications without coding

Get started with Power Apps and learn how to design your first applications without writing any code. This module guides you step by step th...

ALL COURSES