Answered

Data aggregation or lookup in PowerApps?

(0) Share

Report

Posted on by Yin

Hi all,

I am working on a dataset having multiple projects in it. Each project has a unique id, but every unique project can have multiple rows due to the different products it has purchased, each unique product has its own row. The information in "Product name" and other columns related to a product are different for each unique product. I will upload the data to OneDrive, then use it as the data source for PowerApps. I wonder if PowerApps has some functions that can pull out all the information of a project by the unique ID, which means pulling out all the rows related to a project. It's like the vlookup in excel for data aggregation.

Thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi @Yin,

It looks like the GroupBy() function is what you want if there is a one to many relationship between projects and products. In that case, it would be GroupBy(Projects,"ProjectID","ProductInfo"). You could use a button with the OnSelect property:Collect(productsbyID,GroupBy(Projects,"ProjectID","ProductInfo") to create the Collection. You can then display the results in a Gallery with a subGallery. The Items property of the parent Gallery would be ProjectID. You would display the information about the product in the subgallery with the Items property set to ProductInfo. Both Galleries should be flexible height to accomodate both large and small subgallerys. In the example, I collected some names by State from a table of customers. If this is not the case, please attach a screenshot of the data source table.

For more information check out for more details on the GroupBy() function: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby

Was this reply helpful? Yes No
Yin 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp,

Thank you so much for your help. Sorry for the late reply, just got back from a business trip. Groupby is what I need. Now I got another questions. After grouping by the data in the gallery, how can I link the gallery with a search box? Normally, the search funtion can be typed in the Item property of the parent gallery. But the groupby function is in it now, how can I link the parent gallery with a search box?

Thank you so much,
Yin

Was this reply helpful? Yes No