Update SharePoint List using Common Data Service

(0) Share

Report

Posted on by Power Platform Comm...

Hi,

Is there a way to update SharePoint list using Common Data Service? I have an approval flow with multiple approvals and I need to collect all the responses and update SharePoint List.

All responses (11)

Answers (0)

Community Member on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

it looks like the SharePoint lists are the winners when you look at the performance of two connectors considered. Also when I look at the number of available actions, SharePoint is going to win big time. However, the Common Data Services do have a place in the no code solutions. By separating the data layer (lists) and the presentation layer (apps or web parts) the CDS could be a good way forward. Also the option of proper relation ships between the entities is something that has been missing in SharePoint lists. Yes of course lookup fields can offer you this, but still SharePoint is not a relational database. As always, if we start using the CDS more often in our applications then it will make improving the technology more attractive for Microsoft.
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

Hi @Mira_Ghaly

I have tried this option on one approval, but I am getting an error.

Error:
"Could not find a property named '_msdyn_flow_approvalresponse_approval' on type 'Microsoft.Dynamics.CRM.msdyn_flow_approvalresponse'."
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

Hi @Mira_Ghaly

Thank you. I will try this.
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

@communityuser20

I think you need to try something like this; but in your case this will be corresponding to the 3 Approvals you have started , so you need to list responses per started Approval
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

@communityuser20
Can you check this Blog article:
https://www.itaintboring.com/power-platform/powerautomate-approval-entities-in-cds/
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

Hi @Mira_Ghaly

Thank you for the reply. Unfortunately, this is not what I am looking for. My flow has parallel approvals so I need to collect responses from each approvers and update the SharePoint list. As Common Data Service already collecting the approval data behind the scene I thought I can use it to update the SharePoint list.
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

@communityuser20
I think i have misunderstood you

Please check the below topic discussion on what you need to achieve

https://powerusers.microsoft.com/t5/Using-Flows/Where-are-approvals-stored/td-p/195485
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

This is just a basic approval flow with parallel approvals. My only issue is how to get the data from the Common Data Service and update the SharePoint list.
Thanks.
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

@communityuser20
Yes you can can you please share a screenshot of your flow.
Power Platform Comm... 4 on at

Like (0)

Report

RE: Update SharePoint List using Common Data Service

I have created an approval flow in Power Automate. This flow has multiple approvals, and I need to update the SharePoint list with responses from each approver.
So, if all the approval actions are logged in to the Common Data Service, is there a way to get the data out of CDS and update the existing SharePoint list?

Thank you!