cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NicoTD
Level: Powered On

Filter Gallery - AssigendTo User is Group Member

Hello Guys,

 

so I have a Task List in Sharepoint, where tasks are either assigned to an user or a Sharepoint Group(Department).

In Sharepoint i can use the CAML(<membership>) Filter to only show a task, if the user is a group member.

 

Now i want to add this Filter to my Powerapps Gallery. Something like this: IsMember(AssigendTo = User()). Is this possible?

 

Thanks in advance.

 

Best wishes from Germany,

Nico

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Level 10

Re: Filter Gallery - AssigendTo User is Group Member

Use the following

  1. First of all you need to have a users table which have at lest UserColumn, EmailColumn As well as GroupName
  2. The idea is to create a variable that collects the Group associated with the Current User

            Set(VarGrropName, (LookUp(SPList2, MyEmail = User().Email,

          GroupName))
         3. 
Insert a Grouptextbox1 on your screen where your Gallery is located, set it text to: VarGrropName. This will collect           the GroupName in the Variable.
        4.Finally filter your Gallery items using:

         LookUp(SPList2, GroupName = Grouptextbox1.Text)

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

View solution in original post

1 REPLY 1
eka24
Level 10

Re: Filter Gallery - AssigendTo User is Group Member

Use the following

  1. First of all you need to have a users table which have at lest UserColumn, EmailColumn As well as GroupName
  2. The idea is to create a variable that collects the Group associated with the Current User

            Set(VarGrropName, (LookUp(SPList2, MyEmail = User().Email,

          GroupName))
         3. 
Insert a Grouptextbox1 on your screen where your Gallery is located, set it text to: VarGrropName. This will collect           the GroupName in the Variable.
        4.Finally filter your Gallery items using:

         LookUp(SPList2, GroupName = Grouptextbox1.Text)

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,872)