cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gochix
Resolver I
Resolver I

Display Items if same ID and Email address

Good morning,

I would like to ask help to anyone who can solve my problem.

 

I have a sharepoint list when i add new row then multiple rows might have same ID and same Email address.

So with that in hand i would like to display list where if same ID and email exist then not list them separately like item 1, item 2, item 3 but as 1 item.

See below what i have on the moment:

ID is 12 here.

Gochix_0-1632206343931.png

And what i'm trying to achieve :

Gochix_1-1632206383655.png

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Gochix ,

 

Try below code. 

 

Distinct( Filter(collectionName,ColumnName=User().Email),ColumnName)

if Sharepoint use below code

Distinct( Filter(collectionName,'CreatedBy'.Email=User().Email),ColumnName)

 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

View solution in original post

rampprakash
Super User
Super User

Hello @Gochix,

 

Yes you can 

 

Distinct(Filter(tableorListName,'Created By'.Email=User().Email),columname)

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

View solution in original post

6 REPLIES 6
rampprakash
Super User
Super User

Hello @Gochix,

 

You can use Distinct to filter the gallery.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Gochix ,

 

You can use Distinct function but be sure that after using Distinct only one column value will be displayed. 

 

So if you are happy with only one column you can use below formula. 

Distinct(collectionName,ColumnName)

 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

Thanks for idea. Yeah it works however if i need to filter this display. As this will display all entries made but i need filter to only show entries made by user = User().Email.

 

No other way to filter this?

Thanks

PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Gochix ,

 

Try below code. 

 

Distinct( Filter(collectionName,ColumnName=User().Email),ColumnName)

if Sharepoint use below code

Distinct( Filter(collectionName,'CreatedBy'.Email=User().Email),ColumnName)

 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

rampprakash
Super User
Super User

Hello @Gochix,

 

Yes you can 

 

Distinct(Filter(tableorListName,'Created By'.Email=User().Email),columname)

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Thanks for help. 🙂 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,304)