web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to groupby with cr...

Power Apps

Answered

How to groupby with created by column

(0) Share

Report

Report

Posted on by rizwanmgm

Dear Experts,

I have a sharepoint list with title and manager column(Text), where manager store manager email of created by employee.

I want to create a screen where manager can see his team members and select that member to see the all the items of selected employee from gallery.

I have tried

ClearCollect(CollDistinct,Distinct(Filter(Mission,Manager="test@test.com"),'Created By'.DisplayName))

The collection showing the distinct list, now how can i show the selected employee all items in another screen?

Please help.

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rizwanmgm ,

If you want to filter records from the Mission table based on the user selected in this gallery, you can try this formula.:

Filter(Mission,Manager="test@test.com" && 'Created By'.DisplayName=GalleryName.Selected.Value)

Best Regards,

Bof
rizwanmgm on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for sharing your knowledge i use the same code.

Join the conversation