Power Automate Adv W/Forms, Json, Power Bi & Adobe Sign

Use PA Advanced and integrate with Power BI, MS Forms and Adobe Sign using JSON, creative expessions & Data Operators.

What you'll learn

Select either automated or scheduled flows in Power Automate to implement an appropriate automation approach based on business needs.

Manipulate JSON (JavaScript Object Notation) data structures.

Leverage advanced functions within Flow expressions in Power Automate.

Utilize Microsoft Forms as a trigger in Power Automate.

Process file uploads from Microsoft Forms within Power Automate.

Implement end-to-end automation solutions for Power BI dataset refreshes.

Automate Adobe Sign workflows using Power Automate.

Explore the process of creating complex robotic process automation (RPA) tasks using Power Automate Desktop.

Requirements

Taking the Power Automate Foundations course would be required.

O365 E5 License that allows you to use Power Automate, MS Forms and OneDrive.

Having a SharePoint site with Owner permissions to create lists is required.

Have Power BI Installed if you wish to participate in Section 7.

Have license for Adobe Sign if you wish to participate in Section 8.

Have Power Automate Desktop if you wish to participate in Section 9.

Description

Enrolling in an advanced Power Automate course is a transformative step for individuals seeking to become experts in the realm of workflow automation and process optimization. In this dynamic program, students will delve deep into the capabilities of Microsoft Power Automate, gaining the knowledge and proficiency needed to streamline business operations and enhance productivity.Throughout the course, students will explore advanced techniques for designing intricate workflows, harnessing the power of connectors to seamlessly integrate a plethora of apps and services, both within and outside the Microsoft ecosystem. They will learn to create complex, multi-step workflows with conditional logic, error handling, and parallel processing, enabling them to automate even the most intricate business processes.Additionally, students will delve into data manipulation and transformation, using expressions and functions to transform and manipulate data from various sources, making it actionable and insightful. By the end of the Power Automate advanced course, participants will emerge with the expertise to architect, implement, and manage highly efficient and effective automated processes, empowering their organizations to achieve new levels of efficiency and agilityIf you have taken my Power Automate Foundations course then you are ready to take your automate skills to the next level and learn how to create automated / scheduled flows and interact with the popular products such as MS Forms, Power BI and Adobe Sign!Your InstructorRobin Solonenko

Overview

Section 1: Introduction

Lecture 1 Course & Instructor Info

Lecture 2 Support Notes for Students

Lecture 3 What Software(s) you need for this course

Lecture 4 Download Course Files & PDF Manual & Software

Lecture 5 Contacting the Instructor

Lecture 6 Let's Set Some Expectations

Lecture 7 PDF Manual & Video Correlation

Section 2: Automated vs Scheduled Flows

Lecture 8 Automated Outlook Flows

Lecture 9 Automated SharePoint Flows

Lecture 10 Creating Scheduled Flows

Lecture 11 Section 2 / Chp 1 Exercise

Section 3: Understanding JSON

Lecture 12 What is JSON?

Lecture 13 Objects, Properties, Arrays & Parsing

Lecture 14 Data Operations

Lecture 15 Section 3 / Chp 2 Exercise

Section 4: Functions in Flow Expressions

Lecture 16 Flow Expressions & Functions

Lecture 17 Set, Add, Remove Property in Expressions

Lecture 18 Working with Dates

Lecture 19 Logical, Workflow & String Functions

Lecture 20 Section 4 / Chp 3 Exercise

Section 5: Connecting to MS Forms

Lecture 21 What is MS Forms?

Lecture 22 Creating Forms

Lecture 23 Using the Forms Trigger

Lecture 24 Section 5 / Chp 4 Exercise

Section 6: Working w/ File Uploads within MS Forms

Lecture 25 Approving Attachments via Forms

Lecture 26 Approving Multi-Attachments via Forms

Lecture 27 Create Form Menus in SharePoint

Lecture 28 Section 6 / Chp 5 Exercise

Section 7: Automating Power BI Datasets

Lecture 29 What is Power BI?

Lecture 30 Adding Rows to Streaming Datasets

Lecture 31 Run a Query Against Dataset

Lecture 32 Refreshing a Dataset

Lecture 33 Section 7 / Chp 6 Exercise

Section 8: Adobe Sign Automation

Lecture 34 Adding Input Fields into Word Doc

Lecture 35 Creating the Input Form

Lecture 36 Building the Adobe Sign Flow

Lecture 37 Cleaing up Your Docs

Lecture 38 Section 8 / Chp 7 Exercise

Section 9: Intro to RPA Automated Desktop

Lecture 39 What is RPA Automated Desktop?

Lecture 40 Installing Automated Desktop

Lecture 41 Desktop Environment

Lecture 42 Your First Desktop Flow

Lecture 43 Section 9 / Chp 8 Exercise

Section 10: Power Automate Project

Lecture 44 Power Automate Project

Lecture 45 Instructor Thank You

Anyone who needs to automate a business workflow such as approvals.,Those students who already took my Power Automate Foundations course and is ready for more advanced topics.,Those who want to integration Power Automate and Adobe Sign.,Those students who wish to automate their data collection process with forms.