cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
24492IV
Level: Power Up

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
Highlighted
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!



Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,838)