Forum Discussion

TheJaks's avatar
TheJaks
Copper Contributor
Nov 07, 2022

Issue with Access & Dataverse Long Text Field in aggregate function

Hi all - I've manged to migrate my MS Access application to Dataverse for Teams. Some things required work arounds, and found solutions for almost all, bar this final one issue.

 

I needed to add a new text field to Dataverse to store some text comments. In Dataverse I made this a multiple lines text column. MS Access recognised it is a "Long Text" column.

 

The problem is, that I need those comments to appear alongside other columns through an exisiting Aggregate query. Rather than showing this new column content, I only see the GUID identifier, and issue which I'd never seen before. After some trial& error, the problem seems to stem from the new field being added to Group By in the SQL aggregate query.

 

From what I gather after searching, MS Access cannot run a Group By on a Long Text field...

(1) is that behaviour correct/expected?

(2) I then tried as dataverse columns, "Text Area" and "Text (with 4,000 characters)" , each of which is recognised as Long Text in Access and therefore throws up the same issue. Assuming it is indeed the Long Text in a Group By query, any other workarounds that may help here?

 

thanks!

 

 

 

 

No RepliesBe the first to reply

Resources