SQL Server & ODATA Queries

[24492IV]

Hi,

Wondering if it's possible to get some help / insight.

Say I have a table containing all sales data and i'm connecting to this using the SQL Server connection.

My sales table has columns: orderNumber, customerNumber, orderDate, orderAmount.

Can anyone explain how I can use the ODATA options in the SQL connector to count the number of orders by customerNumber? For example - I only want to return results where a customer number only appears once in the table.

I've tried various aggregate queries i've found online but haven't managed to succeed yet.

Thanks in advance.

[abm]

Hi @24492IV,

In your filter Query add customerNumber eq xxxxx, then add a compoe action.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-get-a-count-of-the-number-of-rows...

Hope this helps.

Thanks