News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Group distinct values ...

Power Apps - Building Power Apps

Unanswered

Group distinct values across lines and columns

(0) Share

Report

Report

Posted on by Steggsy17

71

Hi team, I am looking for some advice around grouping distinct values from a table.

As you can see below, you have three lines where there is a mixture of names defined as PM, Assistant.

Ultimately for each of the ID's, I would like to end up with an additional column showing each of the distinct names across those two columns.

Any thoughts, for most efficient way would be great.

ID	Title	Project	PM,	Assistant	New Column
3	Variable	1	joe	steve	Joe; Steve
3	Variable	2	steve	joe	Joe; Steve
3	Variable	3	Joe		Joe; Steve

I use this to send emails within the app, but currently this would analyze all three lines and send Joe three emails.

But in the new column, this would group to just one and ultimately one email.

Thank you

Categories:

Using Apps Using Formulas

General Questions

All responses Img

All responses (1)

Answers Img

Answers (0)

Meekou 132 on at

Like (0)

Report
Group distinct values across lines and columns

For your request, you will need to use GroupBy to merge the rows for same ID.

Here is a sample demo

ClearCollect( GroupedProject, AddColumns( GroupBy( Projects, ID, PMAssistantTable ), PMAssistant, Concat( Filter( Distinct( Split( Concat( ThisRecord.PMAssistantTable, Lower(PM) & "," & Lower(Assistant) & "," ), "," ), Value ), Value <> "" ), Value, "," ) ) )

Test Data

Test Result

Regards,
Meekou
Personal Support

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Mentions and Quick Responses!

Give Back to the Community this Month

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

WarrenBelz 143,246

#2

RandyHayes 76,308

#3

Pstork1 63,884

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value

How to patch multiple records at once

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans