Skip to main content


Lookup field from another List (newest value only)



  • Matthias Walter

    Hi Raoul Dobal,

    you are on the right track and this would be the correct approach using our aggregation functionality in the column configuration. At the moment the Min/Max option does not yet support date fields, but we could implement this in the future.


    Another approach / workaround would be to use a daily scheduled action -> update list item which updates the last visit date using our query function e.g. as follows:

    [[@Web.GetFirstValueForQuery('Activities', '<Where><Eq><FieldRef Name="AccountRef" LookupId="TRUE" /><Value Type="Lookup">[[ID]]</Value></Eq></Where><OrderBy><FieldRef Name=ActivityDateTime Ascending=False /></OrderBy>', 'ActivityDateTime')]]

    Simply adjust the parts in bold to your needs.


    Kind regards


  • Christof Nussbaumer

    Hi Raoul Dobal


    We did release the Min/Max aggregation for date fields with Solution Studio Update 17.01.2020


    Your case is now working with expected aggregation configuration on date field in master list:


Please sign in to leave a comment.