You’re offline. This is a read only version of the page.
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
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (