I am trying to add AuditLogs as a subcollection to purchase order lines.
To connect the two I am using the KeyValue property from Audit Logs and a derived field that is the following CONCAT(PoNum, '-', PoLine, '-', 'PoRelease', '-OurSite').
I am able to bring in the subcollection but it does not filter, but brings in every audit log. I have tried changing the LinkBy and other methods but no such luck.
Does anyone know what I could be missing?