Sort repeating group by other type

Hi there,

I have two types in my data types: User and Messages.

In the User Table, every User has a List-Field (field type: list of users), where I store the unique IDs of all ‘MatchedUsers’.

In a different data type, called ‘Messages’, I store all messages with the fields messageReceiver, messageSender, messageContent, Created Date…

Now I would like to show all MatchedUsers for the CurrentUser(works), sorted by the creation date of the last message. Just like in all common chat apps.

How can I sort the list of users based the creation date of the other data type?

Thank you for your hints
Cheers Marco

This topic was automatically closed after 70 days. New replies are no longer allowed.