Distinct 2 columns or distinct groupby function

(0) Share

Report

Posted on by efeewfew

302

Hello there!

I have a Sharepoint list with 2 columns; MontageFirma & MontageFirma2

These columns show the company working on a certain project, there can max be 2 companies working on 1 order. I need to have all companies in a dropdown only once.

I tried to find a way with Distinct, but you can't distinct on 2 columns.

Currently I got this code, but there are duplicates;

GroupBy(
 'D-Nummers-OpleverApp';
 "MontageFirma";
 "MontageFirma2";
 "MontageRecords"
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @efeewfew ,

Could you prvide a sample data(list) ? (Initial data - > Target data)

I think this is a simple requirement .

Best Regards,

Wearsky

Was this reply helpful? Yes No
efeewfew 302 on at

Like (0)

Report
Copy link

Link copied!

Of course @v-xiaochen-msft , here is a screenshot of my data:

2 simple text columns that have the company name in it

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@efeewfew

Collect(mf,Distinct(SPlist,MontageFirma));

Collect(mf,Distinct(SPlist,MontageFirma2));

mf will be a list of all of the firms in both lists. If there are duplicates in the collection, mf, you can create another collection using Distinct() on mf.

Collect(mf2,Distinct(mf,Result))

Was this reply helpful? Yes No