Power Platform Community Forum Thread Details

Hi everyone,

I’m currently working on a Power App where I want to perform the following tasks with a collection:

Display filtered data from the collection within the app.
Show either the first 4 records or fetch data from specific random columns within the collection.

I’ve created a collection successfully, but I’m unsure how to implement these specific requirements. Any guidance or formulas to achieve this would be greatly appreciated!

Categories:

Building Power Apps

Hello,

If you already have built a collection, please see the step-by-step recommendation below

Step 1: Display Filtered Data

If you want to show only specific data from your collection (e.g., filtering by a column like "Status" = "Active"), you can use the Filter() function. Here’s an example:

Set this formula as the Items property of your gallery or table, and it will display only the filtered results.

Step 2: Show the First 4 Records

To display just the first 4 records in your collection, you can use the FirstN() function like this:

Set this as the Items property, and you’re good to go!

Step 3: Fetch Data from Specific Columns

If you want to focus on specific columns (e.g., "Name" and "Email"), the ShowColumns() function will help. For example:
ShowColumns(YourCollectionName, "Name", "Email")

You can also combine this with other functions. For instance, to show the first 4 records but only from specific columns, use: