cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ToreG
Level: Powered On

Use Collect and Distinct in one function

Hi

I want to get a collection which is containing the input from an sql tabel, but as well distinct values of one single column from the same table. 
ClearCollect(StructureCollection;ShowColumns(Distinct('[dbo].[Structure]';"Entity_Key");"Entity_Key"));;
Collect(StructureCollection;'[dbo].[Structure]')

So the output should be the table and distinct values of one column, where all the other columns are empty. 

Can anyone come up with an idea of solving this problem? 


1 ACCEPTED SOLUTION

Accepted Solutions
PavanKumar
Level 8

Re: Use Collect and Distinct in one function

Hi,

 

yes you can do that as below

 

ClearCollect(colStructure,'[dbo].[Structure]');
ClearCollect(
colStructureFinal,
    AddColumns(
colStructure,
        "DistinctColumn",
       Concat(Distinct(colCaseList,'Entity_Key'),Result&" ,")
    )
);

If this answers your question mark it as verified and give a thumbs up

Regards,

Pavan Kumar Garlapati

View solution in original post

1 REPLY 1
PavanKumar
Level 8

Re: Use Collect and Distinct in one function

Hi,

 

yes you can do that as below

 

ClearCollect(colStructure,'[dbo].[Structure]');
ClearCollect(
colStructureFinal,
    AddColumns(
colStructure,
        "DistinctColumn",
       Concat(Distinct(colCaseList,'Entity_Key'),Result&" ,")
    )
);

If this answers your question mark it as verified and give a thumbs up

Regards,

Pavan Kumar Garlapati

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,520)