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.
Hi @24492IV,
In your filter Query add customerNumber eq xxxxx, then add a compoe action.
Hope this helps.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsDive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
46 | |
43 | |
36 | |
35 | |
25 |
User | Count |
---|---|
48 | |
38 | |
33 | |
32 | |
31 |