
Hi,
I have an entity (qg_Businesses) which has a number of rollup columns (qg_associatedtable1, qg_associatedtable2, qg_associatedtable3, qg_associatedtable4, qg_associatedtable5, qg_associatedtable6) that show the last modified dates for tables related to qg_business.
I'm trying to use these dates to identify the last time the qg_business record had some activity associated with it, via the other related tables.
I've used Power Automate to pull the values of these rollup fields together, and then found the maximum value and written that to another date field (qg_dateoflastactivity). The issue I have now is that I'm unable to filter out the qg_business rows which have already been updated already.
The logic I'm trying to use is IF qg_dateoflastactivity <= or(qg_associatedtable1, qg_associatedtable2, qg_associatedtable3, qg_associatedtable4, qg_associatedtable5, qg_associatedtable6), THEN return row. I've tried doing this via a fetchxml query (see below), but it still keeps returning all qg_business records instead of just the ones that match my criteria.
Is there another way using Power Automate that I could filter out qg_business records that are have a qg_dateoflastactivity value older than the value of any one of multiple rollup fields?