. . . . . .

Let’s make something together

KAISPE has been providing solutions and services to customers using Microsoft Dynamics, Azure, Power platform, Oracle NetSuite, mobile and web app development.

    • +1 315 791 4472
      590 Madison Avenue 21st Floor Manhattan, NY 10022 USA.


  • +92 213 432 6085
    Suite#213 Sumya Business Avenue MACHS Karachi, Pakistan.

Parent Child Relationship in Common Data Service (CDS) using Power Automate and Power Portal

  • August 5, 2020

Dealing with Parent Child data in Power Portal and Power Automate scenario’s can be a little challenging. In this blog, I will show you how to handle from Common Data Service and Portal Management.

First of all, we will create two entities.

  • kspInvoiceHeader
  • kspInvoiceLine

Now Create one to many using kspInvoiceHeader “OR” many to one using kspInvoiceLine relationship in between kspInvoiceHeader and kspInvoiceLine.

Now open Portal Management in powerapps, goto Entity Permissions.

Create two entity permissions.

  • InvoiceEntityPermission
  • InvoiceDetailPermission

In InvoiceEntityPermission, Select entity name, your website, and Scope.

I am going to select Contact Scope because I want to display only Current Portal Sign in user data.

Ok! Now for InvoiceDetailPermission, Select entity name, your website and Scope.

Your Scope should be Parent for this.

In Parent Entity Permission, Select the InvoiceEntityPermission and Select relationship which was created on CDS.

Now handling GUID’s from Flow.

I hope you found it useful. If you have any queries, please feel free to contact us [email protected]