Sharepoint View (Filter Current User's)

-

Once you create the new list, you must add columns to the list. You can add new columns to the list by clicking on the List Settings option displayed below. Next click on the “Create Column” link near the bottom of that page.
SharePoint List Settings
Create Column for SharePoint List
One of the columns of the list should be a column to assign the item to either a user or user group. This column is used to implement the filtering.
Next, create a view based on the user/user group column. This option is on the List Settings page below the Columns section.
Create custom view with person (user) & group
You can decide which columns are important for this new view. The most important thing for this example is adding the filter to only show list items that are assigned to the current user. It is also best to make the view the default view for the list at this point. We expand this filter later using SharePoint Designer 2010 to include the current user and any groups that user is in.
Add filter to show only show list items belonging to current user
Once the new view is create, open SharePoint designer and point it to the SharePoint instance that the list is in. Locate the list and select the new filter.
In SharePoint Designer open list and filter
The following code was received from this site (http://www.hornerit.com/2009/07/filtering-by-group-in-sharepoint-person.html). Please note that once you make this modification to the view, you will no longer be able to update it. It is best to make sure that all other settings are set before proceeding with this next step. In order to make any additional modifications to the view, it will have to be deleted and recreated.
Make sure that you are looking at the view in either the split view or the code view. Look for the Where clause in the code. The code should look similar to the following:
Code with Where clause in SharePoint Designer
Update the Where clause to contain the following code. Remember to rename the FieldRefs to the name that was found within your original code.
Update code with this code in SharePoint Designer
Once your changes have been saved, you should be able to view the filtered list based on the user/user group field. Now you have a custom view based on the current user

Comments

Post a Comment

Popular posts from this blog

Sites.Selected | Graph API SharePoint Permission

-
Image
  SharePoint Site Collection Permission   The "sites.selected" permission in Microsoft Graph API allows you to grant an application access to specific SharePoint sites instead of all SharePoint sites in the tenant.   Step1: To   Configure "Sites.Selected" Permission in Azure App Registration To use "sites.selected" , you need to: Register an App in Azure AD . Grant "Sites.Selected" Permission to the app. Manually Grant Access to the specific SharePoint site. Use Microsoft Graph API or PowerShell to assign the required role (Read/Write).   Step 1: Register an App in Azure AD Go to Azure Portal → Azure Active Directory → App Registrations . Click New registration . Provide a name (e.g., SharePointAccessApp). Choose Accounts in this organizational directory only . Click Register . Step 2: Add "Sites.Selected" API Permission Navigate ...
Read more

Configure the SharePoint Online App Catalog

-
Image
  You can create an Sharepoint Online app catalog site collection in few simple steps: Sign into Office 365 as a global admin or SharePoint admin. Select the app launcher icon   in the upper left and choose  Admin  to open the Office 365 admin center (if you don’t see the Admin tile, you don’t have Office 365 administrator permissions in your organization). In the left pane, choose  Admin centers  >  SharePoint .  Click on  ‘More Features’  from the left navigation/pane. Now, click on the  ‘Open’  button under Apps. Select  apps  in the left pane, and then select  App Catalog. Select  Create a new Sharepoint app catalog site , and then select  OK . On the Create App Catalog Site Collection page, enter the required information, and then select  OK . An app catalog site collection has been created.  Once the App Catalog site collection is created successfully, click on the new link to th...
Read more

Azure Function | Sharepoint List item | Call from Power Automate Flow

-
  🔹 Steps to Set Up an Azure Function for SharePoint List Item Creation 1️⃣ Create an Azure Function App Go to Azure Portal → Function Apps → Click Create . Choose: Subscription : Select your subscription. Resource Group : Create a new one or use an existing one. Function App Name : Enter a unique name. Runtime Stack : Choose .NET , Python , or Node.js . Region : Select a preferred region. Plan Type : Choose Consumption (Serverless) . Click Review + Create → Then Create . 2️⃣ Create a New Function Inside the Function App Open your Function App → Click Functions → + Add Function . Choose HTTP Trigger (for now, Power Automate will trigger this function). Name your function (e.g., SharePointNewItemTrigger ). Set Authorization Level to Function . Click Create . 3️⃣ Get SharePoint List Data Using Microsoft Graph API Since Azure Functions cannot directly detect SharePoint list changes, we use Power Automate to send data when an item is added. Modify the...
Read more