why distinct is not allowed in SQL Server query of OData ?

(0) Share

Report

Posted on by ShivaPatpi Microsoft Employee

I am trying to fetch the rows from which I don't need duplicate rows.

in SQL I can use distinct but if I use distinct in OData SQL Server query filter it is not allowing...

what is the reason ?

I have the same question (0)

All responses (4)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: why distinct is not allowed in SQL Server query of OData ?

Hi friend what I know is that in ODATA you can do this operations

System Query Option $filter
System Query Option $orderby
System Query Option $top and $skip
System Query Option $count
System Query Option $expand
System Query Option $select
System Query Option $search

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: why distinct is not allowed in SQL Server query of OData ?

Hi @ShivaPatpi ,

Could you please show us how you configure specific actions?

Best Regards,

Was this reply helpful? Yes No
ShivaPatpi Microsoft Employee on at

Like (0)

Report

Re: why distinct is not allowed in SQL Server query of OData ?

I used this work around
https://powerusers.microsoft.com/t5/Connecting-To-Data/Use-distinct-on-SQL-connector-query/m-p/160675#M3529
but my question still remains the same:

Why should I get duplicate values from SQL
later on why should I do additional work to remove the duplicates by setting the variable and followed by union.

why can't we have a feature request to get rows from SQL in that ODATA select statement itself ?

Was this reply helpful? Yes No
takolota1 4,944 Moderator on at

Like (0)

Report

Re: why distinct is not allowed in SQL Server query of OData ?

If you were looking to get distinct records without using the Execute a query action, then you could use this template: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Distinct-Records/td-p/2191533

Was this reply helpful? Yes No