web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Meekou 200 Moderator 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

Was this reply helpful? Yes No

Join the conversation