Create Share Point List

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.

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.

Hi Shaik ,

 

To create a SharePoint list with the requirements you mentioned (Vendors, Business Operators, and tasks completion status), you can follow these steps:

1. 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.

2. 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.

3. 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.

4. 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.

5. 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.

6. 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.

7. 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.

8. Customization (Optional):

   • Depending on your specific requirements, you might need to customize the list further using SharePoint Designer or Power Apps.