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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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 Kudoed Authors
Users Online
Currently online: 257 members 5,068 guests
Please welcome our newest community members: