Filter Gallery by Group

[Bcleaver]

I have an App that uses SharePoint as a data source and has a people column ('Assigned To') that can hold people and groups. While I can successfully filter the gallery in my app by the logged-in user, in some cases I would like to do this by groups too. I would like to achieve the following:

- The logged-in user sees any items in the gallery assigned to themselves or the group. For example, if User A is part of an Office 365 group called 'Test Group', then I would like any items assigned to the 'Test Group' to appear in User A's gallery along with other assigned items to User A.

Any suggestions would be much appreciated 🙂. 

[Bcleaver]

Hi,

Yes to all three of those. No filter in the gallery.

On other items, it says false (which is correct) as its not assigned to the group, but then true for if the user exists in the group (as noted in the item in the gallery on my screenshot above - 'Test 26'. Again, this is correct as the user assigned to that item is a member of the group).

By email ID, it lists email addresses of all users in the group.

Thanks again for all your responses. It is very strange as to why that item doesn't seem to appear as all the others. Any further ideas (if any at all!) would be much appreciated.

[StalinPonnusamy · Accepted solution]

Hi @Bcleaver 

I would like to make sure you tried with the correct command. Can you verify this?

With(
    {_Item: [@SPList]},
    Filter(
        _Item,
        VarUser in ( Concat(
            Assiged.Email,
            Email,
            "&"
        )) || ("development@ltiblogs.onmicrosoft.com" in ( Concat(
            Assiged.Email,
            Email,
            "&"
        )) && VarUser in (Concat(
            Office365Groups.ListGroupMembers("1a23d6d0-6574-4c16-9290-6c9eb9e10984").value,
            mail,
            ","
        )))
    )
)

Note: Change Sp Security Name (Email) and GUID

Thanks,
Stalin - Learn To Illuminate

[Bcleaver]

Hi @StalinPonnusamy,

Yes I can verify that I've used the formula as stated in your message above. See screenshot:

I still have the same issue in that not all chosen fields in my gallery appear for any items that are assigned to the group. As mentioned before, I would expect title, progress and date to appear along with a clipboard image. To the right of the screen, I would expect an arrow icon that navigates to another screen showing that shows more detail regarding that specific item. See screenshot below:

Do you think there are any settings in the SharePoint site that may be affecting this? 

Thanks once again for continuing to persist with this! Its sincerely appreciated.

[StalinPonnusamy]

Hi @Bcleaver 

Can you validate permission for this Site?

• Go to List Settings
• Click Permissions for this List 

I guess this site allows to access the list for the user but not the group.

Other troubleshooting items

1. Can you create a new list and test this if possible?
2. Disconnect the current connection and re-connect as well

[Bcleaver]

Hi @StalinPonnusamy ,

So after refreshing connections, re-building the list and refreshing the permissions on my SP list (literally just removed and re-added), It all seems to be working. I have tested with a colleague who it also seems to work for. Thanks very much for the persistence and for offering a solution. 

I can now move on to other problems (how can something be assigned to a group, but act as if its been assigned to an individua? If I change the status on a list item assigned to a group  to 'completed' for example, how can I ensure that its only 'completed' for me and not other members who haven't completed their action? - Pretty sure this can't be done! 😁)

Thanks again, I'll mark the most recent post containing the formula as the solution 🙂.

[StalinPonnusamy]

Since this is assigned to the group, anyone from the group can able to edit it. We can do validation like the person who created this item is only able to edit it.

It means disabling the form/fields when the other users viewing the specific item when created by or owner is not the current user.

[Bcleaver]

Thanks for the response. 

I figured as much. What I'm really looking for as for someone to assign an list item to a group, but then have each item work individually so User A see's an item assigned to 'Test Group' when User A accesses the app for example and can update the item for them only. If User B accesses the app, then they will see the same item assigned to 'Test Group' and can update the item without affecting User A's changes (In effect, working as if assigned to an individual user). 

I expect we'll need to revisit how all this works before investigating this further. Thanks again for all your help.