cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mammifero
Frequent Visitor

dataverse implementation vs. sharepoint list

Dear All, Good Morning from Italy (forgive my bad English)

i ask for a friend 😀 

 

i would like to develop a mobile application with PowerApps for my sales team (4 people)

in front of me i have 2 path:

Sharepoint List (i have a "good" knowledge)

Dataverse database (no prior knowledge)

 

i have an Excel table that contain our customer contacts, and i have to decide if make sense to split in 3 parts

 

list/table 1 with the name of the SalesAgent  (4 people)

list/table 2 with the name of the Companies (around 600 unique rows)

list/table 3 with the name of the Contacts inside the Companies (around 1.500 rows)

 

do you think that Sharepoint List is ok

or

i need to study a little bit more for implement 3 Dataverse tables ?

 

is correct to implement a lookup in the following manner ?

list/table Companies with a lookup to SalesAgente

list/table Contacts with a lookup to Companies 

 

2 REPLIES 2
EricRegnier
Super User II
Super User II

Hi @Mammifero,

Although I might be slightly biased towards Dataverse, I would highly suggest to use Dataverse and is fairly simple to learn and get started. SharePoint is quite more limited, for example:

  • Doesn't support relational data model
  • Deployments/releases are much more limited as you are "meant' to configure directly in prod and doesn't support solutions. You'll need to "hack" the power app to deploy from dev to prod.
  • Max number of records/rows, whereas Dataverse not really.

More info on Dataverse: https://powerusers.microsoft.com/t5/News-Announcements/Dataverse-is-not-a-database/ba-p/756215

Hope this helps!

 

Fubar
Solution Sage
Solution Sage

Relational data = Dataverse/Dynamics 365 Sales, or SQL

Unstructured data = SharePoint

 

Also, think of future extension and expansion.  Suspect you are after more of a CRM than SharePoint - Dataverse will give you Contacts and Accounts (Organisations) out of the box plus a lot more, Dynamics 365 for Sales will give you a whole lot more from a sales point of view.

 

As per Eric I am a little bit biased as the CRM/Dynamics 365 is my background - but you need to use the tool that works best with the type of data that you will be handling.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (41,583)