Monday, April 28, 2025

How to Delete Previous Versions in a SharePoint Document Library Using PowerShell

Managing document versions in SharePoint is crucial for maintaining an organized and efficient workspace. Over time, document libraries can accumulate numerous versions, consuming storage space and complicating file management. This article provides a step-by-step guide on how to delete previous versions in a SharePoint document library using PowerShell.

Prerequisites

Before you begin, ensure you have the following:

  • Access to the SharePoint site and document library.
  • PowerShell installed on your machine.
  • Necessary permissions to execute scripts and manage SharePoint libraries.

Step 1: Install the PnP PowerShell Module

The PnP PowerShell module is essential for interacting with SharePoint Online. Install the module using the following command:

Install-Module -Name PnP.PowerShell


If you are using PowerShell 7 or later, you might need to install it specifically for that version:

Install-Module -Name PnP.PowerShell -Scope CurrentUser

Step 2: Import the PnP PowerShell Module

After installing the module, import it into your session:

Import-Module PnP.PowerShell

Step 3: Connect to SharePoint Online

Use the Connect-PnPOnline cmdlet to connect to your SharePoint site. Replace the placeholders with your actual SharePoint site URL and credentials:
Connect-PnPOnline -Url "https://yoursharepointsite.sharepoint.com" -Credentials (Get-Credential)

You will be prompted to enter your credentials.


Step 4: Delete Previous Versions in a Document Library

Once connected, you can use the following script to delete previous versions in a specified document library. Replace "YourLibraryName" with the actual name of your document library:

$library = "YourLibraryName"
$files = Get-PnPListItem -List $library
foreach ($file in $files) {
    Remove-PnPFileVersion -List $library -Identity $file.Id -AllVersions

}

This script retrieves all items in the specified document library and deletes all previous versions of each file.

Troubleshooting Common Issues

If you encounter errors such as CommandNotFoundException, ensure the PnP PowerShell module is installed correctly and imported into your session. Verify the installation with:

Get-Module -ListAvailable -Name PnP.PowerShell

Ensure you are using the latest version of PowerShell by checking your version:

$PSVersionTable.PSVersion

Restarting PowerShell after installing a module can also resolve recognition issues.

Alternative Solutions

If PowerShell isn't your preferred method, consider these alternatives:

  • Power Automate: Create a custom flow to automatically delete older versions based on specific criteria.
  • Manual Deletion: Use the SharePoint interface to manually delete versions via the Version History option.
  • SharePoint Trim Versions Feature: Utilize SharePoint's built-in feature to trim versions based on age or count limits.

By following these steps, you can efficiently manage document versions in your SharePoint libraries, ensuring a streamlined and organized workspace.

USING POWER AUTOMATE

Implementing the deletion of previous versions in a SharePoint document library using Power Automate can help automate and streamline the process. Here’s a step-by-step guide to create a Power Automate flow for this task:

Step-by-Step Guide to Create a Power Automate Flow

1. Create a New Flow

  1. Go to Power Automate.
  2. Click on Create and select Instant cloud flow.
  3. Name your flow and choose the trigger Manually trigger a flow. Click Create.

2. Get Files from the Document Library

  1. Add a new action Get files (properties only).
  2. Configure the action:
    • Site Address: Select your SharePoint site.
    • Library Name: Select your document library.

3. Loop Through Each File

  1. Add an Apply to each action.
  2. Set the value from the Get files (properties only) action as the output to loop through each file.

4. Get File Versions

  1. Inside the Apply to each action, add a Send an HTTP request to SharePoint action.
  2. Configure the action:
    • Site Address: Select your SharePoint site.
    • Method: GET
    • Uri: _api/web/lists/getbytitle('YourLibraryName')/items(@{items('Apply_to_each')?['ID']})/versions
  3. This action retrieves all versions of each file.

5. Delete Previous Versions

  1. Add another Apply to each action inside the first one to loop through each version.
  2. Set the value from the Send an HTTP request to SharePoint action as the output.
  3. Add a Condition to check if the version is not the current version.
    • Expression: @not(equals(items('Apply_to_each_2')?['IsCurrentVersion'], true))
  4. In the If yes branch, add a Send an HTTP request to SharePoint action to delete the version.
    • Site Address: Select your SharePoint site.
    • Method: DELETE
    • Uri: _api/web/lists/getbytitle('YourLibraryName')/items(@{items('Apply_to_each')?['ID']})/versions(@{items('Apply_to_each_2')?['ID']})

Summary

This flow will loop through each file in the specified document library, retrieve all versions, and delete all previous versions while keeping the current version intact. This automation helps maintain a clean and efficient document library without manual intervention.

If you have any questions or need further assistance, feel free to reach out! 😊

Thursday, April 24, 2025

To open or edit code in Linux server

we can use various terminal-based editors depending on what's installed on your Linux server. Here are a few ways to do it:

For example, the code resides in /var/www/proj_management.

🛠️ View files in the project directory:

bash
ls -la /var/www/proj_management

✏️ Edit a specific file (e.g., index.php):

Using nano (simple editor):

bash
sudo nano /var/www/proj_management/index.php

Using vim (powerful, but has a learning curve):

bash

sudo vim /var/www/proj_management/index.php

Using code (if Visual Studio Code CLI is installed):

bash
sudo code /var/www/proj_management


If you're accessing the server via SSH and want to edit with a GUI-based editor like VS Code on your local machine,
you can use Remote - SSH extension in VS Code.

----------------------------------------------------------

If you want to use Remote - SSH extension in VS Code to open and work with files on a remote Linux server (like your /var/www/proj_management directory), here’s a quick setup guide:


Step 1: Install Remote - SSH Extension in VS Code

  1. Open VS Code.

  2. Go to the Extensions panel (Ctrl+Shift+X).

  3. Search for “Remote - SSH”.

  4. Click Install.


Step 2: Add SSH Configuration

  1. Press Ctrl+Shift+P to open the Command Palette.

  2. Type Remote-SSH: Add New SSH Host and select it.

  3. Enter your SSH command, e.g.:

    bash
    ssh your_username@your_server_ip
  4. Choose the SSH config file to save this entry (usually ~/.ssh/config).


Step 3: Connect to the Server

  1. Open the Command Palette again (Ctrl+Shift+P).

  2. Select Remote-SSH: Connect to Host.

  3. Choose your saved server from the list.

  4. VS Code will open a new window connected to the remote server.


Step 4: Open Your Project Directory

Once connected:

  1. Click File > Open Folder.

  2. Enter:

    bash
    /var/www/proj_management
  3. You now have full access to browse, edit, run, and debug the code remotely as if it's on your local machine.


Tuesday, April 22, 2025

30 Websites for job seekers to check out in 2025!

 Forget Naukri, Upwork, Fiver, and Indeed 

These are overcrowded...

Here are 30 Websites for job seekers to check out in 2025! 

🏷Save this post for Later use 

1. SimplyHired (simplyhired.com)

2. Jobspresso (jobspresso.co)

3. Stack Overflow Jobs (stackoverflow)

4. Outsourcely

5. Toptal (toptal.com)

6. Skip The Drive (skipthechive.com)

7. NoDesk (nodesk.co)

8. RemoteHabits (remotehabits.com)

9. Remotive (remotive.com)

10. Remote4Me (remote4me.com)

11. Pangian (pangian.com)

12. Remotees (remotees.com)

13. Europe Remotely (europeremotely.com)

14. Remote OK Europe (https://lnkd.in/gr4C-mjp)

15. Remote of Asia (https://lnkd.in/ghrA_z9u)

16. FlexJobs (flexjobs.com)

17. Remote.co (remote.co)

18. We Work Remotely (weworkremotely.com)

19. RemoteOK (remoteok.com)

20. AngelList (angel.co)

21. Linkedin (linkedin.com)

Resume-Making Websites 🎯 

1. Canva - canva.com

2. Resume Genius - resumegenius.com

3. Zety - zety.com

4. Novoresume - novoresume.com

5. Resume.com - resume.com

6. VisualCV - visualcv.com

7. Enhancv - enhancv.com

8. Resume.io - resume.io

9. My Perfect Resume - myperfectresume.com

10. SlashCV - slashcv.com


Interview Preparation Websites📚

1. InterviewBit - interviewbit.com

2. Glassdoor - glassdoor.com

3. Interviewing.io - interviewing.io

4. Jobscan Interview Prep - jobscan.co/interview

5. Indeed Interview Tips - indeed.com/career-advice

6. CareerCup - careercup.com

7. The Muse - themuse.com

8. PrepLounge - preplounge.com

9. Big Interview - biginterview.com


Google is offering FREE online courses with certification.

𝗙𝗥𝗘𝗘 (𝗚𝗼𝗼𝗴𝗹𝗲) 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘆𝗼𝘂 𝘄𝗶𝗹𝗹 𝗿𝗲𝗴𝗿𝗲𝘁 𝗻𝗼𝘁 𝘁𝗮𝗸𝗶𝗻𝗴 𝗶𝗻 𝟮𝟬𝟮𝟱.

🎉 Start Learning Now

🔃7000+ free courses free access: https://lnkd.in/gaE8D-FW

1. Google data Analytics

https://lnkd.in/dF69UPKS

2. Google Project Management

https://lnkd.in/dyDdPT3C

3. Foundations of Project Management

https://lnkd.in/dc7HBE8v

4. Google Introduction to Generative AI

https://lnkd.in/dBpavRzd

5. Google Cybersecurity 

https://lnkd.in/dEkKJA57

6. Google UX Design

https://lnkd.in/d8DCCrT9

7. Google Digital Marketing & E-commerce:

https://lnkd.in/d2dcwWyJ

8. Google IT Support:

 https://lnkd.in/gj7SEh22

9. Web Applications for Everybody Specialization: 

https://lnkd.in/d7J_urhb

10. Get Started with Python

https://lnkd.in/dbVfekE6

11. Learn Python Basics for Data Analysis

https://lnkd.in/dKxTMVkj

12. Google Advanced Data Analytics Capstone

https://lnkd.in/dhXHt4AH

13. Data Analysis with R Programming

https://lnkd.in/dHqdPBVz

14. IBM Full Stack Software Developer Professional Certificate

https://lnkd.in/dxg6NYns

15. Introduction to Web Development with HTML, CSS, JavaScript​

https://lnkd.in/ds6gMSND

16. IBM Back-End Development Professional Certificate

 https://lnkd.in/dNJq5d3C

17. IBM Python for Data Science, AI & Development:

 https://lnkd.in/dxjgY8mx

Monday, April 7, 2025

Extracting x-ms-exchange-parent-message-id from a Text File Using Python

In the world of email processing and automation, extracting specific headers from email metadata can be crucial for various tasks. One such header is the x-ms-exchange-parent-message-id, which can be essential for tracking email threads and parent-child relationships in email conversations. In this blog post, we'll walk through a simple Python script to extract this header from a text file.

Why Extract x-ms-exchange-parent-message-id?

The x-ms-exchange-parent-message-id header is used to identify the parent message in an email thread. This can be particularly useful for:

  • Email Threading: Keeping track of email conversations.
  • Automated Email Processing: Automating responses or actions based on the parent message.
  • Data Analysis: Analyzing email communication patterns.

The Python Script

Here's a step-by-step guide to creating a Python script that reads a text file and extracts the x-ms-exchange-parent-message-id header.

Step 1: Import the Required Module

First, we'll import the re module, which provides support for regular expressions in Python.

import re

Step 2: Define the Function

Next, we'll define a function extract_parent_message_id that takes the file path as a parameter, reads the file content, and searches for the x-ms-exchange-parent-message-id header.

def extract_parent_message_id(file_path):
    # Read the content of the file
    with open(file_path, 'r') as file:
        data = file.read()
    
    # Regular expression to find the x-ms-exchange-parent-message-id
    pattern = r'x-ms-exchange-parent-message-id:\s*<([^>]+)>'
    
    # Search for the pattern in the data
    match = re.search(pattern, data)
    
    # Extract and return the parent message ID if found
    if match:
        return match.group(1)
    else:
        return "x-ms-exchange-parent-message-id not found"

Step 3: Use the Function

Finally, we'll use the function to extract the x-ms-exchange-parent-message-id from a sample text file.

# Example usage
file_path = 'path/to/your/file.txt'
parent_message_id = extract_parent_message_id(file_path)
print("x-ms-exchange-parent-message-id:", parent_message_id)

Conclusion

With this simple script, you can easily extract the x-ms-exchange-parent-message-id from any text file containing email headers. This can be a powerful tool for anyone working with email data, whether for automation, analysis, or other purposes.

Feel free to adapt and expand this script to suit your specific needs. Happy coding!

Friday, March 28, 2025

Unable to connect to a required endpoint. Power Platform now relies on a new cloud service dependency called Power Platform API. If you have conditional access policies or fire

 Unable to connect to a required endpoint. Power Platform now relies on a new cloud service dependency called Power Platform API. If you have conditional access policies or fire

wall rules in place, you may need to allow access to the Power Platform API endpoints.

To resolve this issue, try the following steps:

  1. Check Firewall and Proxy Settings

    • Ensure your network allows access to the Power Platform API endpoints.

    • The necessary URLs to allow can be found in Microsoft's official documentation here (if applicable).

  2. Update Conditional Access Policies

    • If your organization enforces conditional access policies, ensure that the Power Platform API is allowed under your policy settings in Microsoft Entra ID (formerly Azure AD).

  3. Verify Tenant and Environment Access

    • Ensure you have the correct permissions to access the Power Platform API within your tenant.

    • Try using Power Platform Admin Center to validate the environment settings.

  4. Check for Service Outages

  5. Test API Access Manually

    • Use tools like Postman or PowerShell to make test API calls to https://api.powerplatform.microsoft.com/ and check for responses.

If the issue persists, try contacting Microsoft Support for further assistance.

Monday, March 24, 2025

AI Builder Add-on: Features, Pricing & Use Cases

 AI Builder is an add-on for the Power Platform that enables AI-powered automation within Power Apps and Power Automate. It provides prebuilt and customizable AI models for tasks like form processing, object detection, sentiment analysis, and OCR (Optical Character Recognition).





🔹 What is Included in AI Builder?

FeatureDescription
Form ProcessingExtracts data from invoices, receipts, and forms (structured/unstructured PDFs & images).
Object DetectionIdentifies and counts objects in images (useful in inventory management, defect detection, etc.).
OCR (Text Recognition)Extracts printed and handwritten text from documents & images.
Business Card ReaderCaptures and extracts details from business cards.
Sentiment AnalysisDetermines positive, negative, or neutral sentiment from text input.
Category ClassificationCategorizes text automatically based on trained models.
Entity ExtractionExtracts relevant information like names, dates, or addresses from unstructured text.
Prediction ModelUses historical data to predict outcomes (e.g., churn rate, sales forecasting).
Custom AI ModelsTrain models with your own datasets for unique business needs.

🔹 AI Builder Pricing (2025)

AI Builder is an add-on that requires a Power Platform license (such as Power Apps Per User Plan or Power Automate Premium).

PlanPrice (Approx.)Credits IncludedUse Case
AI Builder Add-on (Base Plan)₹15,140/user/month ($500/user/month)1 million service creditsBasic AI functionalities for a small workload.
Additional AI Credits₹1,500 ($50) per 100,000 credits100,000 service creditsIf more processing power is needed.

Each AI Builder action (OCR, Form Processing, Sentiment Analysis, etc.) consumes service credits.
🔹 The number of credits consumed varies by model complexity and volume of data.

For high-volume AI processing, enterprises may need additional AI credits beyond the base plan.


🔹 AI Builder Use Cases in SharePoint & Power Platform

1️⃣ Automating Invoice Processing

📌 Use Case: Extracting key details (vendor name, invoice amount, due date) from invoices and storing them in SharePoint or Dataverse.
💡 Solution:

  • AI Builder – Form Processing extracts data.

  • Power Automate moves data to SharePoint or an ERP system.

2️⃣ OCR for Scanned Documents in SharePoint

📌 Use Case: Extracting text from scanned PDFs and images stored in SharePoint.
💡 Solution:

  • AI Builder – OCR reads the text.

  • Power Automate extracts and saves structured data in SharePoint lists.

3️⃣ Sentiment Analysis on Customer Feedback

📌 Use Case: Analyzing customer emails or chatbot interactions for sentiment.
💡 Solution:

  • AI Builder – Sentiment Analysis determines if feedback is positive, neutral, or negative.

  • Power Automate categorizes responses and escalates negative feedback.

4️⃣ Object Detection in Manufacturing & Inventory

📌 Use Case: Identifying missing parts or defects in a manufacturing line using images.
💡 Solution:

  • AI Builder – Object Detection scans images.

  • Power Automate alerts teams about issues.

5️⃣ Automating Business Card Data Entry

📌 Use Case: Capturing business card data into a CRM (Dynamics 365, Salesforce).
💡 Solution:

  • AI Builder – Business Card Reader extracts contact details.

  • Power Automate saves the details in a CRM or Excel.


🔹 Do You Need AI Builder?

AI Builder is recommended if:

  • You need AI-driven document processing, text extraction, or predictive analytics.

  • You want to integrate OCR, form processing, or sentiment analysis into SharePoint, Power Apps, or Power Automate workflows.

  • You are building intelligent automation for invoices, contracts, or feedback processing.

🚀 If you have Microsoft 365 E3 or E5, AI Builder is NOT included—you’ll need to purchase an AI Builder add-on separately.


 

AI Builder Free Credits & Availability

AI Builder provides free monthly credits for organizations with a Power Apps or Power Automate paid plan. These free credits allow limited AI model usage without purchasing an AI Builder add-on.


🔹 How Many Free AI Builder Credits Do You Get?

License TypeFree AI Builder Credits (Per Tenant, Monthly)Availability
Microsoft 365 E3 / E5❌ No free creditsAI Builder requires a separate license.
Power Apps Per User Plan✅ 5000 credits/monthIncluded in standalone Power Apps Per User Plan.
Power Automate Per User Plan✅ 5000 credits/monthAvailable with Power Automate Per User Plan.
Power Apps Per App Plan✅ 375 credits/month (Per Environment)Only for apps assigned under the Per App Plan.
Power Automate Per Flow Plan✅ 5000 credits/monthShared across all licensed flows.
Power Platform Developer Plan✅ Limited free usageGood for testing but not for production.

📌 Note:

  • These free credits reset monthly and do not accumulate.

  • If you exceed the free credits, you’ll need to purchase additional AI Builder credits.

  • Microsoft 365 (E3/E5) does not include free AI Builder credits—you must have a Power Apps or Power Automate plan to access them.


🔹 What Can You Do With Free AI Builder Credits?

The free AI Builder credits are enough for basic OCR, form processing, sentiment analysis, and object detection. Here’s an estimated usage breakdown:

AI ModelEstimated Uses with 5000 Credits
Form Processing~1000 document scans per month
OCR (Text Extraction)~500 images per month
Business Card Reader~1500 scans per month
Sentiment Analysis~3000 text analyses per month
Object Detection~1000 image scans per month
Prediction Model~2000 predictions per month

📌 For large-scale AI processing, consider the AI Builder Add-on (₹15,140/month for 1M credits).


🔹 How to Check Your Free AI Builder Credits?

1️⃣ Go to Power Platform Admin Center → Power Platform Admin Center
2️⃣ Navigate to "Environments" and select your default environment
3️⃣ Click Settings → Resources → Capacity
4️⃣ Under AI Builder Capacity, check "Available AI Builder Credits"


🔹 Next Steps

  • If free credits are enough → Use AI Builder within the Power Apps or Power Automate plan.

  • If you need more credits → Purchase additional AI Builder service credits (₹1,500 for 100,000 credits).

  • If you only need AI Builder for development → Sign up for a free Power Platform Developer Plan



Microsoft 365 Licensing Guide: Choosing the Right Plan for Development, Automation, and SharePoint

Microsoft 365 subscriptions, such as:​

  • Microsoft 365 F3
  • ​ Microsoft 365 E3​
  •  Microsoft 365 E5​
  • Microsoft 365 A3
  • ​ Microsoft 365 A5
  • ​ Microsoft 365 Business Premium​
  • Microsoft 365 Education Student Use Benefit

Differences Between Microsoft 365 Subscriptions

Each Microsoft 365 subscription comes with different features tailored for specific use cases. Below is a comparison to help you decide which one suits your development needs.

PlanTarget AudienceKey FeaturesBest For Development?
Microsoft 365 F3Frontline WorkersWeb & mobile apps, 2GB mailbox, limited OneDrive (2GB), Teams❌ Limited developer tools
Microsoft 365 E3EnterprisesFull Office apps, 100GB mailbox, advanced security, 1TB OneDrive✅ Good for general development
Microsoft 365 E5Enterprises (Advanced Security & Compliance)Includes E3 + advanced security (Defender, Compliance, Power BI Pro)✅ Great if security & analytics are needed
Microsoft 365 A3Education (Schools, Staff)Similar to E3 but for education❌ Not for corporate development
Microsoft 365 A5Education (Advanced Security & Compliance)Similar to E5 but for education❌ Not for corporate development
Microsoft 365 Business PremiumSmall & Medium BusinessesIncludes Office apps, Intune, security, Defender✅ Suitable for business development
Microsoft 365 Education Student Use BenefitStudentsFree access to Office apps, Teams, and OneDrive❌ Limited enterprise tools

Which One is Best for Development?

If you're a developer working with Microsoft technologies like Power Platform, SharePoint, or Azure, you should go for:

  1. Microsoft 365 E3 – Good balance of features with enterprise-grade tools.

  2. Microsoft 365 E5 – Ideal if you need advanced security, Power BI Pro, and analytics tools.

  3. Microsoft 365 Business Premium – Works well for small/medium-scale projects.

How to Decide?

  • If your organization provides E3 or E5, it’s best for development.

  • If you need Power BI Pro, Microsoft Defender, and compliance tools, go for E5.

  • If you’re working in a small business or startup, Business Premium might be sufficient.


If you have Microsoft 365 E3 or E5, you should have:
Power Apps for Microsoft 365 (Limited to standard connectors)
Power Automate for Microsoft 365 (Limited to standard connectors)
SharePoint Online Plan 2 (If included in E3/E5)

If you need premium connectors, Dataverse, or AI Builder, you might require an additional Power Platform license.

Method 2: Check in Power Platform Admin Center

  1. Visit Power Platform Admin Center

  2. Navigate to Environments and select your default environment

  3. Click on Settings > Resources > Capacity

  4. Check if you have Dataverse (formerly CDS) and premium services enabled


Included in Microsoft 365 E3

  1. Power Apps (for Microsoft 365) – You can build and use canvas apps with standard connectors (e.g., SharePoint, Excel, Outlook).

    • Does not include premium connectors (Dataverse, SQL, SAP, etc.).

    • ❌ No access to standalone Power Apps environments.

  2. Power Automate (for Microsoft 365) – You can create automated workflows using standard connectors.

    • ❌ No RPA (Robotic Process Automation) or premium connectors.

  3. SharePoint Online Plan 2

    • Full SharePoint Online access with advanced features (eDiscovery, DLP, etc.).

    • ✅ Supports custom SPFx solutions, workflows, and integrations.

🔍 Limitations for Advanced Development

  • No Dataverse (Common Data Service)

  • No AI Builder or premium connectors

  • Limited Power Platform environments

  • No full-fledged Power Virtual Agents

🚀 Next Steps: What You Can Do

  1. For Full Power Platform Development

    • Sign up for a free Power Apps Developer Plan here

    • This gives you full Dataverse, premium connectors, and unlimited environments

  2. For Enterprise-Grade Development

    • If your org allows it, consider requesting Power Apps Per User Plan or Power Automate Premium

    • If you need RPA, Dataverse, or AI models, you may need additional licenses


Comparison: Power Apps Per User Plan vs. Power Automate Premium

FeaturePower Apps Per User PlanPower Automate Premium
PurposeDevelop and use unlimited appsBuild automated workflows, RPA, and integrations
Included AppsPower Apps (Canvas, Model-Driven)Power Automate (Cloud Flows, RPA, APIs)
Access to Dataverse✅ Yes✅ Yes
Premium Connectors✅ Yes✅ Yes
AI Builder Credits❌ No✅ Yes (AI-driven automation)
RPA (Robotic Process Automation)❌ No✅ Yes (Unattended & Attended bots)
API Requests per User/Day40,00040,000
Power Pages (Portals)✅ Yes (Limited use)❌ No
Best ForBuilding Power Apps with advanced connectors & DataverseAutomating processes, RPA, and AI-driven workflows
Ideal Use CaseIf you need to build enterprise appsIf you need advanced automation & RPA

Which One Should You Choose?

  • If you want to build and use advanced apps with Dataverse, get 👉 Power Apps Per User Plan

  • If you need automation, AI-based workflows, and RPA, get 👉 Power Automate Premium

Do You Need Both?

If you are building apps that require automation, you might need both plans. For example:

  • Power Apps to collect data from users.

  • Power Automate to trigger workflows, process approvals, or move data between systems.

---------------------------------------------------------------------------------------
Licensing Requirements for SharePoint Development

1. Included in Microsoft 365 Plans (No Additional License Needed)

If you are developing within your organization's SharePoint Online environment, Microsoft 365 E3 (which you already have) includes:
SharePoint Online Plan 2 – Full access for developing and managing SharePoint sites, lists, and document libraries.
Power Automate for Microsoft 365 – Basic automation with standard connectors (e.g., SharePoint workflows).
Power Apps for Microsoft 365 – Limited to canvas apps with standard connectors (no premium connectors like SQL, Dataverse).

🔹 2. Additional Licenses Needed for Advanced SharePoint Development

If you require advanced SharePoint customization, integrations, or automation, you may need:

RequirementLicense Needed
SPFx (SharePoint Framework) DevelopmentNo extra license (included in SharePoint Online Plan 2)
Power Apps using Premium Connectors (SQL, Dataverse, etc.)Power Apps Per User Plan
Advanced Power Automate Flows (Premium Connectors, RPA)Power Automate Premium
Dataverse for SharePoint-based appsPower Apps Per User Plan
AI-Based Document Processing (OCR, AI Builder in SharePoint)AI Builder Add-on
Power BI Embedded Dashboards in SharePointPower BI Pro / Premium
External User Access for Custom Apps in SharePointPower Pages (formerly Power Apps Portals)

💡 Key Takeaways

  1. For standard SharePoint development (SPFx, Lists, Sites, Workflows, Power Apps with standard connectors)Microsoft 365 E3 is enough.

  2. For apps using premium connectors (SQL, Dataverse, APIs) → You need Power Apps Per User Plan.

  3. For RPA, AI, or advanced Power Automate workflows → You need Power Automate Premium.

  4. For embedding Power BI reports in SharePoint → You need Power BI Pro.


Office 365 vs. Microsoft 365 for Enterprise – Key Differences & Comparison

Microsoft offers two major enterprise productivity suites: Office 365 and Microsoft 365. While they seem similar, Microsoft 365 is a more comprehensive solution that includes everything in Office 365 plus advanced security, device management, and Windows licensing.


🔹 1. Key Differences

FeatureOffice 365 (Enterprise)Microsoft 365 (Enterprise)
Included AppsWord, Excel, PowerPoint, Outlook, OneNote, SharePoint, Teams, OneDriveEverything in Office 365 + Advanced Security, Device Management, and Windows 11 Enterprise
Windows License❌ Not included✅ Windows 11 Enterprise (E3/E5)
Security & ComplianceBasic security (Email encryption, DLP, ATP in E5)✅ Advanced security (Defender, Identity Protection, Threat Analytics)
Device & App Management❌ Limited✅ Intune (Mobile Device & App Management)
Enterprise Mobility + Security (EMS)❌ Not included✅ Included (Azure AD Premium, Conditional Access, MDM, etc.)
Best ForOrganizations needing productivity apps & collaboration toolsEnterprises requiring security, compliance, and device management in addition to Office apps

🔹 2. Licensing & Plans Comparison

Office 365 Enterprise Plans (Focus: Productivity & Collaboration)

PlanCost (approx.)Features
Office 365 E1₹660/user/monthWeb-based apps, Teams, SharePoint, Email (50GB), OneDrive (1TB)
Office 365 E3₹1,760/user/monthE1 + Desktop apps, 100GB Mailbox, eDiscovery, DLP, Office Scripts
Office 365 E5₹3,070/user/monthE3 + Advanced security, Compliance, Power BI Pro, Analytics

Microsoft 365 Enterprise Plans (Focus: Productivity + Security + Windows)

PlanCost (approx.)Features
Microsoft 365 E3₹2,640/user/monthOffice 365 E3 + Windows 11 Enterprise + Intune + Azure AD Premium
Microsoft 365 E5₹4,630/user/monthMicrosoft 365 E3 + Advanced Security (Defender, Identity Protection) + Power BI Pro

🔹 3. Which One Should You Choose?

If You Need...Go for Office 365Go for Microsoft 365
Just Office Apps & Collaboration✅ Yes❌ No
Windows 11 Enterprise & Security❌ No✅ Yes
Cloud-based Security & Compliance❌ No✅ Yes
Device Management (Intune, MDM)❌ No✅ Yes
AI & Threat Protection (Defender, Azure Security)❌ No✅ Yes

🚀 Key Takeaways

  • Office 365 = Productivity & Collaboration (For businesses that just need Office apps and cloud tools like Teams, SharePoint, and Exchange).

  • Microsoft 365 = Office 365 + Security + Windows (For enterprises needing advanced security, compliance, and device management along with productivity tools).



Check from Microsoft 365 Account Portal

  1. Go to Microsoft 365 Admin Center.

  2. Sign in with your Microsoft account (work or school).

  3. Click on Your Info (top-right profile icon).

  4. Under Subscriptions, you’ll see your assigned license.

How to Delete Previous Versions in a SharePoint Document Library Using PowerShell

Managing document versions in SharePoint is crucial for maintaining an organized and efficient workspace. Over time, document libraries can ...