Microsoft Dynamics 365 | Integration, Dataverse...

Creating a sortable field for days since modified?

(0) Share

Report

Posted on by jdetmold

We have a need for a field to show the number of days since an opportunity was modified. however we would like to sort a view based on this table. this seems easy enough, I created a calculated field to calculate the difference between DateModified and NOW(). This works great except you can not use it to sort a view. My best guess is Dynamics treats either DateModified or NOW as a calculated field and will not allow sorting by a calculated field if it relies on another entity or another calculated field (this is listed in the documentation.

so the question is, is there any work around?

All responses (3)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi jdetmold,

Yes, I tested it and it couldn't be sorted in the view. There's a limitation that can’t use values in calculated columns on a logical value in the same table to sort data returned by a query as the doc says:

Calculated and rollup columns (Microsoft Dataverse) - Power Apps | Microsoft Docs

You could create another non-calculated whole number field and use a business rule/workflow to populate the value to be the same as the calculated field.

Please refer to this link:

Sorting a calculated field in a view in unified interface | Customer Engagement & Dynamics CRM Forum (crmug.com)
jdetmold 10 on at

Like (0)

Report
Copy link

Link copied!

unfortunately changing a field from a workflow changes the date modified value and makes the data no good
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

I believe you will need to develop the plugin that will do that "calculation" job for you. The key point - it has to be "pre-update" plugin and set the field using the context.