Yes, you can automate the process of updating an Excel file when a new item is added to a SharePoint list. You can achieve this by using Power Automate (formerly Microsoft Flow). Here’s a step-by-step guide to create a flow that updates an Excel file when a new item is added to a SharePoint list:
In order to detect documents missing required fields through Power Automate, you can follow these steps to create a scheduled flow that checks the metadata of the documents, identifies the missing required fields, and sends emails to the employee and their supervisor. 1. Create a Scheduled Cloud Flow 2. List the files in the Document
Upgrading from the outdated SharePoint 2013 to the advanced Microsoft 365 (M365) platform has become a crucial step since SharePoint 2013 extended support is ending on 11th April 2023. Migration to M365 not only enhances collaboration and productivity but also takes advantage of the latest security features and cloud capabilities. In this blog post, I’ll
So here is the list of PowerShell commands and hope it helps 🙂 but before we get started – it’s important to remember the following: Considerations before using PowerShell commands for SharePoint Online: Fifty PowerShell Commands
This is something which i had tried a couple of months back and I think it should still work but please do let me know if things have changed since I am writing this post after a few months. Step 1: Set up an Azure Account If you don’t already have an Azure account, you’ll
​Microsoft Office Excel files stored in deep Folder, sub-folder structures with long names often result in an error when they exceed the maximum file URL length of 218 characters. I wanted to proactively scan the entire SharePoint Online environment for Excel files with long URLs. Though i have found that up to 259 characters it
SQL or Structured Query Language is a standard language used to manage and manipulate relational databases. It allows users to create, modify, and retrieve data from databases. SQL is widely used by developers, analysts, and data scientists worldwide. This cheat sheet is designed to provide a quick reference for the most commonly used SQL statements.
Microsoft SharePoint and Teams are popular collaboration platforms used by organizations of all sizes to share files, communicate with team members, and manage projects. With so much critical data stored in these platforms, it’s essential to have a reliable backup and recovery plan in place. In this blog post, I’ll show you how to backup
A couple of months back, a friend of mine was facing an issue when it came to installing Kubernetes on Windows and honestly it took me some time to get things right. Thought I should share this in a blogpost so that others can also benefit and do not end up messing things. Step 1:
In order to setup Azure MFA as Primary Authentication with ADFS, this does require you to move to Azure MFA (cloud-based version). I have not deployed Azure Multi-Factor Authentication Server (on-prem/hybrid version) in a few years for anyone as pretty much everyone I work with has moved on to cloud-based Azure MFA. Feature parity is