Ketan Sathavara's contributions

Introduction Microsoft SharePoint is widely used to store and manage business data using lists and document libraries. As an application grows, SharePoint lists can contain thousands of records. When a list contains more than 5,000 items, users may experience performance issues or encounter the List

Introduction Much of Excel work is repetitive: writing formulas, cleaning inconsistent entries, building pivot tables, and preparing the same report every month. Copilot in Excel lets you do these tasks by describing what you want in plain English. This article walks through 10 practical use cases.

Introduction Two Copilot features in Power Apps Studio can save a lot of time: Copilot for formulas and Proactive control rename . Both are in preview and are found under Settings → Updates → Preview . This article shows how to enable them and walks through a realistic example. Note: Microsoft says

Introduction In Microsoft Power Apps Canvas Apps, app-level formulas and properties help developers control application startup, navigation, error handling, screen sizing, themes, and other global behaviors. These properties are available by selecting the App object in the Tree view and choosing a p

Introduction The Respond to a PowerApp or flow action returns a value from Power Automate to Power Apps. It can be used to send a success or failure status after a flow completes its processing. Example: Return Success or Failed Status Suppose you have a flow that creates an item in a SharePoint lis

Introduction Microsoft Power Automate allows you to automate approval processes for business activities such as invoice approvals, leave requests, document reviews, and purchase requests. The Approval action helps you send approval requests to specific users and process their responses automatically

Introduction Microsoft Power Automate provides different loop actions to automate repetitive tasks. Two commonly used actions are Apply to Each and Do Until . Both actions repeat a set of steps, but they work differently. Apply to Each processes every item in a collection, while Do Until repeats act

Introduction The General tab in the Power Apps Settings pane controls how your app saves, retrieves data, starts up, and moves between environments. This guide explains its six settings, covering what each does, its default, and when to change it, so you can avoid slow apps, missing records, and deb

Introduction Microsoft Power Automate provides several SharePoint connector actions that help automate permissions for individual list items, folders, and files. These actions allow you to control who can access specific SharePoint content and whether they can view or edit it. In this article, we wi

Introduction When working with large datasets in Power Automate , you may notice that an action such as SharePoint – Get items or Dataverse – List rows does not return all available records. This happens because connectors can have default retrieval limits. Pagination helps Power Automate retrieve a

Introduction Microsoft Power Automate provides run history to help developers monitor workflow execution, troubleshoot errors, and validate the data passed between actions. However, this run history can also expose sensitive information, such as customer email addresses, confidential business detail

Learn how to use Filter array, Select, and Join in Power Automate to filter records, reshape fields, and combine array values into text.

When a Power Apps Canvas App works with a large number of records, displaying everything at once can make the application difficult to use and may affect performance. Pagination provides a simple solution by dividing records into smaller pages, such as 25 records per page , and allowing users to nav

Learn how to enable, view, configure, and restore version history for SharePoint files and list items, including major and minor versions, recycle bin recovery, and best practices.

Troubleshoot Power Automate 401 Unauthorized errors after DEV-to-PROD deployment by checking connection references, authentication, permissions, APIs, and DLP policies.

Learn how to use Power Automate to retrieve, filter, and count SharePoint Recycle Bin items with HTTP requests, Filter array, and length().

Learn the difference between Filter Query and Filter Array in Power Automate, including performance, SharePoint filtering, OData queries, and best practices.

Learn how to make Power Automate trigger input parameters optional and handle blank values using conditions and expressions for flexible, reusable flows.

Learn how to add multiple users to a SharePoint Group in one Power Automate HTTP request using the SharePoint REST API, reducing API calls and simplifying permissions.

Learn how to rename SharePoint Online folders with Power Automate using the SharePoint REST API, FileLeafRef, MERGE requests, dynamic names, and folder IDs.