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.

Tuesday, March 18, 2025

NSA ATC communication flow + power Automate

 






Automation Engineer - Essential setup, tools, software, and environment

 To work as an Automation Engineer (focusing on Open Source and Power Platform) as an individual contributor in roles like Developer, Solution Architect, and Delivery Person, you'll need a comprehensive setup covering development, testing, deployment, and monitoring. Below is a structured list of the essential setup, tools, software, and environment you'll need:


βœ… Setup and Environment

1. Hardware Setup

  • Laptop/PC – Minimum specs:
    • CPU: Intel i7 or equivalent
    • RAM: 16 GB (32 GB preferred)
    • SSD: 512 GB+
    • Graphics: Not critical, but a dedicated GPU helps with AI/ML workloads

2. Operating System

  • Windows 10/11 or Linux (Ubuntu) – Dual boot if required
  • Virtual Machines (Optional): VMware or VirtualBox for testing
  • Containers: Docker and Kubernetes for containerized deployment

πŸš€ Development Tools

1. IDE/Editors

  • Visual Studio Code – (for both open-source and Power Platform)
  • Visual Studio – (for Power Platform development)
  • Eclipse/IntelliJ – (if Java is involved)
  • Postman – (API testing)

2. Scripting and Automation Languages

  • PowerShell – For automating Windows tasks and Power Platform
  • Python – For automation, data processing, and AI
  • JavaScript – For Power Platform custom connectors and UI
  • Bash – For Linux-based automation

3. Version Control

  • Git – (GitHub, GitLab, Bitbucket)

🌐 Open Source Automation Tools

1. RPA (Robotic Process Automation)

  • UiPath Community Edition – Widely used for automation
  • OpenRPA – Open-source RPA tool
  • TagUI – Open-source CLI-based automation

2. CI/CD (Continuous Integration/Continuous Deployment)

  • Jenkins – Open-source automation server
  • GitHub Actions – For automating builds and releases
  • Ansible – Infrastructure automation

3. Testing

  • Selenium – For web-based automation
  • Appium – For mobile automation
  • PyTest – For Python-based testing

πŸ† Power Platform Tools

1. Power Automate – Workflow automation

2. Power Apps – App development

3. Power BI – Business Intelligence and reporting

4. Data verse β€“ Data management

5. Custom Connectors – For extending Power Platform capabilities


🌍 Database and Storage

1. Open Source

  • MySQL – Relational database
  • PostgreSQL – Advanced relational database
  • MongoDB – NoSQL database

2. Microsoft Stack

  • SQL Server – For Power Platform integration
  • SharePoint – For file and data storage

πŸ”’ Security and Compliance

  • OAuth 2.0 / SAML – Authentication protocols
  • Microsoft Defender – Security monitoring
  • Azure Active Directory (AAD) – User access control

πŸ“’ Deployment and Monitoring

  • Docker – For containerized deployment
  • Kubernetes – For scaling
  • Prometheus – For monitoring
  • Grafana – For data visualization
  • Azure DevOps – For pipeline management and monitoring

🧠 AI and ML Integration (Optional)

  • OpenAI API – For language models and automation
  • TensorFlow / PyTorch – For AI/ML development
  • Hugging Face – For NLP tasks

🎯 Documentation and Collaboration

  • Confluence – For internal documentation
  • Notion – Personal productivity and notes
  • MS Teams / Slack – For team collaboration
  • Jira – For task and project management

πŸ’‘ Other Useful Tools

  • Fiddler – For network traffic debugging
  • Insomnia – API client
  • Power Toys – Productivity enhancements for Windows

βœ… Summary

You'll need a mix of open-source and Power Platform tools to cover automation, development, testing, deployment, and monitoring.

  • Open Source: Python, Selenium, Jenkins, Ansible
  • Power Platform: Power Apps, Power Automate, Power BI
  • Monitoring & Deployment: Docker, Kubernetes, Azure DevOps
  • Security: OAuth, Microsoft Defender

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