the 2nd collection, sometimes it gets records back but sometimes it's empty.
The behaviour I have seen so far are
1. If I switch off the following Preview Features "Relational data, option sets, and other new features for CDS" and "Improve data source experience and Common Data Service views" from the App settings, it would appear to work fine.
2. if I switch off "Improve data source experience and Common Data Service views" from the App Settings, it also seems to work fine.
3. When I have both preview features switched on, the results becomes intermitent.
with both preview features switched on
I add a gallery to the same screen and set the 1st collection as the datasource for this gallery, and add a label in the gallery with TEXT set to "ThisItem.'Related Account'.'Account Name'". Since, it has been working everytime so far.
I don't know if this is just coincidence or what, but could anyone shed some light on this please?