Power Platform Community Forum Thread Details

I have a Power App that uses DV as the data source. I have a parent child relationship with the parent as the Task and then the children being all the Task Status Updates. One row per update. I want to capture the last status update per “task”. I can do this in Collections by grouping by the “Task” and recording on the first entry after sorting the group by. Certainly can do that.

But my question is can I/should I try and accomplish the same equivalent outcome but by doing this as a DV view or within XrmToolbox. Why would I do that? Well, I’m thinking it might be more efficient that way and certainly more flexible to used elsewhere in the PP.

So can you group by “a var” sorting by modified on (in descending order) and grab only the 1st row. Thoughts?

Categories:

Microsoft Dataverse with Power Apps

If I understand correctly you want to get the Top 1 associated Status from your list of Tasks, ordered by modified on. You may want to consider using ‘created on’ instead.

What I would probably do is create a “Latest Status” lookup or Text field on the Task table to record the latest entry. Then create a flow that triggers on Status creation (or modification, or both), and send either the Status text to the “Latest Status” text field or a reference to the entire record by referencing the Parent Task.

This will let you use Dataverse views to see the latest status and use them elsewhere on your app. Out of the box features won’t be able to do it, as there is no Top 1, Sorted By filtering available for roll up columns.