Hi
I've got two dataverse tables
One is a parent of the other.
When selecting the parent, I want the child table to add all relevent content into a collection.
Set(myChapterTitle, ThisItem.vca_chapterid);
ClearCollect(filteredContents, Filter(Contents, vca_Chapter.vca_chapterid = myChapterTitle));
However the collection is blank when I do this.
I've tried adding both tables to seperate collections, however the relationship appears as a ? in the collection so I can't filter.
surely there is an easy way to do this?
Thanks
