This tutorial will teach you how to create an Interactive report to analyze user activities across different M365 products like SharePoint, Power App, Power Automate, One drive, and more. There are some other tips/tricks that you will learn and can use in other reports. #sharepoint #powerapps #powerautomate #powerbi #auditreport
This video is a step-by-step tutorial on how to create a fully dynamic and configurable Power Apps Paginated Gallery. You can apply this method to a new or an existing app. You will learn: 1) How to Send JSON response from flow to Power Apps 2) Create fully configurable and dynamic Pagination in Power Apps […]
In this video , you will learn what is Microsoft SQL connector. How to create a new connection and use it in Power Apps and Power Automate. You will also learn what Authentication type you should select to use Microsoft SQL Server securely with Power Apps. A connection to SQL Server is created whenever you […]
In this tutorial, I will show you how you can use Power Automate to provision a SharePoint online site, including saving site script, site design, creating a site, and applying site design. You will learn: 1. What is SharePoint site script/Site design/Template 2. How to create a site script from any SharePoint online site 3. […]
Friends, In this beginner tutorial, you will learn how to create a Calendar in Power Apps. I will also show you how you can connect any gallery data to the Calendar view. Chapters: 0:00 Introduction 0:27 Demo 2:12 Create Calendar 14:30 Show Gallery data on Calendar 23:26 Show item Form from Calendar Reference to gallery […]
In this video, I will show how to create a fully dynamic Navigation Menu Component. We will go through a step-by-step walkthrough of building dynamic PowerApps Navigation Menu Component that can be used as Left Navigation, Top Navigation, and footer navigation. You can use this approach to build navigation in the canvas app without components. […]
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 […]
In this video, I will demonstrate how to share a canvas power app with internal or External users. I will also show how different types of data connection and data sources are shared, what different options are available. I will show how you can share the following apps internally or externally: 1) App with SharePoint/One […]
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. […]
Hello Friends, In this video, I will teach how to avoid rework when working on Power Automate by creating a reusable flow. You will learn: 1) What is Reusable flow 2) What is Child flow 3) How to create a Child flow 4) How to call a Child flow Video reference: https://youtu.be/m1wYjAyJ_YU Further learning: Power […]
#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 […]
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: […]
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. […]
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 ) […]
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/
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 […]
In This video, I will show how you can build Power BI Report and Dashboard from Dataverse Table using DirectQuery or Import mode. I will show : How to connect to Dataverse Table How to create a Report How to publish the report as channel tab How to add the report to Power Apps Add […]
Hello, In this video, I will show you how to create Planner Tasks from Excel using Power Automate automatically. You will learn: How to create Tasks from Excel How to create a Checklist from Excel How to update Tasks and Checklists Thanks for watching. Reference material: https://docs.microsoft.com/en-us/connectors/planner/
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 […]
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 […]
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.
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 […]
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 […]
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 […]
2. Use Open API (Swagger) in Azure API Management for Power Apps and Power Automate 3. External API in Azure API Management for Power Apps and 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 […]
Hello everyone. In this video, you learn how to Copy Items or Files between SharePoint Sites in different Tenants using Power Automate. I will share a simple step-by-step approach to creating flow in the source or destination tenant. #PowerAutomate #SharePoint #Copy file
This video tutorial will teach you how to send an array or JSON response from Power Automate to Power Apps without using any premium connector. I will use a use-case to create a power app that will show all the SharePoint groups and users inside each group. Apply the same logic to any other response […]