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,
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?
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!
var is not empty. That is confirmed by accessing the variable manually with the IDE.
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!