Challenge: Recently, we faced the challenge of duplicating a SharePoint site schema, which included lists and libraries with lookup columns. The task was to replicate the structure of a site seamlessly, but there was no simple, automated way to do this using Power Automate. Handling lookup columns added extra complexity to the process. Solution: After exploring different options, we came up with a solution using Microsoft SharePoint internal http calls. By using the internal APIs, we were able to copy the lists, including their lookup lists, while keeping the relationships between the lists pr ..read more

Introduction: In this blog, we will demonstrate how to upload large files to a SharePoint document library from the SPFx web part, even when the file size exceeds 100MB or even reaches the GB range. SharePoint provides us with the REST API for uploading files to the document library. The API Is {site_url}/_api/web/getfolderbyserverrelativeurl('/sites/{site_name}/{library_name}')/file s/add(overwrite=true,url='{file_name}'). However, the issue is that this API only allows us to upload files up to 2MB in size. Any files larger than 2MB cannot be uploaded using this API.   Here I ..read more

Introduction: An intermittent bug refers to a bug that exists in the application but is difficult to reproduce.  This means that if you execute the same task twice, the behavior may differ each time.  It does not appear consistently, making debugging a herculean task. Any complex system or application, regardless of the underlying technology, may have intermittent bugs. Techniques to troubleshoot th intermittent bugs: 1. Document the bug by recording detailed information such as steps to reproduce, expected vs. actual results, error messages, and environment details to assist i ..read more

A new project has arrived on the table. The client’s requirements are ambitious, and the stakes are high. The first crucial decision awaits: choosing the right approach to guide the project to success. As we begin the evaluation, it becomes clear that the initial choice between methodologies will set the tone for the project’s journey. Should we follow a predictive, structured framework with meticulously planned milestones? Or is an adaptive approach more suitable, allowing flexibility and evolution with changing requirements? Let’s explore these choices and how they influence the process o ..read more

Introduction: SharePoint offers a robust out-of-the-box approval workflow for its lists, enabling efficient and controlled document and task management. This blog post will guide you through the process of setting up and utilizing this powerful feature. Setting Up List Approvals: 1. Create a New List:           a. Navigate to your SharePoint site's "Site Contents" page.           b. Click "Add a list" and select "Blank List".                     c. Give your list a suitable name ..read more

Introduction In SharePoint Online, automating operations in response to internal events — such as the creation of new site groups or granting permissions — can significantly streamline administrative tasks. This is particularly vital in environments with multiple associated sites where permissions need to be synchronized regularly. Here's how we can use SharePoint's OOTB events to improve operational efficiency and ensure timely updates across sites. Challenges in Synchronizing Permissions Consider a typical scenario in a SharePoint environment with one hub site and several associate sites. Wh ..read more

In the .NET ecosystem, there are many libraries that simplify common tasks, making the development process smoother and more efficient. In this post, we will explore three libraries that are indispensable in modern .NET applications: Automapper, FluentValidation, and BCrypt.Net. These libraries help with data mapping, validation, and security, respectively. 1. Automapper: Simplifying Object Mappings Automapper is a library that eliminates the need to manually map properties from one object to another. This is especially helpful when dealing with Data Transfer Objects (DTOs) or ViewModels ..read more

The SharePoint Brand Center is a centralized application designed for managing branding elements such as logos, colors, and fonts, making it easier for organizations to maintain consistent branding. It utilizes the SharePoint Organization Asset Library (OAL) for backend storage and management of these assets. The Brand Center app can be found on a specific site within your tenant. Important Considerations Before Activating the Brand Center: One Brand Center per Organization: SharePoint currently allows only one Brand Center for each tenant. All branding assets and font management will ..read more

Optimizing SQL queries is crucial for improving performance and readability in any database-driven application. In this blog, we will walk through key SQL query best practices, offering actionable tips to help developers write cleaner, faster, and more maintainable code. SQL (Structured Query Language) is the backbone of relational databases, enabling us to interact with data seamlessly. However, writing effective SQL queries isn't just about getting the right results; it's also about optimizing performance, ensuring scalability, and keeping the code readable for future developers. In this ..read more

Apache Airflow is an open-source platform for developing, scheduling, and monitoring batch-oriented workflows. Airflow’s extensible Python framework enables you to build workflows connecting with virtually any technology. A web interface helps manage the state of your workflows. Airflow is deployable in many ways, varying from a single process on your machine to a distributed setup to support even the biggest workflows. Airflow is used to author workflows as Directed Acyclic Graphs (DAGs) of tasks. The Airflow scheduler executes your tasks on an array of workers while following the spec ..read more