Creation of a large set of records by clicking a button on the ribbon

(0) Share

Report

Posted on by EBMRay

905

Hello everyone,

I have a list of employees 3000+ in a custom table and I want to perform a calculation for their salaries based on different conditions and validations on a monthly basis.

Please find below the scenario that I want to achieve:

I want to add a button on the employee view page table that will be visible on the ribbon command bar. When the HR click this button, a background process should be triggered (other than power automate as it may cause throttling issues or also a plugin due to 2min timeout) that should validate the data based on the conditions that we will develop in the code and perform the creation of the large set of records in another custom table in dataverse.

I mentioned a large set of records because for every employee the process will create around 10-20 line items in the custom table so taking the highest number (20 line-item x3000 employee)= 60K records.

In addition, I need to take into consideration the below:

1. When the background process is triggered the button should be hidden on the command bar to avoid clicking the button again from the client-side.
2. Will it be possible to show like a progress bar that the calculation is in progress on the client-side in the model-driven app?

Could you suggest what can be the solution for the above requirements and especially the tool that should be used for the background process that will perform the creation of the records? Can you please provide some documentation?

The tool that should be used to develop the logic of the above should be accurate and efficient as this is a calculation of the employee salaries.

Any help is highly appreciated.

Best regards,
EBMRay

I have the same question (0)

All responses (6)

Answers (1)

EBMRay 905 on at

Like (0)

Report

Hello Bipin Kumar ,

I did some research and found that Azure Function can be an option. Also, what about a custom WPF Desktop App integrated with model-driven?

Please let me know your thoughts. I would highly appreciate your input.

Best regards,

EBMRay

Was this reply helpful? Yes No
Verified answer

mildseven 45 on at

Like (1)

Report

Use a custom Action. Implement it as a webhook to an Azure function (which doesn't have the 2-min constraint). Call the action from JavaScript, and you can use out of the box showProgressIndicator for the progress bar. On successful execution of the action's logic in Azure, you can set the outputParameter to whatever you like: Success(boolean). On the front end, you close the progress bar if the output parameter Success == true.

If you're running this on a view/subgrid, do you plan on selecting records? Or are you updating all records in the view? Depending on the route you take, you'll most likely need to incorporate additional logic to meet your business requirements.

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report

Hi mildseven ,

Thank you for your valuable response.

Exactly, the webhook will be used to call the Azure function when the button is clicked from the UI. Is there any example that shows how the showProgressIndicator will disappear whenever the Azure function succeeded?

The button will be clicked from a View that will trigger the function without selecting any record.

I found this useful post that might help anyone will come across this post:

www.blog.allandecastro.com/.../

Best regards,
EBMRay

Was this reply helpful? Yes No
mildseven 45 on at

Like (1)

Report

You could do something like this:

Xrm.Utility.showProgressIndicator("Processing...");

var result = await Xrm.WebApi.online.execute("your custom action logical name");
if (result && result.ok) {
var output = await result.json();
var success = output["Success"];

if(success){ Xrm.Utility.closeProgressIndicator(); }

else {

-error handling logic-

}

}

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report

Hi mildseven ,

Thank you for your reply and for providing an example.

I will start with the implementation and will let you know if I have any further questions.

Best regards,

EBMRay

Was this reply helpful? Yes No
mildseven 45 on at

Like (1)

Report

Please mark my answer as verified if it worked. Thanks!

Was this reply helpful? Yes No