Microsoft 365 & Power Platform Development Community call - 11th of May, 2023

Microsoft 365 & Power Platform Development Community call - 11th of May, 2023

Call summary

Welcome to the bi-weekly call focused on Microsoft 365 platform development topics. In this call, we focus on Microsoft Teams, Microsoft Graph, Power Platform, SharePoint, Microsoft Lists with topics ranging from development tools to list and column formatting, to site design and provisioning, and more.

New this week

Demos

  • What Three Words - Power Platform Custom Connector – what is the What3Words independent publisher connector and the related Power App? What are the differences between Independent and Certified connectors and GitHub usage tips. The What3Words connector delivers global location in 3-meter squares using 3 descriptive words. The Power App uses Power FX to collect Lat / Long from user, call the W3W API, and pinpoints location on map and 3 words for location. Discussion at aka.ms/May11-Demo1
  • How to automate the process to convert the rows of excel sheets into the rows of Dataverse – using Power Platform. See demo of final solution and understand prerequisite tools/access requirements, then step through uploading an xls to OneDrive and the importation of data into a Power Apps table and subsequent movement into Dataverse. Uses Import document and 2 supporting Power Automate flows. See the expressions used in Power Automate along with possible errors (learning opportunities) and explanations. Discussion at aka.ms/May11-Demo2
  • Validating PowerShell parameters with SharePoint Information – create your own PowerShell cmdlet that allows you to pull and tab through information from a site, list, text file, Azure, Graph, etc. within PowerShell environment. Learn by working through a scenario how ValidateSet and ValidateScript attributes and [ArgumentCompleter] help you deliver a better user experience, reduce bad data and make you a better coder! Bonus insight on working with chatGPT to deliver concise code. Discussion at aka.ms/May11-Demo3

The host of this call was David Warner II (Microsoft) | @DavidWarnerII. Q&A takes place in chat throughout the call.

Agenda items

00:00 – Intro - David Warner II (Microsoft) | @DavidWarnerII

05:30 – PnP .NET library updates - Bert Jansen (Microsoft) | @O365bert

06:13 – PnP PowerShell updates - Gautam Sheth (Staffbase) | @gautamdsheth

07:41 – yo Teams updates - David Warner II (Microsoft) | @DavidWarnerII

08:23 – Microsoft Teams Toolkit updates - John Miller (Microsoft) | @jmillerdev

09:56 – Microsoft Graph Toolkit updates – David Warner II (Microsoft) | @DavidWarnerII

10:50 – Microsoft Script Samples - David Warner II (Microsoft) | @DavidWarnerII

11:27 – Microsoft Teams Samples - David Warner II (Microsoft) | @DavidWarnerII

12:27 – Microsoft Power Platform Samples - Hugo Bernier (Microsoft) | @bernierh

13:18 – Together mode picture

15:02 – Demo - What Three Words - Power Platform Custom Connector – Matt Beard (Data8 Ltd)​​ | @Mattybeard

28:19 – Demo - How to automate the process to convert the rows of excel sheets into the rows of Dataverse – Abdul Wahab (Dynamics Technology Systems)

41:57 – Demo - Validating PowerShell parameters with SharePoint Information – Todd Klindt (Sympraxis Consulting) | @ToddKlindt

54:53 – Closing

Together Mode

together-230511.png

Thank you everyone for joining the call today. Awesome to see you here. Great demos today.

Actions

Demo references

Thank you for your great work. Samples are often showcased in Demos. Request a Demo spot on the call https://aka.ms/m365pnp/request/demo

Open-source project status

ProjectCurrent VersionRelease/Status
PnP .NET Libraries - PnP Frameworkv1.12.0 GA
PnP .NET Libraries - PnP Core SDKv1.9.0 GA
Microsoft 365 Assessment toolv1.0.0 (SharePoint Syntex Assessment)Successor to the Modernization Scanner tool
PnP PowerShellv1.12.0 GA, v2.1.1 GANightly builds
Yo teams - generator-teamsv4.1.0 GA, v4.1.1-preview.2Prepping v4.2.0
Yo teams - yoteams-build-corev1.8.0 GA, v1.8.1-preview
Yo teams – yoteams-deployv1.2.0 GA, v1.4.1-preview
Yo teams - msteams-react-base-componentv3.1.1 GA
Microsoft Teams Toolkitv4.2.4 GA (VS Code), v5.0.0 RC (VS Code), v17.4 (VS), v17.5-preview-2 (VS)New builds daily
Microsoft Graph Toolkit (MGT)v2.10.1 GA, v3.0 preview.1v3.0.0 preview.2 to be released early May
  • Microsoft 365 & Power Platform community videos - aka.ms/community/videos
  • LinkedIn group for discussions and updates - aka.ms/community/Li
  • Open-source assets
    • github.com/pnp
    • github.com/officedev
    • github.com/sharepoint
    • github.com/microsoftgraph
  • Unified Sample gallery - aka.ms/community/samples
  • Product sample galleries
    • aka.ms/teams-samples
    • aka.ms/spfx-webparts
    • aka.ms/spfx-extensions
    • aka.ms/powerplatform-samples
    • aka.ms/list-formatting
  • One place for Open-source initiatives and samples - aka.ms/community/home
  • Microsoft 365 & Power Platform community calls - aka.ms/community/calls
  • Community call agendas - aka.ms/community/meetup
  • Request to Present - aka.ms/community/request/demo
  • Invite (ics) for the Microsoft 3656 & Power Platform call - aka.ms/community/ms-speakers-call-invite
  • Learn how to get started in the open-source PnP community! – aka.ms/sharing-is-caring
  • Community Recognition Program – aka.ms/community/recognition
  • Project Specific
    • PnP Core SDK – aka.ms/pnp/coresdk
    • PnP Framework – aka.ms/pnp/framework
    • PnP .NET Libraries Change Log - github.com/pnp/pnpcore/blob/dev/src/sdk/CHANGELOG.md
    • PnP PowerShell - github.com/pnp/powershell
    • PowerShell Change Log - github.com/pnp/powershell/blob/dev/CHANGELOG.md
    • yo teams – aka.ms/yoteams
    • Microsoft Teams Toolkit – aka.ms/ttk-chat
    • Microsoft Graph Toolkit – aka.ms/MGT
    • MGT Samples - aka.ms/mgt/samples
    • MGT Issues - aka.ms/mgt/issues
    • Independent Publisher Connectors wiki - microsoft/PowerPlatformConnectors Wiki (github.com)
    • Script Samples – aka.ms/script-samples
    • Teams Samples – aka.ms/teams-samples
    • Teams App Support – aka.ms/TeamsApp/Support
    • Power Platform Samples – aka.ms/powerplatform-samples
  • Community Calls Conversations - powerusers.microsoft.com/t5/Community-Calls-Conversations/bd-p/pa_community_calls
  • Feedback on this call - aka.ms/community/calls/feedback
  • Follow us on Twitter for updates - @m365pnp

General resources

Upcoming calls | Recurrent invites

About

Microsoft 365 Development Community bi-weekly calls are targeted at anyone who’s interested in the general Microsoft 365 development topics. This includes Microsoft Teams, Bots, Microsoft Graph, CSOM, REST, site provisioning, PnP PowerShell, PnP Sites Core, Site Designs, Power Automate, Power Apps, Column Formatting, List formatting, etc. topics. More details on the Microsoft 365 community from https://aka.ms/m365pnp. We also welcome community demos, if you are interested in doing a live demo in these calls!

You can download recurrent invite from https://aka.ms/m365-dev-sig. Welcome and join in the discussion. If you have any questions, comments, or feedback, feel free to provide your input as comments below this post as well. More details on the Microsoft 365 community and options to get involved are available from https://aka.ms/m365pnp.

“Sharing is caring”

Microsoft 365 Community (PnP) team, Microsoft - 11th of May 2023