How to Connect a CDM Entity to SharePoint List?

(0) Share

Report

Posted on by Yahya Manasrah

515

How I can see read/write data in a CDM entity inside a SharePoint List?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, one way to do this is to copy the data in your CDS Entity to a SharePoint list by using Flow.
Basically set up flows to create the same item in a SharePoint list when the item is created in CDS, and a separate flow for when the item is edited.
The only current issue is that there is no trigger for flows when a CDS item is deleted.
Please add your kudos to the following post if this could be useful to you:
https://powerusers.microsoft.com/t5/Flow-Ideas/Trigger-for-when-CDS-Common-Data-Service-record-is-deleted/idi-p/17897

Was this reply helpful? Yes No
Yahya Manasrah 515 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Meneghino, from my point of view, there should be seamless READ/WRITE connection between CDM Entity and SharePoint List far from Flow. Flow itself will always have limitation (number of runs, the delete trigger you are referring to), besides, READ/WRITE means i can Edit anywhere in CDM OR SPO List hence see my edit in the other places. I think all needed is that Microsoft adds to SPO the possibility to use CDM Entity as external data source.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Clear, agreed.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Yahya,

Thanks for your suggestions.

Currently there is no way available to Read/Edit CDM entity from SharePoint List directly.

Under SharePoint list new View would have Flow and PowerApps as available option, but there is no information (or saying connections) regarding common data service.

For Common Data service entity and SharePoint list integration, please consider submit an idea under the PowerApps idea forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards

Was this reply helpful? Yes No