question

JonathanFarmer-9122 avatar image
0 Votes"
JonathanFarmer-9122 asked MikeUrnun edited

Dataverse Connector Not Returning All Results When Group By Clause Is Used

I am using the Dataverse connector in a Logic App. I am applying a Group By on the results so I only get results back that are unique for the field in question. Without the group by there are around 2700 results. However when I apply the group by the connector only returns 512 results even though there are around 1600 unique results.

I am wondering if the Pagination Threshold of 5000 is not being respected here? Any one know how I can get it to return all the results?

azure-logic-apps
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi

I have discovered another issue when using an Aggregation transformation of GroupBy. If you don't have a GroupBy all fields of the record are returned. However if you include a GropupBy then on the field you are grouping on is returned for each record. This means you have to loop through an fetch each record in turn if you need access to other fields.

Also the InternalItemID is always 00000000-0000-0000-0000-000000000000 for every record returned.

0 Votes 0 ·

Additionally if I try to use the Expand Query option I get the following.

In the $select if I use the logical name I get "No valid columns passed in the columnset"

If I use the schema name I get "Could not find a property named 'schema_name' on type 'Microsoft.Dynamics.CRM.account'"

This connector seems to be fundamentally broken. Why was the Common Data Service connector withdrawn with such an under baked replacement?

0 Votes 0 ·

@JonathanFarmer-9122 @JonFarmer-1042 The Dataverse connector is currently not available for use with Logic Apps: https://docs.microsoft.com/en-us/connectors/commondataserviceforapps/

The legacy version does support Logic Apps Standard but it'll be deprecated soon in favor of the new one that is yet to be available for Logic Apps.


0 Votes 0 ·

0 Answers