Power Platform Community Forum Thread Details

Hello' I have a model driven app and there is a subgrid that shows related records. In the record there is allocation column that should total 100. If child rows don't equal 100 I need to give an error to the user. It has to be instant to the user to calculated columns are not an option any ideaa

Categories:

Building Power Apps

Connector development

Hi,

The best way to do it is using a JavaScript handler in the OnLoad property of the form

Just create a JS function that will retrieve all related records and show a notification if the le total of allocation column is not 100

Here is a sample function for you to start :

async function myFunction(executionContext){
	const formContext = executionContext.getFormContext();
	 if(formContext.ui.getFormType() === 1) return;
	 formContext.ui.clearFormNotification("ID");
	 const id = formContext.data.entity.getId().replace(/[{}]/g, '')
	 let retrieve = await Xrm.WebApi.retrieveMultipleRecords('related_table_name', `?$select=[allocation_column]&$filter=_[main_table_lookup]_value eq ${id}`);
	 if(retrieve.entities.length > 0 ) {
			const allocation_sum = retrieve.entities.reduce((acc, val) => acc.allocation_column + val , 0);
			if(allocation_sum === 100) return;
	 }
	 formContext.ui.setFormNotification("text", "ERROR", "ID");
}

And some doc : https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/client-scripting

Regards,