Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Build your Apps in MS Teams with MS Dataverse for Teams

by Danish Ali Detho | O365 & Power Platform Solution Architect

MS Teams has become one of the most widely used tools for team collaboration and communication in organizations using Microsoft echo-system for their digital workspace. But when you need a quick and easy way to store and track some data, you probably turn to SharePoint Lists or Excel for the data storage. Although they are both tightly integrated with MS Teams but wouldn’t it be great if the solution completely lives within MS Teams. That’s where MS Dataverse for Teams comes in which is a cut-down and most importantly free version of Microsoft Dataverse that provides a low-code development environment for building Apps, Chatbots, and Flows all within Microsoft Teams.

It allows users to easily create data tables with an Excel-like experience, but with the benefit of a relational database that can handle much bigger datasets and manage relationships. In this blog, we will take a deep dive into MS Dataverse for Teams and how is it different from Dataverse, what are the main features and how to set up within your Teams environment.
 

What is MS Dataverse for Teams? 

 MS Dataverse for Teams provides citizen developers/business users a built-in, low-code data platform for Microsoft Teams where they can build applications that are accessed directly from Teams. It provides a subset of the functionality of Microsoft Dataverse (formerly known as CDS) for Teams users and the best part is that it comes free (with capacity limits) and doesn’t require any additional license. Each team has its own Dataverse and as soon as you create an application in Teams, a Dataverse will be built for that team for their applications which starts out as empty and you then build your own custom tables for your business objects and teams. 

How is it different from MS Dataverse?

Microsoft Dataverse for Teams is a lite version of Dataverse (formerly known as the Common Data Service), which is the enterprise-grade data platform underneath Dynamics 365 and the full Power Platform. It provides some great features for building applications in MS Teams platform however it does lack some features which are available in the Dataverse which are covered below. 

Feature  Dataverse for Teams MS Dataverse 
Data types  Supports Basic datatypes   Supports Basic & Advanced data types (Customer, Accounts) 
Relational storage  Provides Relational storage (Tables)  Provides Relational storage and Non-relational storage (Logs) 
Common Data Model  User table only  Full support  
Capacity  Up to 1 million rows and
2000 API calls per day per user 
No specified limit on rows.
No specified limit of files or images.
2,000 API requests per day with the option of capacity add-ons. 
Security  Owner, Member, Guest roles
Share app with Azure AD group 
Extensive security options based on roles, business units & teams.
Clients  Teams  Teams, Power Apps, Power Apps portals, Dynamics 365, custom code 
Custom development capability  Not supported  REST API, Software Development Kit (SDK), Plug-in Support 
Solution for deployment  Single unmanaged solution per environment  Unlimited 
Add-on capabilities  Not available  Workflows, Business rules, Calculations and rollup

Main Benefits and Limitations of Microsoft Dataverse for Teams 

Benefits 

  • Support to build low-code and no-code apps flows, and chatbots for and within Teams.  
  • No additional licensing is required to use. 
  • Guest users can run Apps and have access to the data they created. 
  • Core data capabilities from the same Dataverse platform.
  • A new visual editor that makes it even easier to define and populate table data. 
  • Support for 5 teams plus 1 additional team for every 20 licensed users. 
  • Upgradability to MS Dataverse. 

 Limitations 

  • The maximum data size is 10GB + 2GB per Dataverse environment (max of 1TB total capacity per tenant). 
  • Apps are only accessible via the Teams App or mobile App. 
  • There is no API access to Dataverse for Teams data. 
  • Apps are only accessible via the Teams App or mobile App. 

Setting up Dataverse for MS Teams 

This part is super easy and the Dataverse for Teams environment is automatically created when you create the first App in Microsoft Teams or install a Power Apps app from the app catalogue for the first time. Each team can have one environment, and all data, apps, and flows created inside a team are available within the MS Team’s Dataverse. Power platform Admins can see all the MS Teams Dataverse instances created by going to Power platform admin ->  Environments. 

Conclusion 

Microsoft Dataverse for Teams provides a super easy and convenient way to create Apps that completely lives within MS Teams platform which also supports relational data storage, rich data types, enterprise-grade governance, and one-click solution deployment. It does lack some important features which are available in MS Dataverse like core tables representing common business objects but they are on the roadmap for Dataverse for Teams and will be available soon. If you are looking to build an app and keep your data stored in one place where you are already working every day i.e. MS Teams along with associated collaboration and documents then MS Dataverse for Teams is the way to go. 

Latest articles

AxioWorks Newsletter February 2024: Partnerships, Upcoming SQList Update, and Summit Invitation

27 Feb 2024

Hello Reader, This February has been pivotal for AxioWorks as we’ve focused on laying strong foundations for the year. Here are the key […]
[read article]

How AxioWorks SQList Aligns With the Priorities of Software Buying Decision Makers

26 Feb 2024

As outlined in the “2024 Global Software Buying Trends” report by Gartner Digital Markets, the criteria that predominantly influence […]
[read article]

Maximising Power BI Reporting from SharePoint: The Strategic Advantage of AxioWorks SQList over Native Connectors

15 Feb 2024

In today’s data-driven environment, making informed decisions rapidly can offer a significant competitive edge. This is where Power BI comes […]
[read article]

AxioWorks Newsletter January 2024: A Promising Start to the New Year!

29 Jan 2024

Hello Reader, We hope this newsletter finds you well and thriving. At AxioWorks, we are embracing the new year with great enthusiasm and are […]
[read article]

Exciting New Partnership and Innovative SharePoint Tools from AxioWorks and Lightning Tools

17 Jan 2024

AxioWorks is excited to announce a strategic partnership with Lightning Tools, a leader in creating innovative SharePoint components. This […]
[read article]

AxioWorks Newsletter November 2023: ESPC23, new partnership, and SQList update!

30 Nov 2023

Hello Reader, Welcome to this month’s edition of the AxioWorks newsletter! We’re thrilled to bring you updates on our recent […]
[read article]

Why Support Legacy SharePoint Versions Like SharePoint 2010?

16 Nov 2023

In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
[read article]

Why Companies are choosing SQList over Power Automate

30 Oct 2023

In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
[read article]

AxioWorks Newsletter October 2023: An exhilarating month.

28 Oct 2023

Hello Reader, As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
[read article]

Why Choose SQList for SharePoint Data Extraction Over DIY Solutions

16 Oct 2023

In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*