cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 III
Super User III

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

Power Automate Video Tutorials

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (9,389)