Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Dataverse View/XRM Toolbox

(1) ShareShare
ReportReport
Posted on by 646

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:
  • ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Dataverse View/XRM Toolbox
    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. 
     

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics