Hi! I have an Outreach table that records eac...

[Jessica_Buttime]

Hi! I have an Outreach table that records each interaction with a contact.

The Outreach table has a reference to the Contacts table.

I would like to create a slice of the Outreach table that shows only the LAST entry for each contact. What kind of expression should I use to filter that slice?

[Suvrutt_Gurjar]

@Jessica_Buttimer,Please try the following expression in the referenced rows option in the action.

LIST(INDEX(ORDERBY([Related Outreachs], [Outreach Date column in Outreach table], TRUE),1))

Where [Related Outreachs] is the reverse reference column in the Contacts table

[Suvrutt_Gurjar]

The slice filter condition may be something like

[Outreach Date]=INDEX(SORT(SELECT(Outreach Table [Outreach Date],[Contact_Name]=[_THISROW].[Contact_Name]),true),1)

[Jessica_Buttime]

Thank you @Suvrutt_Gurjar! Worked perfectly and you saved me hours and hours.

[Jessica_Buttime]

@Suvrutt_Gurjar Related question, I would like to create an action for the Contacts table that executes an action on a set of Rows in the Outreach table.

However, I only want the “set” of rows to include the most recent row for that ContactID in the Outreach table.

Do I use something similar for the filter expression for the referenced rows?

I tried this and it is updating the wrong contacts

FILTER(Outreach,[Date]=INDEX(SORT(SELECT(Outreach[Date],[ContactID]=[_THISROW].[Email]),true),1))

ContactID in the Outreach table is a reference to Email in the Contacts table.