cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
24492IV
New Member

SQL Server & ODATA Queries

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.

 

2019_02_08_13_30_57_Window.png

 

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


Thanks in advance.

1 REPLY 1
Super User
Super User

Re: SQL Server & ODATA Queries

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,601)