List view to show item assigned to SharePoint group

SharePoint out of box list view filter gives us an option to create a view that can show the list of items assigned to logged in user, but there is no filter option available to show items assigned to a group.

We can handle this type of scenario by setting the item level permissions, so that the users will be able to show the items/documents for which they have access, but we will be facing issues when the user needs access to update the item in a later point of time.

I am going to explain you a way how we can create these kinds of view using PnP PowerShell

1. Create a column 'AssignedToGroup' in the list
2. Set the value of group for which you want to show the item
3. Create PowerShell script, connect to SPO site using 'Connect-PnPOnline'
4. Use the command 'Add-PnPView' to create the view( example :Add-PnPView -List "List Name" -Title "View Name" -Fields "Title","Address" -Query 'Valid CAML Query')

CAML query : 
            <Where>
              <Or>
                <Membership Type=\"CurrentUserGroups\">
                  <FieldRef Name=\"AssignedToGroup\"/>
                </Membership>
                <Eq>
                  <FieldRef Name=\"AssignedToGroup\"></FieldRef>
                  <Value Type=\"Integer\">
                    <UserID/>
                  </Value>
                </Eq>
              </Or>
           </Where>        

With this approach we can create complex view. Further you can format the view using JSON list view formatting and show the content on a modern page by adding list view webpart. This way we can achieve complex views creation ,formation and displaying the records in a modern page without creating SPFx webpart or Power Apps forms.

Reference Links :

• https://pnp.github.io/powershell/cmdlets/Add-PnPView.html
• https://docs.microsoft.com/en-us/sharepoint/dev/schema/membership-element-query?redirectedfrom=MSDN