Create Share Point List

Question

I need to create Share Point list for the columns of Vender Business operaters and give tasks complete or not. each vender has atleast 3 more Businness operaters all these 3 operators task complet or not shown in my Sharepoint list. How to create this type of list?

Tasadduq Burney · Answer

Here are the steps as bullet points for creating a SharePoint list to track vendors business operators and task completion statuses: Access your SharePoint site. Navigate to Site Contents or Site Contents > New > List. Choose Custom List as the list type. Define Columns: Add columns for Vendor Business Operator and Task Completion Status. Click List settings > Create Column. Vendor and Business Operator Columns: Create a Vendor Name column with the Single line of text type. Create a Business Operator column using Person or Group or Choice type. Task Completion Column: Create a Task Completed column with Choice type (options: Yes and No). Lookup Columns (Optional): If needed add columns for task names and their completion status. Create a lookup column linking Vendor Name and Business Operator columns. Views (Optional): Customize views to filter and sort data. Create views for specific vendors completion statuses etc. Input Data: Populate the list with vendor names business operators and task statuses. Access and Permissions: Adjust permissions to control access for different users. Set permissions for vendors and business operators accordingly. Customization (Optional): Customize the list by adding columns for due dates priorities attachments etc.

Saravanan Ganesan · Answer

Hi Shaik  To create a SharePoint list with the requirements you mentioned (Vendors Business Operators and tasks completion status) you can follow these steps: Create a SharePoint List: Log in to your SharePoint site. Click on Site Contents or a similar option to access the list of site contents. Click New and select List. Choose Custom List as the list type. Define Columns: Add columns to the list for Vendor and Business Operator information. For each entity you might need columns like Name Email etc. Add columns to track tasks completion status. You can create a column for each task with a choice or checkbox type to indicate completion. Create Relationships: Since each Vendor can have multiple Business Operators and each Business Operator can have multiple tasks you'll need to set up relationships between these entities. SharePoint Lists do not inherently support complex relationships so you might need to use Lookup columns. For example you can create a Lookup column in the Business Operator table to reference the Vendor table. Add Data: Populate the list with Vendors Business Operators and tasks. You can manually add the data or if you have a large amount of data consider using tools like Microsoft Excel to import data. Create Views: Create views to display the information in a meaningful way. You might want views that show Vendors and their associated Business Operators and tasks. Access and Collaboration: Share the list with relevant users or groups who need to access and manage the information. Assign permissions appropriately to control who can view edit and delete items in the list. Automation and Workflows (Optional): If you want to automate processes you can use SharePoint workflows or Power Automate (formerly known as Microsoft Flow) to trigger actions based on events such as task completion status changes. Customization (Optional): Depending on your specific requirements you might need to customize the list further using SharePoint Designer or Power Apps.

Cr Bhargavi · Answer

To create a SharePoint list with columns for vendors business operators and tasks completion status and to link the business operators' tasks with the vendors you can follow these steps: 1. **Create the SharePoint List:** - Navigate to your SharePoint site. - Click on the gear icon (Settings) and select Site contents. - Click on New > List and choose Custom List. - Provide a name for your list (e.g. VendorTasks). - Click Create. 2. **Add Columns:** - Edit the list by clicking on List settings. - Click on Create Column to add the necessary columns: - Vendor: Single line of text - Business Operator: Choice or Person/Group - Task Completion: Choice (options: Complete Not Complete) 3. **Add Sample Data:** - Go back to the list. - Click on Quick Edit to add sample data. Add multiple rows for different vendors and their business operators. 4. **Create a Lookup Column (Vendor-Business Operator Relationship):** - Edit the list settings. - Click on Create Column. - Choose Lookup as the column type. - Select the Business Operator column from the target list. 5. **Filtering and Grouping:** - In the list view you can use filters and grouping to organize tasks by vendors and business operators. - Group by Vendor to see tasks grouped by vendors. 6. **Conditional Formatting (Optional):** - You can apply conditional formatting to highlight completed or not completed tasks using JSON formatting. This setup will allow you to create a SharePoint list where you can track tasks for vendors and their associated business operators. You can filter tasks group them by vendors and see the completion status of each task. The lookup column helps establish the relationship between vendors and business operators.