Hi there,
I have 2 custom data entities in Dynamics Fin&Ops where entity A has ID(1) and Description columns and entity B has its own ID(2) and the ID(1) from the entity A columns. I am trying the following to create my own collection which consists of ID(2), ID(1) (basically entity B) but also looked-up Description from entity A associated with the corresponding ID(1).
ClearCollect(MyCollection, AddColumns(entity B, "MyDescription", LookUp(entity A, 'ID(1)' = 'ID(1)').Description));
I am getting the collection created with the added "MyDescription" column, but each row has the same Description retrieved although each ID(1) has a different Description. I suspected it was because the columns are called the same ('ID(1)') and the logic gets confused - this is when I experimented with AddColumns and RenameColumns to get the lookup to search against a column with different name but with the same content - the same result. I've also tried to collect the data from data entities and use those collections in my formula but again, same result. I may end up changing the data entity B itself to have the description already part of it but I feel I'm so close!
Thank you for any advice.
