Create an app with relationship data with Sharepoint?

(0) Share

Report

Posted on by carem

120

I read an article here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/northwind-orders-canvas-part1

to build an app with the relationship data with CDS.

I want to build an App like that, like a CRM to manage Orders, Products, Customers...

But I wonder can I build it with Sharepoint and what is the difficulties I encountered if using Sharepoint were databases instead of CDS.

I am very concerned about this issue, looking forward to the dedicated answer

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

PytByt 943 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @carem

I dont think the Sharepoint and the CDS have very significant differences. However, please reference to this article that help me before:

https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/

And see if this helps.

Cheers.
pytbyt
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

HI @carem ,

Based on the needs that you mentioned, I think PowerApps could achieve your needs. You could generate an app based on your SP List data source.

Please refer to the following video for help:

https://www.youtube.com/watch?v=BnYe_7fpZRM

More details about the difference between CDS and SharePoint, please check the following article:

http://powerappsguide.com/blog/post/excel-vs-sharepoint-vs-sql-server-vs-cds

CDS and SharePoint are both delegable data source in PowerApps, in terms of delegable functions, operators supported in CDS and SharePoint, they are different.

Delegable functions, operators supported in CDS

Delegable functions, operators supported in SharePoint

In addition, the CDS is a buil-in database within PowerApps, which would have an advantage on data process speed than SharePoint.

Best regards,
carem 120 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for both answers.
Both answers indicate that at the present time, the Azure SQL server is the most likely option if an app developer knows how to use SQL queries.
I want to ask more about the cost, in my opinion, SQL Server is still much cheaper than CDS right?