web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

OTB templates access Sub entity data

(0) ShareShare
ReportReport
Posted on by 820

Hi

I want to create a word template(OTB) and i see that i can not access Sub entity data

Relations as follows:

O Have my Order header table where i have a lookup field called car plate number which is a lookup to Cars table

Cars table has a lookup field to Customers table with a name Customer.

 

If i generate OTB template from table Order header - i can access Cars table but i can not access Customers table. Is OTB limited only to 1 level child entity data accsess?

Categories:
I have the same question (0)
  • AhmedSalih Profile Picture
    6,678 Moderator on at
    Re: OTB templates access Sub entity data

    Good morning, @jja , are you filling the OTB in Power Automate?

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • julijazas Profile Picture
    820 on at
    Re: OTB templates access Sub entity data

    @AhmedSalih 

    No. I am filling directly a tgemplate from XML mapping

  • AhmedSalih Profile Picture
    6,678 Moderator on at
    Re: OTB templates access Sub entity data

    @jja, I am not sure about the XML, but I had a similar use case where I used to populate a Word Template in Power Automate and I was able to access multi-level data. 

     

    Let's wait and see if others have some ideas. 

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • julijazas Profile Picture
    820 on at
    Re: OTB templates access Sub entity data

    @AhmedSalih 

    I am simply downloading the template from Dataverse like in this example:

    Dynamics 365 Word Templates in 9 easy steps - Rocket CRM

    And i think this one is limited to only level 1 relationship like if it has 1:N relationship to some table and then this other table has 1:N relattionship to Table2 - you will not get this data.

    I wonder if there is a workaround except filling a template using powerautomate. Out of the box templates would be just perfect.

    maybe @Mira_Ghaly has an idea?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics