I have a parent table (Milestones) with a child table (Activities). For the Milestone's Start date I want to write a function that finds the start date for the first activity of the Milestone.
Here is my logic:
Thanks,
Dangers of free-typing code - I see that now.
The only thing you missed was, the field that needed to be displayed in the lookup function. So:
With(
{
wActive:
Sort(
Activities,
DateStarted,
Descending
)
},
Lookup(
wActive,
MilestoneID = selected_record.MilestoneID, DateStarted
)
)
Really useful though, thank you @WarrenBelz !
Hi @dataguy33 ,
I am assuming here that selectedRecord.MilestoneID is a Variable matching the field MilestoneID in Activity. If so, try this
With(
{
wActive:
Sort(
Activities,
DateStarted,
Descending
)
},
Lookup(
wActive,
MilestoneID = selected_record.MilestoneID
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2