Excel Automation with Office Scripts and Power Automate

In this video, I will show you how to automate Microsoft Excel repetitive work using an Office Script with Power Automate. What is Office Scripts: Office Scripts in Excel on the web let you automate your day-to-day tasks. You can record your Excel actions with the Action Recorder, which creates a TypeScript language script. You […]

Read More

How to use Microsoft Graph API in Power Automate – Beginner Tutorial

Microsoft Graph is the gateway to data and intelligence in Microsoft 365. It exposes REST APIs and client libraries to access data on the following Microsoft cloud services: 1) Microsoft 365 core services: Bookings, Calendar, Delve, Excel, Microsoft 365 compliance eDiscovery, Microsoft Search, OneDrive, OneNote, Outlook/Exchange, People (Outlook contacts), Planner, SharePoint, Teams, To-Do, Workplace Analytics. […]

Read More

Create Dynamic Microsoft Form and Process Response using Power Automate

#Microsoftform #PowerAutomate #DynamicForm In this video, I will show how to create a dynamic (conditional) Microsoft Form using section and branching. I will use a Product feedback use case to demonstrate the concept and step by step tutorial. I will also show how to process the Form response, including multi-select choice, attachments, etc. this will […]

Read More

PowerApps Progress Indicator (#Responsive and #Dynamic)

Hello Friends, In this video i will show you how you to create a fully configurable and responsive Progress Indicator component. You can also download prebuild Progress Indicator component from here: https://github.com/DeepakS22/DPowerApps/blob/master/DynamicProgressIndicator.msapp Thanks again for watching. Don’t forget to subscribe and click on the notification bell. Connect with me Twitter: @deepak_s22 zWebsite: https://www.deepakshrivastava.com Facebook Page: […]

Read More

Turn on Power Automate Flow Automatically

Hello, Do you have a Power Automate production flow that getting turned off automatically because of no activity? In this video, I will show you how you can create a flow that will automatically turn on the turned-off flow. Reference: https://docs.microsoft.com/en-us/power-automate/limits-and-config#expiration-limits Thanks again for watching. Don’t forget to subscribe and click on the notification bell. […]

Read More

Power Automate Microsoft Word Connector (Automated Invoice generation solution)

Do you wish to update a word template using Power Automate word connector automatically? In this video, I will show you a step-by-step process to build an Invoice generation solution using Power Automate word connector and SharePoint. Link to Power Automate Flow: https://github.com/DeepakS22/DPowerAutomate/blob/master/GenerateInvoice_DS_20210706213438.zip Thanks again for watching. Don’t forget to subscribe (here and YouTube ) […]

Read More

Power Apps Accordion Gallery (Expand/Collapse Gallery)

This video will show you how you can create an Accordion (Expand Collapse behavior) in Power Apps Gallery using simple formulas. This video will cover how to build a expand/collapse behavior for gallery items Add a gallery inside a gallery with accordion behavior Thanks for watching. Connect with me Twitter: @deepak_s22 Facebook: https://www.facebook.com/Deepak-Shrivastava-108032534706197/

Read More

Working with XML in Power Automate Flow

Hello friends, In this video, I will show you how you can parse XML in Power Automate The first half of the video will cover how to extract the data and push that XML data to a SharePoint list The second half of the video will cover how to filter XML data and send an […]

Read More

Power Apps for SharePoint Document Library

In this video, I will show how to create a Power App for SharePoint Document Library. I will also show you how to avoid delegation warnings to work with SharePoint Document Library with more than 2000 documents. We will create a folder breadcrumb to access previous folders easily. I will also show how to upload […]

Read More

Power Apps Dynamic Form – SharePoint List Content Types

This video will show you multiple ways to create a dynamic Power Apps form for SharePoint List that uses multiple content types. In PowerApps, we don’t have any method to check what all the columns belong to a content type. Watch this entire video to learn how you can get/query all the content types belonging […]

Read More

Power Apps Print Screen

In this tutorial video, I will show how to Print any screen in Power Apps using the new Power Apps Print() function. Printing has been one of the most requested features for a long time. I have created this video to showcase the current capabilities of this feature with a few use cases.

Read More

Power Automate Date Time Operations

In this video, you will learn 7 key DateTime action/expression available in power automate. How to convert time zone How to format DateTime How to Add to /subtract from DateTime How to compare dates How to calculate DateTime difference How to check weekends Excel DateTime Reference Information: Ticks: Ticks per day 864,000,000,000 Ticks per hour […]

Read More

Power Apps Alert/Notification Component

In this video you will learn how to create a Power Apps Component tp show an alert message in your Power App. You can display the following four alert messages: 1) Confirmation 2) Error 3) Notification 4) Announcement This component is straightforward to use with the following exposed properties: 1) Show Alert – Set the […]

Read More

Improve Power Automate Performance using SharePoint $batch

In This video learn how you can batch queries and operations against the REST/OData API of Microsoft SharePoint Online and the Files and folders subset of the Office 365 REST APIs. With this technique, you can improve the performance of your Power Automate Flow by combining many operations into a single request to the server […]

Read More

Realtime Power BI report with sharepoint data using power automate

Often we have a requirement to create a real-time power report for SharePoint data. but, when we connect to SharePoint list data from Power BI, the only option we have is to use import query mode instead of the direct query. This method only allows the data refresh up 8 times per day with Power […]

Read More