web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Showing the Max Date o...
Power Apps
Unanswered

Showing the Max Date of associated records

(0) ShareShare
ReportReport
Posted on by EtienneV 31

Hello,
I have an "activity" table with a date column. It is related to a "need" table with a search column.

I need to show in a "need" form or column the maximum value of the associated "activity" dates.

 

I can't figure out how to do it in a data-driven app without a canva component.

Calculated columns doesn't seem to do the trick. Formula column neither.

 

Is there any way to display this simple information in a dynamic way?

Categories:
Microsoft Dataverse with Power Apps
I have the same question (0)
  • Mira Ghaly Profile Picture
    Mira Ghaly 11,413 Moderator on at

    @EtienneV 

    Let me recap what I understood you need to get the last activity happened on the need table is that correct?

     

    Is the activity a custom activity table type?

     

    One possible solution would be a flow to update a new field whenever a new activity is added regarding a need.

     

     

  • EtienneV Profile Picture
    EtienneV 31 on at

    Thank you for your quick answer. 
    I will show you below the data structure, it is maybe easier. I want to calculate the max date in yellow.

    "Is the activity a custom activity table type?" > it is a table that I created in dataverse from scratch, maybe I should have used different terminology for my example.

    If possible, I would like to have the date calcultated without a flow, but it seems that a static date column in the "Need" table populated with a flow is the only answer since there is no PowerFX formula available outside custom commands.

     

    Edit: bad translation, it is not a "search column" but a "lookup column"

    data formatdata format

  • Verified answer
    Mira Ghaly Profile Picture
    Mira Ghaly 11,413 Moderator on at

    @EtienneV 

    Since you using normal tables that is not defined as an activity table then you can use a roll-up column.

     

    Please check the below articles here:

    https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-rollup-fields

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans