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
