1 / 43

April 10 th , 2019

Donald Donais. April 10 th , 2019. Become an Excel Power User Connecting and Analyzing Your SharePoint Data. Don Donais. Agenda. User Group Goal / Objectives. Develop and support a local community focused on Microsoft SharePoint surrounding technologies

xanthus
Télécharger la présentation

April 10 th , 2019

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Donald Donais April 10th, 2019 Become an Excel Power User Connecting and Analyzing Your SharePoint Data Don Donais

  2. Agenda

  3. User Group Goal / Objectives Develop and support a local community focused on Microsoft SharePoint surrounding technologies • Educate user group members about SharePoint and surrounding technologies • Transfer knowledge within the community • Communicate best practices • Introduce new products / solutions

  4. MNSPUG Sponsors Dedicated Sponsors Sponsorships Levels: • Gold Sponsorship - $500 • Silver Sponsorship - $250 Wrox Press (www.wrox.com) O’Reilly (www.oreilly.com) Avtex (www.avtex.com) Microsoft (www.microsoft.com) SharePoint User Group Support

  5. MN SharePoint Users Group Website • SharePoint Resource Documents • SharePoint Resource links • RSS Feeds • Meeting Schedule • Past User Group Presentations • Past User Group Recordings • Sponsorship Information • http://sharepointmn.com • Email: sharepoint@sharepointmn.com

  6. Social Networking • Linked In group – The most interactive… includes job postings… • Post Job Posting on the Jobs Discussion page • https://www.linkedin.com/groups/1878792 • Twitter tags - @MNSPUG and #MNSPUG • Yammer – Minnesota SharePoint Users Group • https://www.yammer.com/mnspug/

  7. Upcoming Schedule • Next Meeting • May 8th, 2019 – TBD • Microsoft Technology Center, Bloomington, MN • Check www.SharePointMN.com for updates! • Ongoing Schedule • 2nd Wednesday of every month • 9:00 to 11:30 am • Microsoft Technical Center – Edina

  8. Local and Online Events Dashboard in a Day – April 18th @ MTC https://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x64266940001&ch=x5 Minneapolis Nintex User Group – April 25th @ Centennial Lakes 7650 Suite 330 @ 4:30pm https://www.meetup.com/Minneapolis-Nintex-User-Group/events/260307001/ SharePoint Fest D.C. – April 29th – May 3rd @ Washington D.C. https://sharepointfest.com/DC/ SharePoint Saturday Chicago Suburbs – May 4th @ DeVry University, Addison, IL http://www.spsevents.org/city/chicagosuburbs/may2019 App in a Day – May 7th @ MTC https://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x4338556abcd Microsoft 365 Admin Workshop Day – May 17th @ MTC https://mn365.org/event/minnesota-microsoft-365-user-group-may-2019/ SharePoint Conference – May 21st – 23rd @ Las Vegas, NV https://sharepointna.com Anything Else?

  9. Speaker

  10. Don Donais • Office 365 / Enterprise Collaboration Manager • Email: ddonais@spdrummer.net • Twitter: @dondonais

  11. Break

  12. News and Updates

  13. SharePoint Provisioning Service • Published 03/12/2019 • Public Preview • Provision sites from the SharePoint Look Book • Sample pages and images • Sample news articles • Office documents as a sample content • Site designs and site scripts • Tenant themes • SharePoint Framework solutions with web parts and extensions • Microsoft Graph or 3rd party API permissions • Tenant taxonomy settings • Hub site configuration • Site collections • Requirements • Tenant Admin • Service: https://provisioning.sharepointpnp.com/ • More Information: https://developer.microsoft.com/en-us/sharepoint/blogs/explore-sharepoint-designs-with-the-preview-of-the-sharepoint-pnp-provisioning-service/

  14. Rich Text Formatting in Yammer • Published 03/13/2019 • Write posts with • Bold • Italics • Links • Bullet points • Numbered lists • Composing available via web • Mobile app will render correctly • Rollout • Start – over the next week • Completion – mid-May 2019 • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC175765

  15. Upgrade CDS database to preserve Flow Approvals history • Published 03/13/2019 • Approval data is stored in CDS • Deadlines • Start first step before March 15, 2019 • If you haven’t done this database will be disconnected • Data stored for 30 days • If you want to reconnect, contact support before March 29, 2019 • Complete upgrade by April 15, 2019 • More Information: https://powerapps.microsoft.com/en-us/blog/remember-to-upgrade-your-previous-version-cds-database-to-preserve-flow-approvals-history-or-entity-data/

  16. SharePoint News Enhancements • Published 03/13/2019 • Features • Organize News • Authoritative News • News Notifications • Page Templates • Rollout • Targeted Release – End of March 2019 • More Information: https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/SharePoint-News-Enhancements-March-2019/ba-p/366585?_lrsc=a71703f3-53bb-4454-9bdc-47dd63bca976

  17. SharePoint Framework v1.8 • Published 03/14/2019 • New Features • App Pages • SPFx components as Teams tabs • Isolated web parts • Previews • SPFx Library Components • Teams Tabs in SharePoint • More Information: https://developer.microsoft.com/en-us/sharepoint/blogs/announcing-the-general-availability-of-sharepoint-framework-1-8/

  18. Flow - Adaptive Cards for Teams and US Government • Posted 03/15/2019 • Features • Adaptive Cards • Microsoft Flow for Government is GA • Spring 2019 • Dynamics 365 • Microsoft 365 • Office 365 • Supports compliance • FedRAMP High • Requirements for Criminal Justice • New connectors • Streamlined authoring for business process flows • More Information: https://flow.microsoft.com/en-us/blog/adaptive-cards-for-microsoft-teams-microsoft-flow-us-government-now-available/

  19. Updates to Microsoft Whiteboard • Posted 03/15/2019 • Changes • Microsoft Whiteboard available product in Office 365 • For Surface Hubs, the legacy application will be upgraded • Rollout – over the next 3-4 months • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC175885

  20. Microsoft Teams for Firstline Workers: Microsoft Graph API for Shifts • Posted 03/15/2019 • Rollout • Start – mid-March • Completion – end of March 2019 • GCC Excluded • Scenarios • Create, read, and update Schedules and Schedule Groups • Create, read, update, and delete Shifts and shift activities • Create, read, update and delete time offs, time off reasons, and time off requests • Track the last change date of any of these items from Shifts service • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC175839

  21. Retirement of protection.microsoft.com • Posted 03/15/2019 • Beginning April 15th • End of March GA for • M365 Security Center • M365 Compliance Center • Use protection.office.com instead • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC175899

  22. Microsoft Forms Pro Preview • Published 03/18/2019 • Dependencies • Built on top of Microsoft Forms • Leverages Common Data Service • Features • Send survey based on trigger • Inject CDS data into survey • EDU and GOV tenants excluded • Will be a paid service once GA • More Information: https://techcommunity.microsoft.com/t5/Microsoft-Forms-Blog/Microsoft-Forms-Pro-is-available-in-Preview-today/ba-p/369625

  23. Microsoft Teams News • Published 03/19/2019 • Chat and Conversations • Secure Private Channels – later this year • Information Barriers – coming soon • Meetings • Calendar App – April 2019 • Live Captions – coming soon preview for English • Customized Backgrounds – coming soon • Content Cameras – coming soon • Microsoft Whiteboard – commercial preview • Live Events – now available • Meetings First – preview • Calling • Direct Routing – now available • Hybrid Voicemail • Office 365 • App Setup Policies – rolling out • eDiscovery & DLP – generally available • More Information: https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/What-s-new-in-Microsoft-Teams-the-Enterprise-Connect-feature/ba-p/376255

  24. PowerApps – Document Library Support • Published 03/20/2019 • Libraries as a data source in canvas apps • Media Controls • Image • Video • Audio • Limitations • Can’t upload files from PowerApps to a library • Can’t show PDF files from a library in PDF Viewer control • PowerApps Mobile doesn’t support Download function • More Information: https://powerapps.microsoft.com/en-us/blog/sharepoint-online-document-libraries-now-supported/

  25. Autodesk integration for DWG files • Published 03/21/2019 • Open DWG files in AutoCAD (web app) • Command bar • Pop-up menus • Services • OneDrive for Business • SharePoint Online • Administrators can disable through PowerShell • Rollout • Start – Targeted Release mid-March • Worldwide Completion – end of March • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC176240

  26. PowerApps – GCC General Availability • Posted 03/22/2019 • PowerApps for Government is GA • Spring 2019 • Dynamics 365 • Microsoft 365 • Office 365 • Supports compliance • FedRAMP High • Requirements for Criminal Justice • More Information: https://powerapps.microsoft.com/en-us/blog/powerapps-for-us-government-is-generally-available/

  27. Multi-Geo in SharePoint and Office 365 Groups • Published 03/27/2019 • General Availability • Add-on subscription • Minimum 2,500 Office 365 users • More Information: https://techcommunity.microsoft.com/t5/Office-365-Blog/Now-available-Multi-Geo-in-SharePoint-and-Office-365-Groups/ba-p/263302

  28. Praise in Microsoft Teams • Published 03/27/2019 • Send Praise badges to colleagues • On by default • Rollout • Start – today • Complete – late April 2019 • GCC Excluded • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC176548

  29. Microsoft Forms – What’s New in March • Published 03/28/2019 • Features • Email Confirmation Receipt • Deeper Forms Integrations with Office Apps • Teams bot • Admin can transfer form ownership • Bing image search admin control • Match Keyboard Support • External Sharing for Government Customers • More Information: https://techcommunity.microsoft.com/t5/Microsoft-Forms-Blog/Microsoft-Forms-What-s-New-in-March/ba-p/390415

  30. Increasing access to Microsoft Search • Published 03/28/2019 • Brining Microsoft Search to: • SharePoint • Office.com • Bing.com • Unified search experience • People • Bookmarks • Groups • Locations • more • Moving search box to consistent top location • Rollout • Targeted Release – Late April • Worldwide – end of May 2019 • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC176702

  31. New CSOM and SPO PowerShell versions • Posted 03/29/2019 • PowerShell Cmdlets • Enable-SPOCommSite • Get/Set/Remove-SPOHomeSite • Set-SPOOrgAssetsLibrary • CSOM Methods and Properties • public property Microsoft.SharePoint.Client.Web.SearchScope • public method Microsoft.Online.SharePoint.TenantAdministration.Tenant.EnableCommSite • public method Microsoft.Online.SharePoint.TenantAdministration.Tenant.SetOrgAssets • public method Microsoft.Online.SharePoint.TenantManagement.Office365Tenant.SetOrgAssetsLib • More Information: https://developer.microsoft.com/en-us/sharepoint/blogs/new-sharepoint-csom-version-released-for-sharepoint-online-march-2019/

  32. OneDrive for Business (Groove.exe) Office document Collaboration • Published 03/29/2019 • Beginning September • Co-authoring not available through old sync client • Rollout • September 2019 monthly update (Version 16.0.12129.XXXX) • Also next semi-annual channel release in January 2020 update • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC176781

  33. March 2019 updates for PowerApps • Published 04/01/2019 • Canvas Apps • Create responsive expressions for Height and Width • International region updates for Mexico and UK • SharePoint document library support • Work with friendly display names using SharePoint • Model-Driven Apps • Autonumber fields supported by modern entity designer • Work with friendly display names using CDS • More Information: https://powerapps.microsoft.com/en-us/blog/march-2019-updates-for-microsoft-powerapps/

  34. Microsoft Flow Updates • Published 04/01/2019 • Features • Flow embedded in Azure IoT Central • Gateway cluster management • Flow checker and designer improvements • More Information: https://flow.microsoft.com/en-us/blog/microsoft-flow-is-integrated-in-azure-iot-central-and-more/

  35. SharePoint Roadmap Pitstop: March 2019 • Published 04/01/2019 • SharePoint Updates • Organization News • Pin News • Share documents with LinkedIn connections • Page templates • Updated sharing page in admin center • Sticky headers for lists / libraries • Related Technologies • Yammer tab in Teams • Copy a Planner plan • Planning in Teams for GCC • Live Events goes GA • Windows Virtual Desktop public preview • New Microsoft 365 Admin Center • April Teasers • Connected web parts for SharePoint • News audience targeting • More Information: https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/SharePoint-Roadmap-Pitstop-March-2019/ba-p/392013

  36. OneDrive Roadmap Round-up: March 2019 • Published 04/02/2019 • OneDrive Updates • Per Machine Sync Client preview • Live Captions & Subtitles in PowerPoint • A new OneDrive personalized provisioning flow • A script to check Known Folder Move status in your organization • More Information: https://techcommunity.microsoft.com/t5/Microsoft-OneDrive-Blog/OneDrive-Roadmap-Round-up-March-2019/ba-p/392144

  37. New To-Do feature • Published 04/02/2019 • Integration with To-Do and Planner • “Assigned to me” list • See and edit tasks • Appear in To-Do search results • My Day suggestions • Planned smart list • User Opt-In via To-Do Settings menu • Rollout • Start – April 2019 • Completion – end of May 2019 • GCC Excluded • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC176992

  38. Microsoft Teams - Easily add new members to your team • Published 04/02/2019 • Team members sends join request on behalf of another member • Team owner(s) get notification to accept or deny • Also adding support for in-app notifications for self-join requests • Rollout • Start – early April • Completed – mid-April 2019 • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC177013

  39. PowerApps – Delegation enhancements • Posted 04/05/2019 • Filter on lookup non-primary key fields • Delegate the StartsWith and EndsWith functions • Delegate with Today, Now and Date functions • Delegate with AddColumns function • More Information: https://powerapps.microsoft.com/en-us/blog/delegation-enhancements-for-lookups-today-now-and-addcolumns/

  40. Audience targeting in SharePoint Online organizational news • Posted 04/09/2019 • Allow page authors and site owners to tag • News pages • News posts • Target Azure AD Groups • Rollout • Targeted Release – mid-April • Completion – June 2019 • Message Center: https://admin.microsoft.com/AdminPortal/home?switchtomodern=true#/MessageCenter?id=MC177427

  41. Recent Innovations in Yammer • Posted 04/10/2019 • Features • Live Events in Yammer • Yammer Tab in Teams • Microsoft Search includes Yammer • Rich Text Formatting • Yammer Conversations web part • More Information: https://techcommunity.microsoft.com/t5/Yammer-Blog/Recent-Innovation-in-Yammer/ba-p/420246

  42. Closing

  43. Last But Not Least Thanks for coming! • Please Fill Out Evaluations • Participants Eval • http://bit.ly/MNSPUGSurvey • Today’s Presenters: • Don Donais

More Related