Answered

Distinct based on a few values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello there!

I want to use the Distinct function to remove double values, but I also need to filter on a few things.

So I have a gallery where I need to put this code.

Current code;

Distinct(
 colCombined;
 Order0
 )

What I need;
I have a variable named "bedrijfNaam", which is the company name of the user logged in. For example; PowerUsers

We need to allow the user to only see the items where the companyname is the same as the variable bedrijfNaam

colCombined sadly doesn't have the order number, so we need to get it from another SharePoint list named ProjectLijsten

We need to look at 2 columns from ProjectLijsten; Order CompanyName

So colCombined does have the order number, so we have a connection between the 2.

Formula needs to be;

if CompanyName from Projectlijsten equals the variable bedrijfNaam && Order from ProjectLijsten equals Order from colCombined

And then we need to Distinct on the order number

Sorry for the bad explanation. Hopefully you get what I mean.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Jagadeeshk 457 on at

Like (0)

Report
Copy link

Link copied!

try this,
Distinct(filter(source, condition),columnname).
Note distinct is not a delegated function

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,
From your information, I think you want to achieve below:
1. If CompanyName from Projectlijsten equals the variable bedrijfNaam, get Order value of these records.
2.Filter colCombined if Order value equals above returned Order value, then distinct these returned records.

If my understand is correct, you can try this formula:
(from your information, Order0 is the column name in colCombined )
Distinct(Filter(colCombined;Order0 in Filter(Projectlijsten; CompanyName = bedrijfNaam).Order);Order0)
Best regards,
Allen

Was this reply helpful? Yes No