Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Add record to collection/variable with nested/related record in Dataverse

(0) ShareShare
ReportReport
Posted on by 17

Hi,
Is it correct that when you add a record to a collection or variable, the related nested fields is not accessable ?
I try to add "Orders" to a variable that have "Customer" as a nested record defined by a relationship in dataverse. 

When Orders is added to the variable like "set(varOrder;Lookup(Orders; OrderID = XXXX))", i cant access the related record like "varOrder.Customer.BusinessName"

Is that normal behavor and a lookup is needed?

 

Thanks,

 

Categories:
  • kaos Profile Picture
    kaos 17 on at
    Re: Add record to collection/variable with nested/related record in Dataverse

    When accessing the variable, tables marked with yellow is not accessible. That confirms that varOrder.Customer.BusinessName is not available. The picture does not show the Customer relationship,  but other metadata that is also not available.

     

    Do I miss something?
    variable.png

  • Nogueira1306 Profile Picture
    Nogueira1306 7,390 on at
    Re: Add record to collection/variable with nested/related record in Dataverse

    varOrder.Customer.BusinessName this field might be empty.

    If you say that the var has info and everything is good, if you put that on a label it should appear with no problem unless it has no info, of course

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,
    Gonçalo Nogueira

    Check my LinkedIn!

    Check my User Group (pt-PT)!

    Last Post on Community

    My website!

  • kaos Profile Picture
    kaos 17 on at
    Re: Add record to collection/variable with nested/related record in Dataverse

    var is not empty. That is confirmed by accessing the variable manually with the IDE.

  • Nogueira1306 Profile Picture
    Nogueira1306 7,390 on at
    Re: Add record to collection/variable with nested/related record in Dataverse

    var is probably empty, it cant find nothing with that order ID

    You can check that with IsEmpty or IsBlank function

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,
    Gonçalo Nogueira

    Check my LinkedIn!

    Check my User Group (pt-PT)!

    Last Post on Community

    My website!

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard