Customer experience | Sales, Customer Insights,...

Age Calculation Plugin Trigger

(0) Share

Report

Posted on by alexiscool3104

Hello,

I've created a C# plugin to calculate age based on a date of birth in my people table.

I want to re-calculate age everyday, for every record in the table.

Question is, what's the best way to fire this plugin?

Cerainly on create of the record. But how should i re-calculate?

I want to minimise calls to dataverse using power automate.

How can i trigger the plugin for each row everyday? It can't be triggered by a calculate column, and most records would not have daily changes.

Should i refactor to the plugin to loop through all people records, updating each within the same plugin call? if so, how should i trigger this mass update?

Thanks!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi alexiscool3104,

Scheduled Power Automate flows are more suitable than plugins for implementing this requirement, but calculated fields are the best solution.

Was this reply helpful? Yes No
alexiscool3104 on at

Like (0)

Report

Thanks for your response!

Calculated fields aren't an option for me, i need to the data to be completely accurate and reflective of western age format (round down).

How would you suggest i use scheduled flows to trigger this plugin?

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi alexiscool3104,

I am not suggesting that you use scheduled flows to trigger your plugin, instead I am suggesting that you create a scheduled Power Automate flow that runs once a day. In the flow, get all users with a populated date of birth field, get the difference between the date of birth and the current date for each user, and then set the age field to the rounded down difference for each user.

Alternatively, you can change the precision value of your field to 0 decimal places or wait for the release of formula columns.

Was this reply helpful? Yes No
Suggested answer

ankit_singhal 560 on at

Like (0)

Report

You can use the scheduled Power Automate and run once a day. Fetch a record list of your entity and apply your logic for calculation age. It will update age on all records every day.

Was this reply helpful? Yes No