Filter wrong data to Galery

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

i filtered my gallaery based on month, year and department by dropdown.

this is my list,

createdDate	Creatorname	creatorMail	Recievermail	RecieverName	Department
03-03-2021	Suresh	suresh@test.com	Dani@test.com	Dani	Java
03-03-2021	Dani	Dani@test.com	suresh@test.com	Suresh	.net

from this list i filter my data into gallery based on Month and Department

Suresh

Java

This is a wrong result am getting while am selcting .net.

Am using follwing Formula ,
FirstN(SortByColumns(AddColumns(GroupBy(Filter(List,Month(CreatedDate) = Dropdown3_1.Selected.ID, Year(CreatedDate) =Dropdown6_1.Selected.ID && Department= Dropdown1.Selected.Value),"Creatorname","creatorMail","Details"),"Count",CountRows(Details)),"Count",Descending),5)

am using the above fomula for filtering data into my gallery

Is display wrong result instead of .net it showing java.

Is anything wrong in my formaul?

Thanks,

Dhinesh

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Dhinesh28R

Your formula is essentially fine. I would suggest the following just to boost performance a little:

SortByColumns( FirstN( AddColumns( GroupBy( Filter(List, Month(CreatedDate) = Dropdown3_1.Selected.ID && Year(CreatedDate)= Dropdown6_1.Selected.ID && Department = Dropdown1.Selected.Value ), "Creatorname", "creatorMail", "Details" ), "Count", CountRows(Details) ), 5 ), "Count", Descending )

As for the wrong department, this is going to hinge on the Dropdown1 selection. I would look over the items property of your dropdown and make sure you are filtering on the proper column of that selected item from the dropdown.

I hope this is helpful for you.

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,
It's working fine man. but i want a Creatorname 's Department.
In list it stores RecieverName Department.
But actually i want a dropdown selction for Creator Department records stores in Gallery.
Is this Possible?

Thanks,
Dhinesh

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Dhinesh28R

So what is the relationship of creatorname and receivername to the department?

What is the items property of the dropdown?

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like (1)

Report
Copy link

Link copied!

HI @RandyHayes,
I created column for CreatorDepartmnt.
Now its filtering correct Data man.

Thanks,
Dhinesh

Was this reply helpful? Yes No