Answered

Filter Gallery with duplicate data from the column

(0) Share

Report

Posted on by VTandon

Hi ,

I would like to list in Gallery 1 the Unique Order, VCode, DateOfOrder from the below datasource

ORDER	LINE No	Item	vCode	Order Date
49R25147	1	TPMP83497-TPL	JB	11/09/20
49R25147	2	TPMP83501-TPL	JB	11/09/20
49R25143	1	TPMG16036-TPL	JB	14/09/20
49R25143	2	TPMG16068-TPL	JB	14/09/20
49R25143	3	TPMG16089-TPL	JB	14/09/20
49R25143	4	TPMG16109-TPL	JB	14/09/20
49R25142	1	TPMG16036-TPL	JB	16/09/20
49R25142	2	TPMG16109-TPL	JB	16/09/20
49R25142	3	TPMG16166-TPL	JB	16/09/20
49R25142	4	TPMG16635-TPL	JB	16/09/20
49R25142	5	TPMG16637-TPL	JB	16/09/20
49R25141	1	TPMG16036-TPL	JB	21/09/20
49R25141	2	TPMG16166-TPL	JB	21/09/20
49R25141	3	TPMG16635-TPL	JB	21/09/20
49R25141	4	TPMG16638-TPL	JB	21/09/20
82174844	1	IO-82174844-01	B1	25/09/20
82174843	1	IO-82174843-01	B1	26/09/20
82174640	1	IO-82174640-01	B1	27/09/20
82174707	1	IO-82174707-01	B1	28/09/20

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

rsaikrishna

3,703 on at

Like (1)

Report

@VTandon

Use following formula:

Distinct(<Data Source Name>,Order>

More reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-distinct

Distinct function will provide unique items.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

Verified answer

Vijay Tailor 2,961 on at

Like (1)

Report
Hi @VTandon ,

You can use the group by Like below.
AddColumns(GroupBy(Sort(TestAkshay,Modified,Descending),"Title","StatusGrp"),"ID",StatusGrp.ID,"Modified",StatusGrp.Modified)

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
VTandon on at

Like (0)

Report

i need VCode, DateOfOrder column too...

Was this reply helpful? Yes No
VTandon on at

Like (0)

Report

@rsaikrishna

i need VCode, DateOfOrder column too...

Was this reply helpful? Yes No

Verified answer

rsaikrishna

3,703 on at

Like (1)

Report

@VTandon

ShowColumns(Distinct(<Data Source Name>,Order>),"Order","VCode",DateOfOrder)

Regards

Krishna Rachakonda

Was this reply helpful? Yes No

VTandon on at

Like (0)

Report

@rsaikrishna
distinct return a result column. ONLY
ShowColumns is not including the
"VCode",DateOfOrder

Was this reply helpful? Yes No
VTandon on at

Like (0)

Report

@VijayTailor please elaborate ...

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Hi @VTandon ,

Try like below -

AddColumns(GroupBy(OrderGroupBy,"Title","GroupBUOrder"),"vCode",Distinct(GroupBUOrder,vCode).Result,"vCOde",GroupBUOrder.'Order Date')
Thanks,

Was this reply helpful? Yes No