Avoid Duplicates column from sharepoint list to gallery based on month and year selection

(0) Share

Report

Posted on by Dhinesh28R

599

Hi all,

I have a doubt. I have a SP List with three coulmns RecipientName , RecipientDate, Function and Type.

Here, ReciepientName is Single line of Text, RecipientDate Date and Time, Function is Lookup and Type is Single line of Text.

Now what i want is, i get a values from sp list and display on gallery.

In that gallery i need to do a Avoid duplicate Recipient Value and want to show thier function and Countrows of Type column.

This is my SP List,

RecipientName	RecipientDate	Function	Type
Dhinesh	17-02-2021 13:11	Sharepoint	Helpful resource
Dhinesh	16-02-2021 13:11	Sharepoint	Innovative
Suresh	11-02-2021 13:11	Java	Hard Worker
Suresh	1-01-2021 13:11	Java	New Perspective
Dani	17-12-2020 13:11	Mobile Banking	Helpful resource
Rajan	10-08-2020 13:11	.net	Hard Worker

Now i want to get a details from this list and need to display into a gallery.

i want a gallery like this Based on month and year and also avoid duplicate values,

2021

Here 02 is Month and 2021 is year.

I used this Formula in my gallery Items,
AddColumns(GroupBy(Kudos,"RecipientName","RecipientEmail","CreatedonDate","Details"),"Count",CountRows(Details))

and am getting results like this,

Recipient Name	RecipientDate	Function	CountRows(Type)
Dhinesh	17-02-2021	Sharepoint	2
Dhinesh	17-02-2021	Sharepoint	2
Dhinesh	17-02-2021	Sharepoint	2
Dhinesh	17-02-2021	Sharepoint	2

And i need a gallerylike this.. Based om month and year selection by dropdown.

2021

Recipient Name	Recipient Date	Function	Count Rows(Type)
Dhinesh	17-02-2021	Sharepoint	2
Suresh	11-02-2021	Java	2

This is what i need a Result.

In my gallery i want to avoid a duplicate values and then their Function. And display a gallery by Selected month and year.
finally i need a count of how many types they have.

This is possible?

Thanks,

Dhinesh

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dhinesh28R .

Please Find the below Solution for your requirement.
See the Screenshot for reference -
Code for the below solution -
ClearCollect(SPList,Table( {RecipientName:"Dhinesh",RecipientDate:"17-02-2021 13:11",Function:"Sharepoint",Type:"Helpful resource"}, {RecipientName:"Dhinesh",RecipientDate:"16-02-2021 13:11",Function:"Sharepoint",Type:"Innovative"}, {RecipientName:"Suresh",RecipientDate:"11-02-2021 13:11",Function:"Java",Type:"Hard Worker"}, {RecipientName:"Suresh",RecipientDate:"01-02-2021 13:11",Function:"Java",Type:"New Perspective"}, {RecipientName:"Dani",RecipientDate:"17-02-2021 13:11",Function:"Mobile Banking",Type:"Helpful resource"}, {RecipientName:"Rajan",RecipientDate:"17-02-2021 13:11",Function:".net",Type:"Hard Worker"} )); //THis Code is for Group By ClearCollect(GroupBySumColl1,AddColumns(GroupBy(SPList,"RecipientName","GrpEmp"),"EMpCOunt",CountRows(Filter(GrpEmp,RecipientName=RecipientName)),"TypeCol",Concat(GrpEmp,Type," | "),"NewDate",Concat(GrpEmp,Text(DateValue(RecipientDate),"[$-en-US]mm yyyy")," | ")));
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
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @VijayTailor ,
Now its Working man..

But am tried with following code man,
FirstN(SortByColumns(AddColumns(GroupBy(Filter(Kudos,Month(CreatedonDate)=Dropdown4.Selected.ID,Month(CreatedonDate)=Dropdown5.Selected.ID),"RecipientName","RecipientEmail","Details"),"Count",CountRows(Details)),"Count",Descending),5)..

Now my proplem is i filtered gallery by month and year in dropdown..
stored month and year in collection. if i select month it filtered correct value.. If i filtered by year it didnt show values..

Thanks,
Dhinesh

Was this reply helpful? Yes No