Author Details

avatar-teacher

Evolvous

We are a team of tech enthusiast and this section is where we love to share our experience and our knowledge. We try our best to help you understand technical topics by giving you live instances of how-to’s, guides, tips, FAQ’s and troubleshoots.

If you like it or have questions, do share your feedback in the comments section below.

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. Collection could achieve this by creating collection whether “OnStart” property of the app or “OnVisible” property of screen.

Required:
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.

Populate SharePoint List Column Values Into PowerApps Combo Box - Evolvous

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.

Archival Solutions - Evolvous

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.

Coloumn Archives. Populate SharePoint List Column Values Into PowerApps Combo Box - Evolvous