Thursday, July 20, 2017

Create a SharePoint View for All Tasks Assigned to Groups a User is in

I wanted to create a new SharePoint view for tasks that were assigned to me or any groups I'm in.  So first I went to the list where I want to create the view in SharePoint Designer and select new.  I named mine "My Groups":



Then right-click the view and select "Edit in Advanced Mode" to open it up, and search for:

 <Query/>


and replace it with the following:

<Query><Where>
<Or>
<Membership Type="CurrentUserGroups">
<FieldRef Name="AssignedTo"/>
</Membership>
<Eq>
<FieldRef Name="AssignedTo"></FieldRef>
<Value Type="Integer">
<UserID/>
</Value>
</Eq>
</Or></Where></Query>

Thanks goes out to Laura Rogers' article on this one!

No comments: