Populate SharePoint List Column Values Into PowerApps Combo Box

Introduction:

In this blog you will learn about how to populate choice, user, text columns of SharePoint/ any data source values into PowerApps Combo box. This guide will show you how to Populate SharePoint List Column Values into PowerApps effectively. Collection could achieve this by creating collection whether “OnStart” property of the app or “OnVisible” property of screen.

Required:

• PowerApps
• SharePoint

Solution:

1. Populate choice column values of SharePoint into PowerApps combo box. Below is the example. From the below, ‘Archive History’ is list name and ‘Archive Status’ is choice column name in SharePoint. Added {Value:”All”} to populate “All” value to Combo box along with choice values like below screenshot.
ClearCollect(ColStatus,{Value: “All”},Choices(‘Archive History’.’Archive Status’));

you need to set “Items” property to “ColStatus” and have to set “SearchFields” property to [“Value”] and “IsSearchable” property to true for combo box in PowerApps.

2. Populate distinct Text column values of SharePoint into PowerApps combo box. Below is the example. From the below, ‘Archive History’ is list name, and ‘Site Name’ is text column name in SharePoint. Added {Result:”All”} to populate “All” value to Combo box along with text values like below screenshot.
              ClearCollect(ColFileSize,{Result: "All"},Distinct('Archive History',’Site Name’))

you need to set “Items” property to ” ColFileSize ” and have to set “SearchFields” property to [“Result”] and “IsSearchable” property to true for combo box in PowerApps.

3. Populate distinct people picker values of SharePoint into PowerApps combo box. Below is the example. From the below, ‘Archive History’ is list name, and ‘Archived By’ is people picker column name in SharePoint. Added {Result:”All”} to populate “All” value to Combo box along with text values like below screenshot.

ClearCollect(
    ColArchivedBy,{Result: "All"},
    SortByColumns(
        Distinct(
           Filter('Archive History',!IsBlank('Archived By')),'Archived By'.DisplayName
        ).Result,
        "Result",
        Ascending
    )
);

you need to set “Items” property to “ColArchivedBy and have to set “SearchFields” property to [“Result”] and “IsSearchable” property to true for combo box in PowerApps.

======

Plus read
Horizontal Scrollable for Vertical Gallery in PowerApps using Slider Control

How to install PnP PowerShell and connect with SharePoint Online