ID numbers, reference numbers, ticket numbers…this is something that regularly gets asked to be a part of any SharePoint solution or request based system. My first thought when this is required is “easy, we can just use the SharePoint item ID column and use that”. However, creating a simple calculated column that leverages the in-built ID column is not as easy as it seems.
My first attempt at creating a custom ID column involved creating a new calculated column, and appending some text before the ID and then inserting the ID column into the formula, like this:
The problem with this approach is that when new items are added, the ID appears to “slip” resulting in the custom ID column having no ID number being pulled from the SharePoint ID.
Custom ID column – modern SharePoint
Before you begin you will naturally need to create either a list or library in SharePoint, and the relevant apps checked as part of your O365 license.
2. The setup
Create a new column, with the type Number – I called this ‘solIncrementNum‘
Create a new column, with the type Calculated – I called this ‘solReqNum‘, later renamed ‘Request Number’
In the formula field, add the following: ="SOL-00"&[SolIncrementNum]
For the Data Type, select Single line of text
NOTE: for the Request Number formula if you want to prefix your custom ID with something else just replace what’s between the ” “ in the formula field above.
3. Build the Flow
Flow action: when a new item is created
Create a new flow from the template “when a new item is created, complete a custom action”
Give your Flow a name, I called mine “Populate Solution Request Number”
In the “when a new item is added” step, make sure the site address and list name are the same as the list you built the custom ID column for earlier
Flow: update item
Press + New step, start typing “update item”, select the update item action from the selection
Select the site in question, then copy and paste the List Name from the previous action
Make sure this action has the following fields set:
NOTE: make sure that when you set these fields, that the values you use are coming from the “when a new item is created” action.
Now when new items are created within the list or library, the flow will fire and create a new request number.
Microsoft announced the acquisition of Mover in late 2019, and have been working to bring the service to more customers. Mover is a free service that supports migrations from over a dozen cloud service providers – including Box, Dropbox, Egnyte, and Google Drive – into OneDrive and SharePoint.
Global reader role is now available in new SharePoint admin center
The global reader role will grant users read-only access to all info and settings in the new SharePoint admin center. This feature is related to the global admin role introduced in September 2019 about support throughout all workloads in Microsoft 365.
Microsoft have introduced the sharing settings from the classic SharePoint admin center sharing page, surfacing these settings on the modern sharing page. Key settings include the ability to configure who is allowed to share externally as well as default link permissions for your organization.
Auto updating classic SharePoint team site home pages to the modern template
Classic SharePoint team site home pages that have not been customized will automatically update to a modern home page template. If your site contains only out-of-the box default web parts such as getting started, document library, and newsfeed – it will get updated.
Classic team sites that have been customized will not be automatically updated. Note: this update does not create an Office 365 Group for the team site, which would happen with the creation of a modern team site in SharePoint.
Per-Site Sharing Links can now default to people with existing access
SharePoint admins can now set the per-site sharing links to default to the “people with existing access” setting. Previously, the options were to choose either “Anyone”, “People in my organization”, or “Specific People” when setting the default sharing link on a per-site basis.
Outlook & Teams integrated experience is now available
Microsoft have built a new integration between Outlook and Teams to make it easy to collaborate no matter where the conversation is taking place. The user can move an email conversation from Outlook, including attachments, into a Teams chat or channel conversation by clicking on the ‘’Share to Teams’’ in Outlook.
Targeted communication allows team members to message everyone assigned to a specific tag at the same time; simply @mention the tag name in a post. Using tags, team owners can organize users based on a common attribute, like a role, project, or location.
Admins can control who can add tags and how tags are used across your organization in the Microsoft Teams admin center.
New Files Experience in Teams powered by SharePoint rolled out worldwide
The Teams file experience is now powered by SharePoint, and has now rolled out to 100% of worldwide tenants! This new experience in the File tab of a channel includes the ability to sync files to your computer (PC or Mac), see rich previews across 320+ file types, create views and work with metadata, see document life-cycle signals, review on-hover file cards, pin files to the top, take actions like check in and check out, and much more.
You can now manage apps through the Teams Admin Center. The Manage Apps page provides administrators with a view into all available apps in the tenant and includes information to help them decide which apps to enabled for their organization.
Additionally, the app catalog allows administrators to streamline the process of testing and distributing line-of-business applications.
Pin your apps to the left-hand rail for easy access
You are now able to pin personal apps to the left-hand rail (also known as the Teams app bar). Simply find the app, right-click the app icon, and select “pin”. The Teams Admin can also create group policies so certain apps appear on everyone’s Teams app bar.
QBot is a solution designed for classroom teaching scenarios which allow teachers, tutors and students to intelligently answer each other’s questions within the Microsoft Teams collaboration platform. It leverages the power of Azure Cognitive Services, in particular QnA Maker to achieve this.
Support for migrating OneNote via Known Folder Move
Users with local OneNote notebooks will now have their OneNote’s automatically backed up as a part of the PC Folder Backup move. You can continue saving files to the folders they are familiar with as well as have access to their files in these important Windows folders from anywhere.
Currently in public preview, OneDrive for Mac now respects conditional access for policies such as forced Multi-Factor Authentication, location-based IP range filtering, and device compliance (as managed by Azure Intune). Devices that do not fulfill the conditional access requirements will not be able to sync content.
Currently in public preview, the OneDrive sync client now shares credentials between the rest of the Office suite on macOS.
Accounts that have been signed into Office will now be a selectable option in OneDrive when adding a new account, allowing a user to setup without prompting for password and credentials. Similarly, accounts that have been signed into OneDrive will be available in the Office applications to sign in with.
We are always working towards improving OneDrive and Outlook integration for better user experience. We have now standardized the email notification templates to reflect consistency across products along with adding file previewer thumbnails and activity details.
Canvas components and Power Apps components framework public preview
Canvas components and Power Apps component framework entered public preview this month. Canvas components enable low code makers to create or procure custom components with more advanced capabilities and better scenario fit than what’s available out of the box.
Power Apps components framework on canvas apps experimental release was announced in September 2019 and introduced a way for developers to add reusable field type code components.
AI Builder in the Power Apps canvas studio updates
Styling and control reset
You can now style all AI Builder components in your canvas apps using the color and border pickers, as well as configure the text properties easily in the property panel.
Interact with detected text in Text Recognizer
The Text Recognizer component in Power Apps now surfaces a new output property called Selected. You can interact with the component by clicking on detected text to select them.
Confidence scores and bounding boxes in Form Processor
The confidence scores of selected form fields are now available in Form Processor. In the Results output property, each field and table element has a corresponding key, value, confidence score, and bounding box.
Confidence scores and bounding boxes in Object Detector
You can now see detailed information about all objects detected in your images. For each object detected in an image, you can see the object’s label, confidence score, and bounding box information.
Public preview of multiple image attributes in Power Apps
The Power Apps team have announced the public preview availability of the new Image data type for use in Canvas Power Apps. This preview comes after the Microsoft Common Data Service (CDS) team announcing the availability of a general image data type for entities, in addition to the existing entity image functionality (which allows for a single thumbnail image per entity).
Including the SAP ERP connector, Power Automate saw the addition of 18 new connectors, with now an impressive 315 connectors available! Here’s a rundown of February’s additions:
Cisco Webex Meetings – Cisco Webex Meetings provides cost-effective enterprise solutions for virtual meetings. Host highly secure and scalable web meetings from the Cisco Webex cloud.
Cloudmersive Data Validation – The validation APIs help you validate data. Check if an E-mail address is real. Check if a domain is real. Check up on an IP address, and even where it is located.
Cloudmersive Image Processing – Image Recognition and Processing APIs let you use Machine Learning to recognize and process images, and also perform useful image modification operations.
D7SMS – D7 SMS allows you to reach your customers via SMS over D7’s own connectivity to global mobile networks. D7 provides reliable and cost-effective SMS services to businesses across all industries and aims to connect all countries and territories via direct connections.
}exghts gen. Document & more – }exghts helps you automatically generate documents. Just scan an accepted ID Card or other document and the relevant information will be extracted and automatically inserted into your new document based on a previously configured template.
Egnyte – Egnyte is a content collaboration platform that keeps your files safe, synced, and easy to share. Connect to Egnyte to manage your files. You can perform various actions such as upload, move, download, and delete files in Egnyte.
emfluence Marketing Platform – The emfluence Marketing Platform is a marketing automation platform that allows customers the ability to create, deploy, and track multi-channel campaigns. This connector provides access to the emfluence Marketing Platform API.
EXPOCAD – EXPOCAD is a Professional Event Floor Plan Management Software Specifically Created for Show Organizers and Operations Teams to Manage Exhibitors and Exposition Space.
KnowledgeLake – Integration with the KnowledgeLake Intelligent Content Automation Platform.
ObjectiveConnect – Objective Connect is the trusted file sharing platform which allows organisation to share sensitive documents with external parties. Users can create private workspaces and invite participants in the Cloud in a matter of seconds.
Partner Center Events – This connector allows Microsoft partners to register for specific resource change events related to Microsoft partner center referrals.
Partner Center Referrals – Partner center referrals connector will help Microsoft partners to get a bidirectional sync between their CRM instances and partner center referrals system.
Priority Matrix – Priority Matrix creates a central source of truth to coordinate all the work your team needs to do. Prioritize all your work, share with your team and focus on the high-impact tasks first.
Rencore Governance – Rencore Governance helps you to automate managing your Office 365 tenant.
Robolytix – Robolytix is the key online analytic and monitoring tool for Robotic Process Automation using Sonar technology to evaluate, audit, monitor and improve performance of robots operating in any application, RPA platform or custom solution.
Short URL – Create, update or delete Short URL (Short Links, Tiny URLs) using a custom domain with Click Analytics for any link using the Short URL connector.
Telephony Xtended Serv Interf – Integrate with BluIP’s telephony system to take your call to the next level. Telephony Xtended Service Interface (XSI).
The Power Automate team have announced they are optimizing custom connectors through enhanced validations. This means that all of the connectors you use will see fewer errors when they run, leading to a more consistent, and maintainable, experience.
The Power Virtual Agent team have launched a new capability inside of Power Virtual Agents analytics so you can see how many billed sessions your bot has consumed. This information will help you decide how many sessions you should purchase when upgrading to a paid license.
Use Power Virtual Agents Connector to build Power Automate flows for your bot
A new Power Virtual Agents Connector – a special no-code, UI-based Power Automate Connector, designed to create flows for Power Virtual Agents is now available. The connector provides a UI interface for flow input and output parameters and eliminates the need to hand-craft JSON schema in Power Automate flows.
Access and edit your Power Automate flows from the Power Virtual Agents authoring canvas
Power Virtual Agents now allows you to access and update your Power Automate flows directly from the authoring canvas in one step, without having to open the Power Automate portal and navigating to the corresponding flow Solution manually.
Funnel and pyramid chart by xViz – The xViz funnel and pyramid chart acts as a two-in-one visual. It functions in two different visualization modes: default and 3D mode. It is highly customizable with an extensive deck of properties for configuring every aspect of the visual
OEE Dashboard by 3AG Systems – Specifically designed for the manufacturing and mining industries, OEE Dashboard from 3AG Systems allows operations teams to display Overall Equipment Effectiveness and associated sub-components.
Organization chart by MAQ Software – The organization chart by MAQ Software is a powerful way to display hierarchical information and relationships between different entities. While visuals such as KPI grid by MAQ Software can represent numerical hierarchical information, the organization chart supports displaying images at each node
PI VIZpack by PQ Systems – PI VIZpack by PQ Systems is a collection of eight process improvement charts that provide an easy way to visualize and evaluate process behavior and performance.
Updates to Zebra BI tables and charts – Zebra BI has released a new version (version 4.0.2) of their tables visual. This updated version provides new features that will further enhance the flexibility of table-based and matrix-based reporting.
Microsoft 365 usage analytics – There is now a template application for Microsoft 365 usage analytics. This app helps you better understand how your organization is adopting the many services within Microsoft 365 through cross-product reports, showing usage information over the last 12 months.
NFL analytics by P3 – P3 partnered with professional football statisticians to show the power of Power BI in a fun, entertaining way. This NFL analytics app is powered by approximately 1,500 hours of detailed film review blended with sophisticated calculations and visuals courtesy of Power BI.
Acterys for Quickbooks, Xero & WorkflowMax – The new Power BI Template App for QuickBooks, Xero and WorkflowMax provides you with a professional data model and fully editable Power BI dashboards and reports that integrate your accounting, SaaS data and other sources.
With the initial release of query diagnostics, some users of the Microsoft Store version were unable to run diagnostics if they didn’t have admin rights. With this release, you have the option to support non-admin tracing.
MicroStrategy connector is now generally available – The Power BI team have announced that the MicroStrategy connector is now generally available. The MicroStrategy Dataset Connector for Power BI allows users to fetch data from reports or cubes that reside in MicroStrategy project and import them into Power BI Desktop.
FHIR connector is now generally available – Fast Healthcare Interoperability Resources (FHIR), now generally available, is the next generation standards framework for healthcare data. Microsoft offers a fully managed Azure API for FHIR service, which is a turn-key solution for storing, searching, and exchanging clinical information.
Factset connector – FactSet provides integrated software and data solutions for investment professionals. The FactSet Analytics connector for Power BI brings FactSet’s portfolio analytics, vault performance, and “Style, Performance, and Risk” reports into Power BI through the FactSet calculation engine APIs.
TIBCO connector – Overcome data bottlenecks to make data available throughout the organization with TIBCO. Our market-leading data virtualization capabilities enable you to combine multiple data sources into a single virtual data layer on-demand without copying or moving data.
Jamf Pro connector – Extend the reporting capabilities of Jamf Pro and capture it within your Power BI architecture to quickly share across your organization. Using the Jamf Pro instances API, we collect computer and mobile devices details, installed applications, extension attributes, and their group relationships.
Asana connector – Asana customers can now bring their Asana work data into Power BI with a simple copy and paste. With the Asana connector for Power BI, customers can build custom, actionable dashboards based on Asana inputs such as custom fields.
Microsoft Office app is available for Android and iOS
The new Office app is now generally available, it has all the capabilities of the existing Word, Excel, and PowerPoint apps and requires significantly less phone storage than installing all three apps.
Microsoft 365 Live Events Assistance Program Public Preview is now available
Microsoft is launching a new support service for customers to help deliver live events using Teams, Stream or Yammer. In public preview, the new program provides assistance to help customers better understand functionality, and assist with the setup and delivery of live event broadcasts.
Reply to an Office comment from Outlook using actionable messages
With this update you will be able to save time and collaborate faster with comment and context previews in @mention and comment emails. This implies, when using Outlook, you’ll be able to reply to the comments without even needing to leave Outlook.
Visio for the web now allows collaborators to create, edit, and comment on drawings simultaneously. With live coauthoring and a simple presence indicator, teams can work seamlessly together to brainstorm and develop their ideas.
Creating content from voice has been improved thanks to a new dictation toolbar, suggestions experience, and auto-punctuation support. You can also now work in six new preview languages: Danish, Dutch, Finnish, Swedish, Norwegian, and Japanese.
You can now manage which features are shown or hidden from users in the “What’s New” Office desktop app. This content highlights a list of new features, accompanied by descriptions and guidance to help customers use the features.