Share
ReportI'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
All responses (
Answers (
1,070
