Name: Build Offline PowerApps @DanielChristian19
Uploaded: 2024-05-04T08:17:00-05:00
Duration: 8 min 17 s
Description: Build Offline PowerApps

Build Offline PowerApps

Daniel Christian 2024-05-04 | Build Offline PowerApps

Power Virtual Agents Built-in Entities

Daniel Christian 2022-11-21 | Power Virtual Agents Built-in Entities

Hey Everyone,
In this video we will take a look at the built-in entities already available in Power Virtual Agents that will help improve the interaction your chatbot has with users. The key items I will focus in this video are:

- Person Name
- Email
- Date and Time
- Age

Table of contents
Introduction 0:00
Create a new bot 01:05
Create a new topic 02:20
Person Name 03:02
Email 07:51
Date and Time 10:52
Age 13:42
Conclusion 17:06

Helpful link(s)
Why fill a form when you can chat with a bot? https://youtu.be/JTVJaDqXmSk

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

Power Virtual Agents New Features

Daniel Christian 2022-11-14 | Power Virtual Agents New Features

Hey Everyone,
Power Virtual Agents new advanced authoring canvas is currently in public preview! In this video I'll demonstrate what these new features are. We first take a look at the overall new design changes, then we look at the enhancements in the messages and controls focusing on the basic and adaptive cards. I then switch gears and show you the Power Fx functions available. I finally end with topic management and the unified canvas design.

Table of contents
Introduction 0:00
New Design Changes 1:17
Enhanced Messages & Questions 08:39
- Add an image in a message10:09
- Add a video in a question 11:55
- Add a basic card 12:45
- Add an adaptive card 14:47
Power Fx
- Power Fx set variable 17:10
- Power Fx condition 21:03
Topic Management 27:44
Unified canvas design 30:05
Conclusion 31:13

Helpful link(s)
https://powervirtualagents.microsoft.com/en-us/blog/now-in-public-preview-power-virtual-agents-new-advanced-authoring-canvas/
https://powervirtualagents.microsoft.com/en-us/blog/whats-new-the-evolution-of-power-virtual-agents/
https://adaptivecards.io/samples/ExpenseReportWithLabels.html

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerVirtualAgents #Chatbot #PowerFX #UnifiedCanvasDesign #AdaptiveCard

Why Fill a Form When You Can Chat with a Bot?

Daniel Christian 2022-11-07 | Why Fill a Form When You Can Chat With a Bot?

Hey Everyone,
In this video, we'll take a look at how we can build a chatbot using Power Virtual Agent to help users fill a form.
The example I have is a user requiring assistance to fill a job application and how the chatbot can provide guidance. This is one of those many scenarios where you have a simple form that needs to be filled and having a chat with a bot makes things so much easier.

Table of contents
Introduction 0:00
Scenario with form 01:00
Overview of the environment 01:36
Adding the trigger phrases 02:20
Modify the greeting topic 03:50
Building the new topic 05:27
Building the flow 17:28
Final testing 25:24
Conclusion 29:15

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerVirtualAgents #Chatbot #PowerAutomate #Automation

How to Use Power Automate to Enhance Microsoft Syntex

Daniel Christian 2022-10-31 | How to Use Power Automate to Enhance Microsoft Syntex

In my previous video, I introduced Microsoft Syntex and ended with a demo on how I use the OneDrive mobile app to scan receipts which are saved in a document library that has the model associated with it. In this video I'll walk you through how I built a Power Automate flow to monitor the accuracy of this receipts metadata and to send me an email notification if incase one of them is below my satisfaction

Table of contents
Introduction 0:00
Overview the content center 01:09
Overview the receipts library 02:00
Two columns for the flow 03:31
Overview of the defective library 06:08
Overview of the Power Automate flow 08:32
Building the Power Automate flow 09:20
- GET Odata Query 09:55
- 1st condition 11:56
- Move the defective files 17:36
- 2nd condition 23:42
Make a guestimate 30:43
Initial Testing 31:47
Get the time stamp and update flow 33:22
Final Test 36:24
Conclusion 37:26

Helpful link(s)
Introduction to Microsoft Syntex - https://youtu.be/rkCIv2YuZO8
https://techcommunity.microsoft.com/t5/microsoft-syntex/introducing-microsoft-syntex-content-ai-in-the-flow-of-work/ba-p/3651987
https://www.microsoft.com/en-us/microsoft-365/enterprise/sharepoint-syntex-overview
https://ignite.microsoft.com/en-US/sessions/c57ea881-c3cd-4d06-81c3-17355f4c9490
https://learn.microsoft.com/en-us/microsoft-365/contentunderstanding/difference-between-document-understanding-and-form-processing-model
https://support.microsoft.com/en-us/office/introduction-to-content-types-and-content-type-publishing-e1277a2e-a1e8-4473-9126-91a0647766e5

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrosoftSyntex #PowerAutomate #SharePointSyntex #AI #DocumentProcessing

Introduction to Microsoft Syntex

Daniel Christian 2022-10-24 | Introduction to Microsoft Syntex

This is an introduction video to Microsoft Syntex which used to be called as SharePoint Syntex. We start by looking at its history back when it was part of Project Cortex and how it transformed. I then switch gears and talk about how it utilizes SharePoint Content types, spent a few minutes explaining content types as well. Next, I talk about the pre-built and the custom model options available and the differences. Finally, I end with a demo on how I use the pre-built receipts model for my day-to-day activities. This is the first of many more videos on this topic.

Table of contents
Introduction 00:00
Project Cortex 01:39
SharePoint Syntex 02:51
Microsoft Syntex 04:06
- What is Microsoft Syntex? 05:09
- Two mode types 05:48
Model Content Type 06:36
- SharePoint content type 07:11
Pre-built and custom models 10:14
Demo 13:43
-Scanning receipts using OneDrive app 21:14
Upcoming features announced at Ignite 26:00
Big thank you 26:37
Conclusion 27:17

Helpful link(s)
https://techcommunity.microsoft.com/t5/microsoft-syntex/introducing-microsoft-syntex-content-ai-in-the-flow-of-work/ba-p/3651987
https://www.microsoft.com/en-us/microsoft-365/enterprise/sharepoint-syntex-overview
https://ignite.microsoft.com/en-US/sessions/c57ea881-c3cd-4d06-81c3-17355f4c9490
https://learn.microsoft.com/en-us/microsoft-365/contentunderstanding/difference-between-document-understanding-and-form-processing-model
https://support.microsoft.com/en-us/office/introduction-to-content-types-and-content-type-publishing-e1277a2e-a1e8-4473-9126-91a0647766e5
Joanne C Klein - https://joannecklein.com/
Treb Gatte - https://marqueeinsights.com/

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrosoftSyntex #SharePointSyntex #AI #DocumentProcessing

Why Use Yammer As An Enterprise Level Social media Platform?

Daniel Christian 2022-10-17 | Why Use Yammer As An Enterprise Level Social media Platform?
Do you ask yourself (or your team) the question why I should consider using Yammer when we already have Teams? If you do, then this is the video for you. Yammer is not going again and that Microsoft is investing more in enhancing this service.

In this video, I go through some technical differences between Teams and Yammer that you need to be aware and also end with my take on the differences.

Table of contents
Introduction 0:00
Fundamental differences between Teams and Yammer 01:19
Inner and outer loop explanation 02:06
Technical differences between Teams and Yammer 04:19
Yammer Storyline for user-level social media option 10:49
My take on Teams and Yammer 12:22
Conclusion 13:41

Helpful link(s)
What is Yammer - https://support.microsoft.com/en-us/office/what-is-yammer-1b0f3b3e-89ee-4b66-aac5-30def12f287c
What is Teams - https://support.microsoft.com/en-us/topic/what-is-microsoft-teams-3de4d369-0167-8def-b93b-0eb5286d7a29

https://learn.microsoft.com/en-us/microsoftteams/limits-specifications-teams
https://learn.microsoft.com/en-us/office365/servicedescriptions/yammer-service-description/yammer-limits
https://techcommunity.microsoft.com/t5/microsoft-teams-blog/notifications-from-yammer-communities-are-now-available-in/ba-p/2080589

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#Yammer #EnterpriseSocialMedia #Teams #VivaEngage

Power Apps Visual For Power BI

Daniel Christian 2022-10-10 | Power Apps visual for Power BI

Hey Everyone,
In this video we'll take a look at the enhancement to the Power BI Integration function in Power Apps.

Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which updates in real time as you make changes to your report. Now, your app users can derive business insights and take actions from right within their Power BI reports and dashboards.

Table of content(s)
Introduction 0:00
Demo 01:26
DirectQuery Connections 02:15
Power BI Desktop version 03:01
Add the SQL connection 03:29
Page View design & Slicer visualization 05:43
Adding the Power Apps visualization 08:41
- Create the app first with the design you want 08:55
- Select the fields for the canvas app 11:05
Start designing the canvas app 13:00
Publish the report 14:14
Finish the canvas app build 16:14
Final test 29:09
Final thoughts 29:59
1) Permissions 30:04
2) SQL table primary key 30:28
Conclusions 31:19

Helpful link(s)
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/powerapps-custom-visual
https://learn.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerBI #PowerApps #PowerBIIntegration

Modify Power Apps and Power Automate due to SharePoint List Permissions - Real World Scenario

Daniel Christian 2022-10-03 | Modify Power Apps and Power Automate due to SharePoint List Permissions - Real World Scenario

Hey Everyone,
In this video I'll walk you through a canvas app I had to build using SharePoint lists as the backend data source. The app was used to give a coupon that was made available for the company employees by a vendor. Since the coupons were in limited quantity it was a first-come-first-serve basis and hence they wanted a way to automate this process and also keep track of who got what. This involved customized SharePoint list permissions so that users can only see what they need to.

In this video I'll walk you through a real-world scenario of how the app was built originally but it didn't work as planned due to the behavior of the Power Apps permissions. Hence some of the functionality had to be moved to Power Automate.

Table of contents
Introduction 0:00
SharePoint Lists 01:15
Situation #1 02:45
Situation #2 11:22
Side-by-side comparison of flows 18:30
Side-by-side comparison of apps 20:19
Conclusion. 21:11

Helpful link(s)
- How SharePoint List Permissions Apply to Power Apps - https://youtu.be/Fxu6LIb_D24
- Tightening the SharePoint List Permissions for Power Apps - https://youtu.be/qpVGdFHs43k

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #PowerAutomate #SharePoint #Permissions #Lists

Top 10 Announcements at the Power Platform Conference

Daniel Christian 2022-09-26 | Top 10 Announcements at the Power Platform Conference

Hey Everyone,
In this video, we'll take a look at my top 10 announcements that were made in the Microsoft Power Platform Conference in Orlando, Florida, USA from October 18th to the 23rd of 2022.

Table of contents
Introduction 0:00
1 Coauthoring in Power Apps 01:04
2 Cards for Power Apps 02:03
3 Maker matching with integrated virtual agent in Power Apps 03:36
4 SAP connectors and templates 04:48
5 Automation COE toolkit 05:34
6 Power Up program 06:36
7 New features and improvements 07:53
8 Native export to PDF 08:31
9 More enhancements 09:30
10 2023 Microsoft Power Platform Conference 10:56
Conclusion 11:53

Helpful links
https://powerplatformconf.com/
https://powerapps.microsoft.com/en-us/blog/power-apps-brings-collaboration-to-center-stage-with-3-big-announcements/
https://powerautomate.microsoft.com/en-us/blog/introducing-the-automation-kit-for-power-platform/
https://powerup.microsoft.com/

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #PowerAutomate #powerbi #powervirtualagents #MPPC2022

Microsoft Viva Engage and Yammer Storyline in Public Preview

Daniel Christian 2022-09-19 | Microsoft Viva Engage and Yammer Storyline in Public Preview

Hey Everyone,
Yammer Storyline feature is now in Public Preview which means you can start to test it and experience it's features first-hand. However, before you do, take a look at this video to understand how the enablement of the Storyline preview works and where all is your information stored.

Table of contents:
Introduction 00:00
Manage Storyline public preview access 00:39
Turning on the Storyline preview feature 01:17
Review storyline feature in Yammer 03:25
Review storyline feature in Teams 05:08
Review Yammer and Teams from mobile apps 05:54
Key items about the preview feature 07:38
Conclusion 09:19

Helpful link(s)
- Manage storyline for Microsoft Viva Engage and yammer - https://docs.microsoft.com/en-us/Yammer/configure-your-yammer-network/manage-storyline-viva
- Yammer administrator role in Azure AD - https://youtu.be/lzOKGQzyDR4
- Microsoft Viva Engage - https://youtu.be/gBJeYr6h2SY

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#Yammer #YammerStoryline #VivaEngage #MicrosoftViva #MicrosotTeams

Power Apps Racing Scoreboard Canvas App - Part 2

Daniel Christian 2022-09-12 | Power Apps Racing Scoreboard Canvas App - Part 2

Hey Everyone,
Due to popular demand, I have released a part 2 version of the 'Power Apps Racing Scoreboard Canvas App'. This video starts with me showing an enhancement I had to recently add which is the countdown timer.

I then focus on the backend data sources and the Power Automate flow. We have a SharePoint list which keeps track of all the scores that are added by team leaders. We then have a flow that runs once a day to count the individual scores and add the sum value to a another list which is referred to by the app.

As a bonus, I show you have to add items in bulk to a SharePoint list.

Table of contents
Introduction 0:00
Recap of the app 01:02
New enhancement - Countdown timer 01:31
SharePoint lists 07:38
Power Automate flow 14:53
Conclusion

Helpful link
- PowerApps Racing Scoreboard App - https://www.youtube.com/watch?v=YbevctHiIIw

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #PowerAutomate #SharePoint #ScoreboardApp #CanvasApp #AnimationApp

Microsoft Forms: Send a form directly to multiple channels and set time duration

Daniel Christian 2022-09-05 | Microsoft Forms: Send a form directly to multiple channels and set time duration

Hey Everyone,
Microsoft Forms has released new feature where you can send a form directly to multiple channels such as Outlook and Teams AT THE SAME TIME and keep track on the responses. In addition, you can now set a limit for the allowed time to fill the form.

In this video I'll demonstrate how that works.

Table of contents
Introduction 0:00
Announcement 0:50
Closer look at collect responses 01:26
How the notifications appear in Teams 04:47
How the notifications appear in Outlook 06:35
One response per person setting 07:07
Troubleshoot mailbox settings 10:00
Set time duration 13:19
Conclusion 17.12

Helpful link(s)
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/sending-a-form-directly-to-multiple-channels-at-the-same-time/ba-p/3613357
https://docs.microsoft.com/en-us/microsoft-365/admin/email/remove-license-from-shared-mailbox?view=o365-worldwide

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrosoftForms #MultipleChannels #Forms #Microsoft365

Microsoft Viva Engage

Daniel Christian 2022-08-29 | Microsoft Viva Engage

Hey Everyone,
In this video we'll take a closer look at Microsoft Viva Engage which is now generally available. We'll also do a side-by-side comparison of the existing (Yammer) Communities app in Teams with Viva Engage.

Table of contents
Introduction 0:00
Viva Engage is now generally available 0:40
Viva Engage in Teams 1:50
Compare Yammer Communities with Viva Engage 3:43
Demo current Viva Engage in Teams 6:21
Conclusion 13:12

Helpful link(s)
https://techcommunity.microsoft.com/t5/microsoft-viva-blog/microsoft-viva-engage-is-now-generally-available/ba-p/3595300
https://techcommunity.microsoft.com/t5/yammer-blog/introducing-viva-engage/ba-p/3571377
https://techcommunity.microsoft.com/t5/yammer-blog/viva-engage-is-here/ba-p/3606594
https://support.microsoft.com/en-au/topic/getting-started-with-microsoft-viva-engage-729f9fce-3aa6-4478-888c-a1543918c284
https://adoption.microsoft.com/en-us/yammer/#viva-engage
https://techcommunity.microsoft.com/t5/yammer-blog/are-you-ready-for-viva-engage-10-ways-yammer-customers-can-get/ba-p/3583645

#VivaEngage #MicrosoftViva #MicrosotTeams #VivaEngageInTeams

Power Apps Racing Scoreboard Canvas App

Daniel Christian 2022-08-22 | Power Apps Racing Scoreboard Canvas App

Hey Everyone,
In this video, I'll do a deep-dive of a recent canvas app I had to build to display the score of a fun, rivalry competition amongst various teams. The app has some fun animation in it and the data source for this app is a SharePoint list.

The canvas app uses a combination of gallery, timer control and slider controls. In addition it uses the x and width property of the image control used for the animation.

Table of contents
Introduction 0:00
Demo 0:55
SharePoint list 1:57
Overview of the finished app 3:22
Building the gallery from scratch 6:15
Adding the slider control 9:42
Adding the timer control 11:15
Adding the slider properties 11:55
Finishing touches 22:54
Conclusion 25:50

#PowerApps #ScoreboardApp #CanvasApp #AnimationApp #SharePoint.

Tron 3.0 (Soundtrack)

Daniel Christian 2022-08-21 | Tron 3.0 (Soundtrack)

Hey Everyone,
This is a techno music I have been working on since May 2022 and has been inspired by the Daft Punk, the composers of Tron: Legacy soundtrack music.
I've used a total of 13 loops which are from Apple Garageband and Mainstage.
Hope you enjoy it!

#TechNoMusic2022 #TronRemix #garageband

Yammer Administrator Role in Azure Active Directory

Daniel Christian 2022-08-15 | Yammer Administrator Role in Azure Active Directory

Hey Everyone,
The new Yammer Administrator Role has finally arrived in Azure Active Directory (AAD) and in this video, we'll deep-dive in what it means and have to use it.

Some of you may already be familiar with the concept of AAD roles because they already existed for other services such as SharePoint, Exchange, Teams and Power Platform.

Table of contents
Introduction 0:00
Announcement 0:45
Privileged Identity Management 1:06
Verify the Yammer Administrator Role 2:12
Configure Privileged Identity Management 5:09
Verify Yammer Verified Admin access.11:49
Remove Yammer Verified Admin access.14:15
Conclusion 16:37

Helpful link(s)
https://techcommunity.microsoft.com/t5/yammer-blog/the-new-yammer-administrator-role-is-now-available-in-azure/ba-p/3592577
https://docs.microsoft.com/en-us/yammer/manage-yammer-users/manage-yammer-admins

#Yammer #AzureActiveDirectoryRole #AzureRole #PrivilegedIdentityManagement #BreakglassAccess

Microsoft Forms: Convert a Word or Pdf quiz into Microsoft Forms

Daniel Christian 2022-08-08 | Microsoft Forms: Convert a Word or Pdf quiz into Microsoft Forms

Hey Everyone,
In this video we will take a look at the new feature in Microsoft Forms which is currently available in the tenants owned by education customers. You need to have an Education license (Example: Microsoft 365 A5 for students) to see this feature.
This 1-click process allows you convert your Word or PDF quiz from your local device into a Form with additional functionality to modify it.

Table of contents
Introduction 0:00
Announcement 1:08
Compare Education Vs. Business customer tenant 1:50
Various Import scenarios 2:52
Tips & Tricks 7:32
- Tile & Page Breaks 7:51
- Heading and sub-headings 9:54
Conclusion 12:17

Helpful link(s)
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/convert-a-word-pdf-quiz-to-a-microsoft-forms-quiz/ba-p/3513717

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrsoftForms #Education #NewFeature #Microsoft365

SharePoint List Templates That Include Power Automate Flows

Daniel Christian 2022-08-01 | SharePoint List Templates Include Power Automate Flows

Hey Everyone,
In this video, we'll take a look at the several SharePoint list templates that already come with the reminder flows available to provision after you create the list. Currently, the following templates will have flows:
• Work progress tracker,
• Content scheduler, and
• Recruitment tracker.

List creators who create a list from the Work progress tracker template, Content scheduler template, or Recruitment tracker template will see a modal prompting them to install the included Power Automate flow after their list has been created. The reminder flow is an automated flow that runs on a schedule in the background, so it does not appear in the Lists menu.

Table of contents
- Introduction 0:00
-Announcement 0:54
- Work progress tracker 2:19
- Content scheduler 7:35
- Recruitment tracker 9:30
- Two scenarios 12:01
- Conclusion 14:37

Helpful link(s)
• Create a business application from a list template - https://support.microsoft.com/en-us/office/create-a-business-application-from-a-list-template-ce7c5463-2e0f-4004-a160-552c2f84c4ec

• https://www.microsoft.com/en-us/microsoft-365/roadmap?rtc=1&searchterms=88906&filters=&searchterms=88906

• Manage a flow that was created from a list template - https://support.microsoft.com/en-us/office/manage-a-flow-that-was-created-from-a-list-template-7cbb31e4-cefb-4a53-9a0a-668a96cb7245

• Overview of solution-aware flows -https://docs.microsoft.com/en-us/power-automate/overview-solution-flows

• Power Platform solution concepts - https://docs.microsoft.com/en-us/power-platform/alm/solution-concepts-alm

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerAutomate #SharePoint #Flows #List #Templates

Introduction to Power Automate Child Flows

Daniel Christian 2022-07-25 | Hey Everyone,
This is an introduction to Power Automate child flows video where I'll start with the key items you need to be aware of to start building child flows. The video starts with describing what a Solution is and then leads into child flows. I will also provide a simple demo of how to build a cloud flow in a solution which then leads into building the parent child flow.

Table of contents
Introduction 0:00
What is a Solution? 0:47
What is a child flow? 2:15
Demo 2:42
- Create a solution 3:42
- Build a child flow by a Do Not Reply account to send only emails 7:17
- Build a child flow to make HTTP connection 14:00
- Build a parent flow that will use the above two child flows 20:18
- Testing #1 30:12
- Troubleshooting 30:48
- Final test 32:04
Conclusion 33:45

Helpful links(s)
- Solutions overview https://docs.microsoft.com/en-us/power-apps/maker/data-platform/solutions-overview
- Create a cloud flow in a solution
- Create child flows https://docs.microsoft.com/en-us/power-automate/create-child-flows

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerAutomate #ChildFlow #Workflows #PowerPlatform

Power Apps AI Enhancement To Change 3D Models In Place

Daniel Christian 2022-07-18 | Power Apps AI Enhancement To Change Models In Place

Hey Everyone,
In this video we'll deep-dive in the enhancement that was released in the Power Apps Canvas app's 3D model. You can now show a gallery of all media files within the mixed reality session and let the end user change the model in place without the need to jump in and out of mixed reality.

In order for this to work successfully, I'll walk you through how to build a data source from scratch, in this case a SharePoint list, where you save the list of 2D and 3D models as attachments and reference their links. We will then build a canvas type mobile app, emphasizing on the new feature.

I'll also show you where to get the sample 3D models which Microsoft has provided in Github

Table of contents
Introduction 0:00
Get Sample Data Files 1:08
Create a SharePoint List 2:12
- Add Picture columns 6:35
Power Apps Canvas app 14:06
- Add the gallery 15:29
- Add another screen 16:17
- Add 3D Object control 16:30
- Add 3D Model control 20:36
Demo 26:00
Conclusion 28:16

Helpful link(s):
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/mixed-reality-component-view-mr
https://github.com/microsoft/experimental-pcf-control-assets
Power Apps MR Vertical Lift and Shadow Feature - https://youtu.be/y5-yj97ksj0

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #MixedReality #MR #MobileApp

Delete Entire Yammer Conversations Using Power Automate

Daniel Christian 2022-07-11 | Delete Entire Yammer Conversations Using Power Automate

Hey Everyone,
In this video, I'll walk you through how to build a Power Automate flow that will delete an entire Yammer conversation.

Currently, Yammer does not have the functionality to delete an entire conversation. You have to delete both the initial post and all the subsequent comments one by one. However, thanks to the available Yammer APIs and Power Automate, we can accomplish the same task.

Here is the link to access the Yammer Registered Applications -https://www.yammer.com/client_applications

Table of contents
Introduction 0:00
Yammer API 1:29
Yammer App Registration 2:02
Building the flow 3:09
- Overview 3:14
- Start building the flow 3:42
- Initialize the token variable 4:12
- GET HTTP call action 5:00
- Select action to get the Ids 7:05
- Save IDs in an array variable 13:06
- Length function to count all the messages 13:55
- DEL HTTP call 16:53
Connecting with a canvas app 22:13
- Power Apps Split function 23:25
Conclusion 28:31

Helpful link(s)
About the Yammer REST API - https://docs.microsoft.com/en-us/rest/api/yammer/rest-api-rate-limits
Power Automate HTTP connector -
HTTP connector - https://docs.microsoft.com/en-us/learn/modules/http-connectors/

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerAutomate #powerapps #Yammer #API #HTTP

Power Apps: How To Block Users From Using An App

Daniel Christian 2022-07-04 | Power Apps: How To Block Users From Using An App

Hey Everyone,
Thanks to the combination of Power Apps Office365Groups and StartScreen function, you can now control which users accessing the app also have rights to the backend SharePoint data source.

In this video, we'll take a look at a scenario where users who have access to the app but do not have access to the backend SharePoint site are automatically re-routed to a denied screen. This is accomplished using a combination of IsEmpty, Filter and User functions.

Table of contents
Introduction
Demo
Microsoft 365 group
Walk-through the demo
Conclusion

Helpful link(s)
- Control level permission using Office 365 Groups - https://www.youtube.com/watch?v=d0Ra0qr29JM
App start screen alternative - https://powerapps.microsoft.com/en-us/blog/app-Addstartscreen-a-new-declarative-alternative-to-navigate-in-app-onstart/

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #SharePoint #Permissions #Microsoft365Groups

Upvote Answers in Yammer

Daniel Christian 2022-06-27 | Upvote Answers in Yammer

Hey Everyone,
In this video, we'll deep-dive in the upvote answers feature that released in Yammer Enterprise in March 2022. This was a feature that was announced in the November 2021 Microsoft Ignite event.

Community members can upvote a response if it’s a helpful or useful contribution to the question. Anyone can view who voted for each reply. You can only vote for a reply once, but you can vote on more than one reply. The more votes an answer receives, the higher it’ll go in the conversation. This saves you time by being able to quickly scan for information without having to scroll through answers to find the most useful response.

Table of contents
0:00 Introduction
0:37 Announcement of the new feature
1:17 Scenario #1 - Existing question
5:05 Mobile view
6:13 Scenario #2 - Build a new question
20:28 Conclusion

Helpful Link(s)
https://techcommunity.microsoft.com/t5/yammer-blog/available-now-upvote-answers-in-yammer/ba-p/3255198
https://www.youtube.com/watch?v=b0bZtP-FGPI

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#Yammer #Upvote #Microsoft365 #SocialMedia

Getting started with Mixed Reality in Power Apps

Daniel Christian 2022-06-25 | Getting started with Mixed Reality in Power Apps

Join Reza Dorrani & Daniel Christian aka R&D and Anthony Uitz, Senior Program Manager from Microsoft for an overview of Mixed Reality in Power Apps canvas apps.

The mixed reality (MR) features in Power Apps, which include the View in 3D, View in MR, View Shape in MR, and Measure in MR components was generally available on April 5th, 2021 and ever since then the product group has released several enhancements and new features which Anthony will deep-dive in. With hundreds of millions of MR-capable mobile devices in the hands of business users, every maker will be able to leverage the power of mixed reality to digitize workflows in physical space in new and innovative ways.

📢 Q&A Rules:
👉 We will open the floor for live Q/A at end of session.
👉 Put "Q:" in front of your comments and post your question.
👉 Please do not re-post your questions.
👉 We will try to answer as many questions as possible live.

New Templates for Microsoft Forms!

Daniel Christian 2022-06-20 | New Templates for Microsoft Forms!

Hey Everyone,
Microsoft has released four categories of new templates for Microsoft Forms. In this video, we'll take a look at where and how to find these forms. We will also overview these forms categories.

Table of contents
0:00 Introduction
0:42 Why you might have missed seeing these templates
2:20 Why you did not miss seeing these templates
3:28 Closer look at the new templates
8:33 Some pre-existing templates
9:57 Conclusion

Helpful link(s)
1) Microsoft Forms features for Education
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/five-new-microsoft-forms-features-for-education-july-2021/ba-p/2548365

2) Microsoft Forms features for Government
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/five-new-microsoft-forms-features-for-government-july-2021/ba-p/2540284

3) Sample forms to help organizations stay connected while working remote
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/sample-forms-to-help-organizations-stay-connected-while-working/ba-p/1256627

4) Manage your Microsoft Forms with Collections
https://youtu.be/EEqPC3XEEcE

5) How to use Sections in Microsoft Forms
https://youtu.be/ZGAZJAuF-FU

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrosoftForms #NewTemplates #Forms #Microsoft365

2022 Oak Island, North Carolina

Daniel Christian 2022-06-17 | 2022 Oak Island, North Carolina

Hey Everyone,
Enjoy this video of all the videos I recorded using my DJI Mini II and pictures I took using my Canon 6D Mark II DSLR of the beautiful Oak Island, North Carolina.

Table of contents

0:00 Caswell beach
0:25 Pier
3:56 The Point
5:27 Lighthouse
8:07 Pictures

#2022OakIsland #dronevideo #Island #beach #NorthCarolina

Power Apps AI-Powered Express Design (Preview)

Daniel Christian 2022-06-13 | Power Apps AI-Powered Express Design (Preview)

Hey Everyone,
In this video, we'll take a look at the new AI Powered express design feature in Power Apps that was announced during Microsoft Build.
I'll walk you through a demo of how I took my hand drawn form and converted that into a Power Apps Canvas form with a backed data source.

Table of contents
0:00 Introduction
0:38 Announcement of AI-powered express design
Scenarios
0:51 1) A hand drawn form with text not in a straight line.
10:42 2) A legacy paper form you inherited whose electronic copy you do not have
15:40 3) A sample form with icons.
19:35 Conclusion

Helpful link(s)
https://powerapps.microsoft.com/en-us/blog/new-express-design-in-power-apps-converts-images-and-designs-to-apps-in-seconds/

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #AI #Form #ExpressDesign

Power Apps Personal Barcode Scanner App For Events

Daniel Christian 2022-06-06 | Power Apps Personal Barcode Scanner App For Events

Hey Everyone,
So as in-person events have started, I wanted an easier way to gather contacts. I've noticed most if not all the conferences IDs already have a QR code which are used by the sponsors when you visit their booth. Scanning this code provides them your contact information. Hence I decided to use the barcode scanner that comes with Power Apps and which uses the built-in native camera. The app also has ways to pick and choose the different delimiter options available.

This isn't a full-proof solution because sometimes the barcode scanner results are not clear text and hence I have my back-up plan also added to the same app which is the business card scanner.

Table of contents
Introduction 0:00
Demo 1:00
Three screens 3:43
App OnStart 4:42
Responsive design 5:46
Test Barcode Scanner 6:42
Horizontal Gallery 10:00
Edit Form 14:40
SharePoint List 17:38
Business Card Scanner 19:35
Conclusion 21:36

Helpful link(s)
- Barcode scanner control in Power Apps - https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-new-barcode-scanner
- Power Apps Container Series - https://www.youtube.com/watch?v=_oKXKrQNfFY

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #SharePoint #barcode

Power Automate Scheduled Notifications In A Loop

Daniel Christian 2022-05-30 | Power Automate Scheduled Notifications In A Loop

Hey Everyone,
In this video we'll will look at a scheduled flow that sends email notifications based on a dynamic list and how the flow will automatically loop back to the beginning once it reaches the end.

I lead a team for video projection and live streaming and I send a friendly reminder to folks whose turn it is to be the projectionist. This was a weekly process that I carried out manually, however, with a little innovation and flow, I was able to automate the process. Now all I have to do is update the schedule list and Power Automate sends the notifications dynamically.

You can use this same logic for your company's on-call schedule reminders or even the work schedule reminders.

Table of contents
Introduction 0:00
Scenario 0:51
SharePoint List 2:26
Power Automate flow 5:17
Demo 14:27
Change the trigger step 18:30
Conclusion 19:27

Helpful links
Power Automate Flow to Send Reminders for Pending Approvals - https://youtu.be/2DhtYSFYeP4

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerAutomate #SharePoint #Schedule #Reminders

The New and Improved Power Virtual Agents

Daniel Christian 2022-05-26 | The New and Improved Power Virtual Agents

Hey everyone,
In this video, we'll take a quick look at the new and improved features that are currently available in Private Preview. This video shows how Microsoft is slowly bridging the gap between the Citizen Developers using Power Virtual Agents and the Pro Developers using Bot Framework Composer.

The key items I am focused on are:

1) Overall design of each Topic's working section
2) Citizen developer & Pro developer
3) Rich text response in Message
4) Power Fx formulas
5) Telephony

Table of contents
Introduction 0:00
Overall design of each Topic's working section 0:44
Citizen developer & Pro developer 2:34
Rich text response in Message 3:42
Power Fx formulas 5:47
Telephony 7:11
Conclusion 8:03

Helpful links
https://powervirtualagents.microsoft.com/en-au/blog/whats-new-the-evolution-of-power-virtual-agents/
https://docs.microsoft.com/en-us/power-virtual-agents/build-22/publication-connect-bot-to-telephony

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerVirtualAgents #MSBuild #Chatbot #Bot

10 Things You Need To Know About Yammer

Daniel Christian 2022-05-23 | Hey Everyone,
In this video we talk about the 10 Things You Need To Know About Yammer. This is extremely important for both the Yammer community and verified admins. Also, some of the items I talk about are new features that have either just arrived in your tenant or will soon.

Table of content
- Introduction 0:00
- Mark official community 0:55
- Promoting access level 4:12
- Restricted access level 11:23
- Community type 14:48
- Yammer notifications (New Feature) 16:27
- Global admins see Native Mode (New Feature) 19:36
- Yammer Azure Role (New Feature) 21:44
- Bulk import users to a community 24:03
- New Yammer experience (New Feature) 29:33
- Unofficial API 32:02
- Conclusion 34:05

Helpful links
- https://support.microsoft.com/en-us/office/enable-or-disable-yammer-email-and-phone-notifications-93e530e0-189f-4768-8f28-7683d48cc996
- https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=&searchterms=82187
- Bulk upload to add or create members of a group - Azure Active Directory | Microsoft Docs
- https://docs.microsoft.com/en-us/rest/api/yammer/rest-api-rate-limits

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#Yammer #SocialMedia #AzureRole #YammerAPI

5 Hidden Gems for Microsoft Forms

Daniel Christian 2022-05-16 | 5 Hidden Gems for Microsoft Forms

Hey Everyone,
In this video we'll focus on 5 items, two of which truly are hidden in Microsoft Forms.

Table of contents
Introduction 0:00
Main page for Microsoft Forms 0:30
Navigation tab 2:24
Change choice from radio to drop-down 4:39
Customize Theme 6:00
Share a summary link 7:20
Conclusion 9:01

Helpful Link(s)
https://www.w3schools.com/colors/colors_picker.asp
Microsoft Forms Collection - https://youtu.be/EEqPC3XEEcE
Microsoft Forms VS Microsoft Power Apps - https://youtu.be/scaNDRXhFvo
Microsoft Forms and Microsoft Power Apps, Happy Together - https://youtu.be/FtfBBqx-p1k

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrosoftForms #HiddenGems #FormsNavigationTab

Power Apps MR Vertical Lift and Shadow Feature

Daniel Christian 2022-05-09 | Power Apps MR Vertical Lift and Shadow Feature

Hey Everyone,
In this video we'll take a look at the latest new features released in the Power Apps Mixed Reality control.
The new feature is primarily used for models that are intended to be partially obscured by the ground or lifted up vertically like if you want it floating above the ground. Currently when you place a model we automatically adjust it so that it is flush with the ground, so this gives you to tweak that in the experience.

Table of contents
Introduction 0:00
What 3D was before the change 0:38
Real world scenario 1:57
The new vertical lift 2:16
Conclusion 6:02

Helpful link(s)
- New feature in Power Apps MR: https://youtu.be/DmF-Pb_NmhI
- https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/mixed-reality-component-view-shape

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #MixedReality #MR #MobileApp

Power Automate Flow to Send Reminders for Pending Approvals

Daniel Christian 2022-05-02 | Power Automate Flow to Send Reminders for Pending Approvals

Hey Everyone,
Power Automate has the approval connector which does a SPECTACULAR!! Job for an approval process. This video will help you enhance it further by sending reminders for the pending approvals. We'll start by first reviewing the list and it's approval column which we will use for an OData filter query. Then we focus on the secondary flow that will send the reminder.

Table of contents
Introduction 0:00
Review the Microsoft List 0:46
Review the approval flow 1:57
Walk through the reminder flow 3:41
Test the reminder flow 10:00
Conclusion 13:23

Helpful link(s)
Power Automate: Start and wait for an approval - https://www.youtube.com/watch?v=frkhd6eAjC8
Power Automate Approval: Change the Created By - https://www.youtube.com/watch?v=GDF1V81rnaw

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerAutomate #SharePoint #Approvals #Reminders

Power Apps Patch Function options for SharePoint

Daniel Christian 2022-04-25 | Power Apps Patch Function options for SharePoint

Hey Everyone,
In this video, I'll walk you through the different options available for the Power Apps Patch function with SharePoint as the data source. The options include:
1) Patch a single new item
2) Edit an existing item using Patch
3) Patch new items in bulk
4) Patch existing items in bulk.

Table of contents
Introduction 0:00
Patch a single item 0:46
Review controls 10:13
Single line of text 16:25
Number column 18:04
Lookup column 18:44
Choice column 20:48
Managed Metadata 23:55
Data column 25:41
Patch in bulk 28:25
Add items in bulk 33:10
Edit items in bulk 36:34
Conclusion 43:00

Helpful link(s)
https://www.youtube.com/watch?v=qU22DiaIPpU
https://www.youtube.com/watch?v=FmCdUMmm8xg
https://youtu.be/h9ysh8spmvk

The Patch Function Formula

If(
varEditForm=false,
/*********Use Patch to add a new item********/

Patch('Patch it',Defaults('Patch it'),
{
/*******Single line of text columns****/
'First Name':FirstNameTextInput.Text,
'Last name':LastNameTextInput.Text,
Address:AddressTextInput.Text,
Notes:NotesTextInput.Text,

/***Number columns******/
Zip:Value(ZipTextInput.Text),
'Amount in cash':Value(AmtInCashTextInput.Text),

/*******Lookup columns******/
State:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:StateGallery.Selected.ID,Value:StateGallery.Selected.Title},
City:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:CityGallery.Selected.ID, Value:CityGallery.Selected.City},

/***********Choice columns***********/
'Single or double bed?':{Value:If(SingleDoubleToggle.Value=false,"Single", "Double"), '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},
Smoking:{Value:If(SmokingNonToggle.Value=false, "Non smoking", "Smoking"),'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},
pets:{Value:If(PetsToggle.Value=false, "No", "Yes"),'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},

/***********Managed Metadata column***********/

'Pet type':{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
TermGuid: PetsGallery.Selected.TermGuid,
WssId: PetsGallery.Selected.WssId,
Label: PetsGallery.Selected.Label,
Path:PetsGallery.Selected.Path,
Value: PetsGallery.Selected.Value
},

/***********Date column***********/

Arrival:ArrivateDatePicker.Value,
Departure:DepartureDatePicker.Value
}),

/*********************Use Patch to edit existing item*********************/
varEditForm=true,
Patch('Patch it', LookUp('Patch it',ID=ExistingItemsGallery.Selected.ID),
{
/***********Single line of text columns***********/
'First Name':FirstNameTextInput.Text,
'Last name':LastNameTextInput.Text,
Address:AddressTextInput.Text,
Notes:NotesTextInput.Text,

/***********Number columns***********/
Zip:Value(ZipTextInput.Text),
'Amount in cash':Value(AmtInCashTextInput.Text),

/***********Lookup columns***********/
State:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:StateGallery.Selected.ID,Value:StateGallery.Selected.Title},
City:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:CityGallery.Selected.ID, Value:CityGallery.Selected.City},

/***********Choice columns***********/
'Single or double bed?':{Value:If(SingleDoubleToggle.Value=false,"Single", "Double"), '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},
Smoking:{Value:If(SmokingNonToggle.Value=false,"Non smoking", "Smoking"), '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},
pets:{Value:If(PetsToggle.Value=false,"No", "Yes"),'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},

/***********Managed Metadata column***********/

'Pet type':{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
TermGuid: PetsGallery.Selected.TermGuid,
WssId: PetsGallery.Selected.WssId,
Label: PetsGallery.Selected.Label,
Path:PetsGallery.Selected.Path,
Value: PetsGallery.Selected.Value
},
/***********Date column***********/
Arrival:ArrivateDatePicker.Value,
Departure:DepartureDatePicker.Value
}));
Set(varPop,false);Set(varEditForm,false);
Reset(FirstNameTextInput);Reset(LastNameTextInput);Reset(AddressTextInput);Reset(NotesTextInput);Reset(ZipTextInput);Reset(AmtInCashTextInput);Reset(StateTextInput);Reset(CityTextInput);Reset(SingleDoubleToggle); Reset(SmokingNonToggle);Reset(PetsToggle);Reset(ArrivateDatePicker);Reset(DepartureDatePicker);Reset(NotesTextInput)

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #PatchFunction #SharePoint #Apps

Power Apps Shopping List App

Daniel Christian 2022-04-18 | Power Apps Shopping List App

Hey Everyone,
In this video, I'll walk you through how to build your shopping list app using Power Apps Canvas, Power Automate and SharePoint. The app demos how you can either use an existing template of shopping list or build your own list and refer to it. In the backend we have several tables/lists that are used to keep track of everything.
While I have titled this as a shopping list app, the same process can be used for assigning daily tasks to your employees, or a daily delivery list or even an employee on-boarding process. So many options!

Table of content(s)
Introduction 0:00
Demo 0:50
SharePoint 5:37
Power Apps 8:48
Power Automate 24:24
Conclusion 27:34

Helpful link(s)
https://www.youtube.com/watch?v=qU22DiaIPpU
https://www.youtube.com/watch?v=FmCdUMmm8xg

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #PowerAutomate #SharePoint #ShoppingList #Apps

5 Ways To Use Yammer

Daniel Christian 2022-04-11 | 5 ways to use Yammer

Hey Everyone,
In this video, we'll take a look at the 5 different ways you can use Yammer. We'll start by using the browser version of Yammer, then we'll look at the mobile app, next we'll look at the integration in SharePoint and Teams, finally, we'll end with the new progressive web app version of Yammer. I'll also show you how to install it!

Table of contents:
Introduction 0:00
License 0:50
Browser 1:50
Yammer communities 3:20
**New Feature** SharePoint sites created by Yammer 4:10
Verified Admin 5:57
**New Feature** Yammer Azure AD role 6:40
Mobile app 10:50
SharePoint 13:23
Teams 17:53
Progressive web app 21:06
Conclusion 24:43

Helpful link(s):
https://support.microsoft.com/en-us/office/install-the-new-yammer-desktop-app-66ccb412-ca1d-4e43-872c-9705abf11b1b
https://docs.microsoft.com/en-us/microsoft-edge/progressive-web-apps-chromium/
https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=&searchterms=82187
https://docs.microsoft.com/en-us/azure/active-directory/roles/permissions-reference

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#Yammer #SharePoint #Teams #ProgressiveWebApp #MobileApp

Power Apps Ticketing System With Sentiment Analysis

Daniel Christian 2022-04-04 | Power Apps Ticketing System with Sentiment Analysis

Hey Everyone,
In this video, we'll take a look at how we can integrate Microsoft Cognitive Services with Power Apps Canvas apps. We'll take an existing Ticketing System app and add Sentiment Analysis to it. This will help the support team identify their customers who are in distress and attend to their needs quickly.

Table of contents
Introduction 0:00
Overview of the Ticketing System App 0:44
Overview of Sentiment Analysis 1:20
Add columns to SharePoint List 3:08
Build the flow 4:12
Update the existing app 21:30
Conclusion 31:57

Helpful link(s)
- https://azure.microsoft.com/en-us/services/cognitive-services/
- https://docs.microsoft.com/en-us/ai-builder/prebuilt-sentiment-analysis
- https://docs.microsoft.com/en-us/connectors/cognitiveservicestextanalytics/
- New and improved Sentiment Analysis video https://www.youtube.com/watch?v=40MXcUcVnfk

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#SentimentAnalysis #CognitiveServices #PowerApps #Formulas #CanvasApps

How To Manage Multimedia In Power Apps

Daniel Christian 2022-03-28 | How to manage multimedia in Power Apps

Hey Everyone,
In this video we'll deep-dive in how to manage images, videos and audio files in Power Apps. I'll share some tips and tricks on how to easily use them. I'll also show you how to retrieve the media that you have uploaded to the app, it's not as easy as you expected. Finally, I'll share this hidden feature on to improve the performance of your app that has media.

Table of contents
Introduction 0:00
Power Apps media properties 0:48
Images 2:23
Audio 3:55
Video 4:15
Remove 6:14
Limit 7:09
How to export or save as 9:26
Conclusion 13:35

Helpful link(s)
- https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-pictures-audio-video

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #CanvasApp #Multimedia #Howto

Add Power Apps Formulas Using Excel

Daniel Christian 2022-03-21 | Add Power Apps Formulas Using Excel

Hey Everyone,
In this video we'll deep-dive in how you can add and update Power Apps formulas using Excel. We focus on this scenario where I have a gallery used to navigate through 50 screens in a canvas app. I'll show you how you can use Excel to quickly create that large formula.

Table of contents
Introduction 0:00
The fundamental screen 0:55
- Adding App Active Screen formula 2:39
Build the collection 4:15
Adding a gallery 10:20
- Default property of the gallery 12:52
- Navigate with If functions 14:50
Duplicate screens 19:08
Demo 23:10
Conclusion 24:17

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#Excel #PowerApps #Formulas #CanvasApps

Power Apps Tab Index and Child Controls in a Container

Daniel Christian 2022-03-14 | Power Apps Tab Index and Child Controls in a Container

Hey Everyone,

In this video, We first start by learning what the "Z" pattern means and then look at scenarios. Then we focus our attention on the Priority child and the Enable child control focus feature that are available inside a container. Then we see how the two work together to improve the user interface for those who prefer to use keyboard navigation.

Prioritize child controls: Determines the order of navigation (Z-order) for child controls on canvas when pressing tab key on the keyboard.
- On (Default): Pressing the tab key on the keyboard will first progress through all child controls before moving the focus outside of the selected container or component instance. This option is recommended for similarly nested HTML elements.
- Off: Pressing the tab key on the keyboard will progress through all controls only based on Z-order, ignoring parent-child relationship between controls or containers for keyboard navigation.

Table of contents
- Introduction 0:00
- Tab Index 0:45
- "Z" pattern 1:30
- Disable Tab Index 2:40
- Container and child controls 4:24
- Demo 1 with container 5:54
- Demo 2 with container and disable child prioritize property 8:27
- Demo 3 with overlapping containers. 13:04
- Demo 4 real-world example 18:50
- Conclusion 20:15

Helpful link(s)
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/accessibility-keyboard-navigation
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/properties-accessibility#tabindex

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #Container #TabIndex #CanvasApps #Apps

Overview of AI Builder

Daniel Christian 2022-03-12 | Overview of AI Builder

Join Reza Dorrani & Daniel Christian aka R&D and Joe Fernandez, Program Manager from Microsoft for an overview of AI Builder.

AI Builder is Microsoft’s no-code AI platform. In this episode of the RnD Show you will learn what AI Builder is and see demos of practical examples you can leverage to easily automate repetitive and boring tasks with Artificial Intelligence. 🚀 If you already know about AI Builder, you’ll also learn about recent updates, what’s coming next and have the chance to ask questions directly to the AI Builder team. Make sure to watch!

🧠 Try AI Builder for free: https://aka.ms/tryaibuilder?utm_source=YouTube&utm_medium=video&utm_campaign=rnd-show

📢 Q&A Rules:
👉 We will open the floor for live Q/A at end of session.
👉 Put "Q:" in front of your comments and post your question.
👉 Please do not re-post your questions.
👉 We will try to answer as many questions as possible live.

#AIBuilder #PowerPlatform #RnDShow

Power Apps Travel App Using Geospatial Controls

Daniel Christian 2022-03-07 | Power Apps Travel App Using Geospatial Controls

Hey Everyone,
In this video, I'll walk you through how I was able to take an existing travel app that I refer to for the local light rail and rebuild it in Power Apps. I used the Power Apps geospatial controls to replicate all the features in the original app with the flexibility to add my own items to it.

Table of contents
Introduction 0:00
Demo of light rail app 1:05
Demo of my app 2:39
Environment setting change 4:22
App Design 5:35
Header 9:55
Map/middle 13:50
SharePoint List 15:13
Footer 18:40
Conclusion 22:05

Helpful links
- Power Apps Scrolling Gallery - https://youtu.be/CP0uabdcFuw
- Power Apps Container Series - https://youtu.be/_oKXKrQNfFY
- https://powerapps.microsoft.com/en-us/blog/announcing-the-general-availability-of-geospatial-features-in-power-apps/
- https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/geospatial-overview
- https://docs.microsoft.com/en-us/azure/azure-maps/how-to-use-image-templates-web-sdk#list-of-image-templates

#PowerApps #Geospatial #TravelApp #SharePoint

Power Apps Scrolling Gallery

Daniel Christian 2022-02-28 | Power Apps Scrolling Gallery

Hey Everyone,
In this video, I'll explain how to create a scrolling gallery in a Power Apps. This feature will give you the flexibility to view only one item at a time, select to go forward or backward or even randomly select items. You can also see how many items were before or after. We'll achieve all of this using galleries, a combination of filter and if function and global variables.

Table of contents
Introduction 0:00
Demo the finished app 0:57
Review the SharePoint list 2:02
Adding two variables 3:38
Adding button as a curved border 5:00
Adding main gallery. Add the image and the text 6:38
Adding scroll gallery. Add the icon 8:40
Add formulas to the scroll gallery 11:32
Add the filter formula to the main gallery 12:04
Add the left & right icons 14:43
Test 20:13
Final tweaking of design 22:03
Conclusion 22:56

#PowerApps #SharePoint #CanvasApps #ImageCarousel #AppDesign

Power Automate Flows Vs Automate Rules

Daniel Christian 2022-02-21 | Power Automate Flows Vs Automate Rules

Hey Everyone,
In this video we'll go over the key differences between Power Automate flows and Automate rules in a SharePoint list or document library. We'll go over the different types of automate rules available and how easy it is to use. Then we'll try to rebuild them in Power Automate and show you difference.

Table of contents
Introduction 0:00
Column changes 1:35
Column value changes 8:40
A new item is created and deleted 12:02
Manage rules 13:23
Permissions 13:48
Conclusion 14:21

Helpful link(s)
https://support.microsoft.com/en-us/office/create-a-rule-to-automate-a-list-or-library-151ea008-7fa6-409b-b0bd-b04a3b3cacd5

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerAutomate #AutomateRules #SharePoint #ListRules #Microsoft

Power Virtual Agents: Standalone vs Microsoft Teams

Daniel Christian 2022-02-14 | Power Virtual Agents: Standalone vs Microsoft Teams

Hey Everyone,
This video focuses on the key differences between Power Virtual Agents as a standalone chatbot service vs in Microsoft Teams. I'll also provide a side-by-side comparison on how the Dataverse connector changes based on how you use it.

Table of contents:
Introduction 0:00
Standalone Chatbot 0:35
- Key items 0:40
- Summary of the entitlements 1:01
- Which license to assign 1:31
- What is a complete chat session? 1:55
- Demo of standalone chatbot 2:13
Power Virtual Agents in Teams 4:42
- Key items 4:45
- Demo of chatbot in Teams 5:36
Side-by-side comparison 8:18
Conclusion 9:04

Helpful link(s):
https://docs.microsoft.com/en-us/power-virtual-agents/requirements-licensing
https://docs.microsoft.com/en-us/power-virtual-agents/requirements-licensing-subscriptions
https://powervirtualagents.microsoft.com/en-us/pricing/
https://docs.microsoft.com/en-us/power-virtual-agents/teams/fundamentals-what-is-power-virtual-agents-teams

#Chatbot #MicrosoftTeams #Dataverse #PowerVirtualAgents

Power Apps Design Ideas For Slider Control

Daniel Christian 2022-02-07 | Power Apps Design Ideas For Slider Control

Hey Everyone,
In this video, we'll take a look at how to use the slider control to help improve and keep the design of your Power Apps canvas app consistent through your tenant. We start by first looking at the traditional use of the slider control using its properties and then think out-the-box and come up with some innovative ideas.

Table of controls
Introduction 0:00
Review slider control properties 0:35
Adding up and down controls 3:17
Increase and decrease text size 7:49
Increase and decrease button size 10:32
Matching colors 12:52
Filter data in a gallery 18:24
Bar graph 25:28
Conclusion 33:34

Helpful link(s)
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-slider

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #SliderControl #SharePoint #BarGraph

Happy Fall Melody Music

Daniel Christian 2022-02-05 | Happy Fall Melody

What started as my Fall 2021 project of techno music comprises of 14 loops from Garageband and Mainstage. This is my first attempt of adding vocal loops and hence it took me longer than usual to get the tune just right.
Hope you enjoy it!

#HappyFallMelody #TechnoMusic #Garageband #Mainstage

Microsoft Forms On Mobile Devices

Daniel Christian 2022-01-31 | Microsoft Forms On Mobile Devices

Hey Everyone,
In this video, we'll look at how to make and modify Microsoft Forms using mobile devices. I'll also provide those not-so-obvious features which can cause a few issues.

Table of contents
Introduction 0:00
Introduce the Office app 0:44
Where to find Microsoft Forms 1:27
Create a new Mobile form 2:12
- Choice 2:52
- Text 4:54
- Rating 5:44
- Date 6:54
Sharing feature in mobile app 7:15
Compare with a desktop form 8:16
My opinion on when to use the mobile app 11:53
Use filter to find forms 13:00
Edit form on mobile device 14:06
Edit option on mobile device disappears 17:05
Conclusion 17:51

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#MicrosoftForms #Forms #MobileForms #MobileApps

More Improvements To Power Apps Mixed Reality

Daniel Christian 2022-01-24 | More Improvements To Power Apps Mixed Reality

Hey Everyone,
In this video, we'll take a look at the new improvements made in the Mixed Reality feature. This improvements are to increase predictability and usability.

Firstly, Power Apps now support scaling your models, images, and shapes in Mixed Reality. The ability to scale is rolling out this week on app version 3.21115, so you may need to manually update your Power Apps app to try it out.

Finally, they have added a new property called Box Draw that allows users to expect only rectangular shapes, which is usable for Area, Volume, or Freeform measurement types.

They have also improved the Expected Measurements feature to increase the usability of data, and allow for finer control.
• Added overrides for measurement type and box draw properties for each expected measurement
• Added automatic labelling of photos captured with their associated measurement to more easily correlate images to each data point in your apps.

Table of contents
Introduction 0:00
Scalability feature 0:54
Geolocation feature 4:33
Box Draw feature 6:04
Create a preview environment 6:40
Creating labels 7:30
Show non-production apps 10:55
Demos 12:40
Conclusion 16:00

Helpful links:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/mixed-reality-component-measure-distance

Contact information:
Twitter: https://twitter.com/dchristian19
Facebook: https://www.facebook.com/www1.christianfamily.biz
Instagram: https://www.instagram.com/dan.christian.33/
LinkedIn: https://www.linkedin.com/in/danchristian19/

#PowerApps #MixedReality #AugmentedReality #MR #AR #Apps