Unanswered

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

(0) Share

Report

Posted on by kaos

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
kaos 17 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
kaos 17 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No