Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Portals
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find consulting services
    • Blog
    • Customer stories
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinars
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Power Apps Community
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog & News
    • News & Announcements
    • Power Apps Community Demo Extravaganza 2020
    • Galleries
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Business Value Webinars and Video Gallery
    • Emergency Response Gallery
    • 2019 Microsoft Business Applications Summit Recordings (Archived)
    • Microsoft Business Applications Summit 2020 Session Recordings
    • Ideas
    • Power Apps Ideas
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Webinars and Video Gallery
    • Your Face, Your Fate - PowerApps, AI, Flow & On pr...

    Your Face, Your Fate - PowerApps, AI, Flow & On premise Data Gateway

    05-19-2019 15:23 PM

    topness
    MVP
    192 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    topness
    topness
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Your Face, Your Fate - PowerApps, AI, Flow & On premise Data Gateway

    ‎05-19-2019 03:23 PM

    I gave this as a demo at D365 Saturday, Philadelphia and will again at 365 Saturday New York (free registration).  365 Saturday hosts free events covering intro and advanced Power platform topics, all around the world.  Check for one near you: http://365saturday.com

     

    Your Face, Your Fate - PowerApps, AI, Flow & On premise Data Gateway

     

    Scenario:  It's the future.  I mean, it's still 2019 but it's like, say, two weeks from now.  All employees are judged by their ability to suck it up and put on a smile through the workday.  Otherwise: be removed from the PowerApps team and put on the next FORTRAN project.

     

    In this demo (*demo* it will have only one slide) we will build everything from scratch, in the room, together.  We will create a mobile PowerApp that takes a picture of a face, analyzes it with Azure Face API, using AI to detect its emotion.  Those that appear unhappy are sent via Flow approval to the CEO to be assigned to the PowerApps or FORTRAN teams.  (Unless the CEO has their out of office message set, then the janitor will get to pick).  Those that are picked for FORTRAN will get added to a table on an on premise SQL Server database list, sealing their fate.  At the end, you can take your picture and let the CEO (or janitor) vote on your fate.

     

    Technologies used:

    PowerApps (canvas)

    On Premise Data Gateway

    Flow:

       REST API connection (external API connection)

       Save viewable images to SharePoint

       Approvals (V2 with custom buttons)

       Office 365 Users connector

       Office 365 Outlook connector (detect OOO message setting)

     

    Techniques shown:

    • Capture camera image from another control
    • Trigger sound off of values returned from flows
    • Use external API
    • Use Azure Cognitive Services
    • Flow approvals with custom actions
    • Determine if an approver is out of office
    • Find an approver's boss using Active Directory
    • Save viewable images from PowerApps to SharePoint
    • Detect if running on web or mobile device
    • Use flow To connect to on premise DB
    • Use variables in Flow

     

    watch?v=JcCVzJeaBIQ

    Preview file
    953 KB
    Labels:
    • Labels:
    • API Tips
    • PowerApps Hacks
    Message 1 of 1
    192 Views
    0 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Studio
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2021 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks