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 new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.