Power Platform Community Call – May 2023

Power Platform Community Call – May 2023

Call summary

Latest updates and news on Power Platform including community events and training opportunities.

3 demos - Integrating Power Apps with Azure Machine Learning & Open AI using Power Automate, ChatGPT - but with YOUR data in Power Apps, and Low code tips for fields in Power Pages.

Activities: 5 articles, 3 documents, 3 samples, 3 Power Platform related video conversations delivered.

This call was hosted by David Warner II (Microsoft) | @DavidWarnerII and recorded on May 17, 2023. Questions addressed in chat throughout the call.

New this month

Demo summaries

  • Integrating Power Apps with Azure Machine Learning & Open AI using Power Automate – predict Health Expense using a Machine Learning Model and get savings tips to fund expenses. Uses a custom-built Azure Auto ML model integrated to Power Apps using Power Automate Flow, health expenses based on inputs and the result of the model using Open AI’s API. Solution components - HealthExpense (Canvas app), Azure Auto ML Flow (Power Automate flow), Azure Auto ML Model for predictions. Community call conversation aka.ms/May17-Demo1
  • ChatGPT - but with YOUR data in Power Apps – get better factual information from CharGPT by injecting curated information from an internal datasource. How create that data source? Vecrtorize data by calling OpenAI Embeddings endpoint. See how to call ChatGPT (via a connector) and add context (your data) to the query. ChatGPT goes beyond standard search return with clear recommendations – it’s math! You will understand the math behind the scenes after seeing this demo. Community call conversation aka.ms/May17-Demo2
  • Low code tips for fields in Power Pages – tips for using Power Automate to streamline repetitive tasks on Power Pages including formatting the site date and time (create new site setting), making a lookup column appear as a dropdown (Basic Forms), prepopulating a field (Form Metadata), formatting a phone number field using Regex (Form Metadata with validation and message), adding helper text (Form Metadata – Description/Instructions) and more. Community call conversation aka.ms/May17-Demo3

Agenda items

00:00 – Intro

01:37 – Power Platform News & Learn Updates – Daniel Laskewitz (Microsoft) | @laskewitz

04:12 – Latest Power Apps Samples – Daniel Laskewitz (Microsoft) | @laskewitz

05:26 – Independent Publisher Connectors - Jocelyn Panchal (Microsoft) | @JocelynP_PM

09:27 – Power Platform Community Shows & Events - Daniel Laskewitz (Microsoft) | @laskewitz & David Warner II (Microsoft) | @DavidWarnerII

11:34 – Together mode picture

12:47 – Demo - Integrating Power Apps with Azure Machine Learning & Open AI using Power Automate – Aaryan Arora

21:20 – Demo - ChatGPT - but with YOUR data in Power Apps – Robin Rosengrün (EnBW) | @power_r2

35:01 – Demo - Low code tips for fields in Power Pages – Elaiza Benitez

56:23 – Resources

57:17 – Closing

Together mode

together-may-2023.png

Thank you for joining the community call today. I hope you agree the three demos were great! Looking forward to seeing many of you in-person at an event near or far from your home base.

Actions

Demo references

  • Power Platform Community Call Recurring Invite - aka.ms/powerplatformcommunitycall
  • Request to Present - aka.ms/community/request/demo
  • Power Platform Samples - aka.ms/powerplatform-samples
  • Microsoft 365 & Power Platform sample gallery - aka.ms/community/samples
  • Power Platform Connectors -
  • Top Connector Asks - github.com/microsoft/PowerPlatformConnectors/wiki/Top-Connector-Asks
  • Learn how to get started in the open-source PnP community! – aka.ms/sharing-is-caring
  • Community Recognition Program - aka.ms/community/recognition
  • Low Code Revolution Show
  • Episodes – aka.ms/LowCodeRevolutionShow
    • Guest application – aka.ms/LowCodeRevolutionGuest
    • Upcoming Events - aka.ms/communitydays
  • Conversations - Power Platform Connections – aka.ms/powerplatform-connections
  • Community Call Conversations - https://powerusers.microsoft.com/t5/Community-Calls-Conversations/bd-p/pa_community_calls
  • Microsoft 365 & Power Platform community videos - aka.ms/community/videos
  • Microsoft 365 & Power Platform community calls - aka.ms/community/calls
  • Community call agendas - aka.ms/community/meetup
  • Feedback on this call - aka.ms/community/calls/feedback

General resources

Additional resources