I'm using the SLQ conector. My query works great wihtout issues but when I try to use the aggregate option the flow crashes. This is whta I have set up:
The aggregate is: aggregate(Minutes with sum as TotalMinutes)
Minutes is a SQL field as decimal thta I want to sum. I have not been able to egt this to work...any ideas? Also is their a way to GroupBy?
Hi @abm , I had thought of this also...if I remove the aggregate the query works...so the filter is fine... could it be that these don't work together...you can only an aggregate or a filter?
Yes looks like currently there are no support for aggregate against filter conditions. Your other option is try this directly under as a SQL query and expose that as a sql stored procedure. So when you calling from Power Automate you can pass those filter query parameter values to SQL SP.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.