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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Scheduled Flow using D...
Power Apps
Unanswered

Scheduled Flow using Dataverse List Rows to Aggregate Minimum and Maximum Time columns

(0) ShareShare
ReportReport
Posted on by

I'm trying to aggregate a registration table, summarising check In and Out times by person and group (event).

 

I have a table Registration table with the following fields.

  GroupName
  PersonName
  Time

 

I'm trying to create a scheduled flow to aggregate this...

 

  GroupName  PersonName   Time
  Year 1            Peter               07:55
  Year 1            Mary               08:03
  Year 1            Mary               17:32
  Year 1            Peter               17:47

 

into this...

 

  GroupName PersonName TimeIn TimeOut
  Year 1           Peter                07:55      17:47
  Year 1           Mary                08:03      17:32

 

I'm using the Dataverse List rows action which no longer has an aggregate option as per the older CDS connector.

 

I'm wondering of this is something for odata filters or Fetch XML but so far I'm not making much progress. Aggregate option from the CDS connector is not there on the newer Dataverse connector.

 

Greatly appreciate a steer here.

 

Many thanks,

 

Jim

I have the same question (0)

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

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…

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