DataSourceInfo

How to Use the Power Fx DataSourceInfo  Function in Power Apps

What is the DataSourceInfo Function?

The DataSourceInfo function is a Power Fx function that returns metadata about a data source. It helps developers to understand the structure of the data source and its properties. The function takes two parameters: the data source name and the property name.

How to Use the DataSourceInfo Function?

To use the DataSourceInfo function, follow these steps:

1. Open the Power Apps Studio and create a new canvas app.

2. Add a data source to the app by clicking on the ‘Data’ option in the left-hand navigation bar.

3. Select the type of data source you want to add, such as SharePoint or SQL Server.

4. After adding the data source, select the control that you want to bind to the data source.

5. In the formula bar, enter the following syntax to use the DataSourceInfo function:


Replace 'datasourcename' with the name of your data source and 'propertyname' with the name of the property you want to retrieve.

6. Press the Enter key to execute the function. The result will be displayed in the formula bar.

Examples of Using the DataSourceInfo Function

Here are some examples of using the DataSourceInfo function:

Example 1: Retrieving the Name of the Data Source

To retrieve the name of the data source, use the following syntax:


Replace ‘datasourcename’ with the name of your data source. This syntax will return the name of the data source as a string.

Example 2: Retrieving the Type of Data Source

To retrieve the type of data source, use the following syntax:


Replace 'datasourcename' with the name of your data source. This syntax will return the type of data source as a string, such as 'SharePoint' or 'SQL Server'.

Example 3: Retrieving the Number of Rows in the Data Source

To retrieve the number of rows in the data source, use the following syntax:


Replace ‘datasourcename’ with the name of your data source. This syntax will return the number of rows in the data source as an integer.

In conclusion, the DataSourceInfo function is a powerful tool in Power Apps that allows developers to retrieve metadata about a data source. The function can be used to retrieve the name, type, and other properties of a data source. By using this function, developers can create more efficient and effective applications.

Power Apps Training Courses by G Com Solutions (0800 998 9248)