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.

I have the same question (0)

All responses (11)

Answers (0)

Power Platform Comm... 8 on at

Like (0)

Report

@communityuser20
So you want to Create an item in sharepoint list?
Can you please elaborate more on what you need.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

@communityuser20
Yes you can can you please share a screenshot of your flow.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

@communityuser20
Can you check this Blog article:
https://www.itaintboring.com/power-platform/powerautomate-approval-entities-in-cds/

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

Hi @Mira_Ghaly

Thank you. I will try this.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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'."

Was this reply helpful? Yes No