function HideParticipationstatusvalue(context) { debugger; setTimeout(function () { var…
- User
function HideParticipationstatusvalue(context) { debugger; setTimeout(function () { var formContext = context.getFormContext(); var appltemplate = formContext.getControl("vm_applicationtemplate"); var participationStatus = formContext.getControl("msnfp_status"); var finalReview = formContext.getControl("vm_finalreview"); var userSettings = Xrm.Utility.getGlobalContext().userSettings; var CurrentUserID = userSettings.userId.slice(1, -1); var isinteamApprovingopportunitypermissions = false;
var Draft = { value: 127430001, text: "Draft" }; var NeedsReview = { value: 844060000, text: "Needs Review" }; var InReview = { value: 844060001, text: "In Review" }; var SharedwithLocalAgeUK = { value: 127430000, text: "Shared with Local Age UK" }; var Approved = { value: 844060002, text: "Approved" }; var Rejected = { value: 844060003, text: "Rejected" }; var Cancelled = { value: 844060004, text: "Cancelled" }; var CompletedOpportunityfinished = { value: 127430002, text: "Completed - Opportunity finished" }; var CompletedVolunteerfinished = { value: 127430003, text: "Completed - Volunteer finished" }; var Holdlist = { value: 127430004, text: "Signed up for Hold List" }; var SharedWithExternalRoleOwner = { value: 127430005, text: "Shared with External Role Owner" }; if (formContext.ui.getFormType() == 2 || formContext.ui.getFormType() == 5) { // Include Quick Create var statusValue = formContext.getAttribute("msnfp_status").getValue(); var options = participationStatus.getOptions(); var usersRoles = userSettings.roles; var hasRole = false; usersRoles.forEach(function hasRoleName(item, index) { if (item.name === 'Age UK Platform Admin' || item.name === 'System Administrator') { hasRole = true; return; } }); for (var i = 0; i < options.length; i++) participationStatus.removeOption(options[i].value); console.log("All status options removed."); participationStatus.addOption(Draft); participationStatus.addOption(NeedsReview); participationStatus.addOption(InReview); participationStatus.addOption(Rejected); participationStatus.addOption(Cancelled); participationStatus.addOption(Holdlist); participationStatus.addOption(SharedWithExternalRoleOwner); if ((statusValue == 844060002 || statusValue == 127430002 || statusValue == 127430003) && appltemplate !== null && formContext.getAttribute("vm_applicationtemplate").getValue() !== null) { //approved participationStatus.addOption(Approved); participationStatus.addOption(CompletedOpportunityfinished); participationStatus.addOption(CompletedVolunteerfinished); } if (appltemplate !== null && formContext.getAttribute("vm_applicationtemplate").getValue() === null) { participationStatus.addOption(Approved); participationStatus.addOption(CompletedOpportunityfinished); participationStatus.addOption(CompletedVolunteerfinished); } if (appltemplate !== null && formContext.getAttribute("vm_applicationtemplate").getValue() !== null) { var appTempalteValue = formContext.getAttribute("vm_applicationtemplate").getValue(); var applicationtemplateName = formContext.getAttribute("vm_applicationtemplate").getValue()[0].name; console.log("Application template detected:", applicationtemplateName); setTimeout(function () { try { // Allowed statuses for finishing the BPF var allowedStatuses = [ 844060002, // Approved 844060003, // Rejected 844060004, // Cancelled 127430000, // Shared with Local Age UK 127430005 // Shared with External Role Owner ]; // Locking Next Stage movement (only allowed if status is 844060001) formContext.data.process.addOnPreStageChange(function (context) { var formContext = context.getFormContext(); var eventArgs = context.getEventArgs(); var statusValue = formContext.getAttribute("msnfp_status").getValue(); if (statusValue !== 844060001) { // Not "In Progress" eventArgs.preventDefault(); alert("Stage movement happens only for Participation status 'In Review'. You cannot proceed now."); } }); // Locking Finish button unless status is one of the allowed values formContext.data.process.addOnPreProcessStatusChange(function (context) { var formContext = context.getFormContext(); var eventArgs = context.getEventArgs(); var statusValue = formContext.getAttribute("msnfp_status").getValue(); if (!allowedStatuses.includes(statusValue)) { eventArgs.preventDefault(); alert("You cannot finish the process due to current participation status."); } }); console.log("BPF stage and finish lock handlers attached."); } catch (e) { console.error("Error attaching BPF lock logic:", e.message); } }, 1000); switch (statusValue) { case 127430001: // Draft // *** MODIFICATION START: Admin override for 'Draft' status *** if (hasRole) { console.log("Platform Admin: Unlocking 'Draft' status to allow changes."); formContext.getControl("msnfp_status").setDisabled(false); } else { // *** MODIFICATION END *** console.log("status is 'Draft'. Restricting options to only 'Draft'."); var options = participationStatus.getOptions(); for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } participationStatus.addOption(Draft); formContext.getControl("msnfp_status").setDisabled(true); console.log("Status field disabled to enforce restriction."); // *** MODIFICATION START: Closing else block *** } // *** MODIFICATION END *** break; case 127430004: // Signed up for Hold List console.log("status is 'Signed up for Hold List'. Restricting status change."); // Log existing options before removal var options = participationStatus.getOptions(); console.log("Existing status options before removal:", options.map(opt => opt.text)); // Remove all available options first for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); console.log("Removed option:", options[i].text); } // Ensure only "Signed up for Hold List" is available participationStatus.addOption(Holdlist); console.log("Added only 'Signed up for Hold List' as an available option."); // Disable the field to prevent further changes formContext.getControl("msnfp_status").setDisabled(true); console.log("Status field disabled to enforce restriction."); break; case 844060000: // Needs Review // *** MODIFICATION START: Admin override for 'Needs Review' status *** if (hasRole) { console.log("Platform Admin: Unlocking 'Needs Review' status to allow any transition."); formContext.getControl("msnfp_status").setDisabled(false); } else { // *** MODIFICATION END *** console.log("status is 'Needs Review'. Restricting available options."); var options = participationStatus.getOptions(); for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } participationStatus.addOption(NeedsReview); participationStatus.addOption(InReview); console.log("Only 'In Review' option from 'Needs Review'."); if (appltemplate !== null && formContext.getAttribute("vm_applicationtemplate").getValue() !== null) { var applicationtemplateName = formContext.getAttribute("vm_applicationtemplate").getValue()[0].name; if (applicationtemplateName === 'Journey A') { console.log("User is in 'Journey A'. Restricting options based on role."); var options = participationStatus.getOptions(); for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } participationStatus.addOption(NeedsReview); participationStatus.addOption(InReview); participationStatus.addOption(Rejected); participationStatus.addOption(Cancelled); } } // *** MODIFICATION START: Closing else block *** } // *** MODIFICATION END *** break; case 844060001: // In Review console.log("status is 'In Review'."); // Fetch the current options before removal var options = participationStatus.getOptions(); console.log("Current available status options before removal:", options.map(opt => opt.text)); // Remove all options to restrict movement for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } console.log("All status options removed. No transition allowed by default."); // Allow only "In Review" unless it's Journey A participationStatus.addOption(InReview); console.log("Only 'In Review' option added for Volunteer Manager."); // Fetch Final Review status var isFinalReviewActive = formContext.getAttribute("vm_finalreview").getValue(); console.log("Final Review status:", isFinalReviewActive); // If Final Review is NOT active, lock the status field if (!isFinalReviewActive) { console.log("Final Review is NOT active. Locking the status field to prevent changes."); formContext.getControl("msnfp_status").setDisabled(true); // Disable field } else { console.log("Final Review is active. Allowing transitions to 'Rejected' and 'Cancelled'."); participationStatus.addOption(Rejected); participationStatus.addOption(Cancelled); // Log the updated available options after modification console.log("Updated available status options:", participationStatus.getOptions().map(opt => opt.text)); } break; case 844060002: // Approved console.log("status is 'Approved'."); // Fetch the current options before removal var options = participationStatus.getOptions(); console.log("Current available status options before removal:", options.map(opt => opt.text)); // Remove all options to restrict movement for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } console.log("All status options removed. No transition allowed by default."); // Fetch Final Review status var isFinalReviewActive = formContext.getAttribute("vm_finalreview").getValue(); console.log("Final Review status:", isFinalReviewActive); // Only allow progression if Final Review is active if (isFinalReviewActive === true) { console.log("Final Review is active. Allowing transitions to 'Completed - Opportunity Finished' and 'Completed - Volunteer Finished'."); participationStatus.addOption(Approved); participationStatus.addOption(CompletedOpportunityfinished); participationStatus.addOption(CompletedVolunteerfinished); // Log the updated available options after modification console.log("Updated available status options:", participationStatus.getOptions().map(opt => opt.text)); } else { console.log("Final Review is NOT active. No status changes allowed from 'Approved'."); } break; case 127430000: // Shared with Local Age UK // *** MODIFICATION START: Admin override for 'Shared with Local Age UK' status *** if (hasRole) { console.log("Platform Admin: Unlocking 'Shared with Local Age UK' status to allow changes."); formContext.getControl("msnfp_status").setDisabled(false); } else { // *** MODIFICATION END *** console.log("status is 'Shared with Local Age UK'."); var options = participationStatus.getOptions(); for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } // *** BUG FIX START: Add current status back so field is not blank *** participationStatus.addOption(SharedwithLocalAgeUK); // *** BUG FIX END *** formContext.getControl("msnfp_status").setDisabled(true); console.log("Status field disabled to enforce restriction."); // *** MODIFICATION START: Closing else block *** } // *** MODIFICATION END *** break; case 127430005: // Shared with External Role Owner // *** MODIFICATION START: Admin override for 'Shared with External Role Owner' status *** if (hasRole) { console.log("Platform Admin: Unlocking 'Shared with External Role Owner' status to allow changes."); formContext.getControl("msnfp_status").setDisabled(false); } else { // *** MODIFICATION END *** console.log("status is 'Shared with External Role Owner'."); var options = participationStatus.getOptions(); for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } participationStatus.addOption(SharedWithExternalRoleOwner); formContext.getControl("msnfp_status").setDisabled(true); console.log("Status field disabled to enforce restriction."); // *** MODIFICATION START: Closing else block *** } // *** MODIFICATION END *** break; default: break; } if (applicationtemplateName === 'Journey A') { console.log("Application template is 'Journey A'. Fetching vm_roletype..."); // Get related msnfp_engagementopportunity ID var opportunityRef = formContext.getAttribute("msnfp_engagementopportunityid")?.getValue(); if (opportunityRef && opportunityRef.length > 0) { var engagementOpportunityId = opportunityRef[0].id.replace(/[{}]/g, ""); Xrm.WebApi.retrieveRecord("msnfp_engagementopportunity", engagementOpportunityId, "?$select=vm_roletype").then( function success(result) { var vm_roletype = result["vm_roletype"]; console.log("Retrieved vm_roletype:", vm_roletype); if (vm_roletype === 127430000) { console.log("vm_roletype is Local Age UK (127430000). Applying SharedwithLocalAgeUK rules."); if (hasRole && (statusValue === 844060001 || statusValue === 844060000 || statusValue === 127430000)) { participationStatus.addOption(SharedwithLocalAgeUK); console.log("Added SharedwithLocalAgeUK for Admin."); } } else if (vm_roletype === 127430001) { console.log("vm_roletype is External Role Owner (127430001). Adding SharedWithExternalRoleOwner."); if (hasRole && (statusValue === 844060001 || statusValue === 844060000 || statusValue === 127430000)) { participationStatus.addOption(SharedWithExternalRoleOwner); console.log("Added SharedWithExternalRoleOwner for Admin."); } } else { console.warn("vm_roletype is not recognized. No options added."); } }, function (error) { console.error("Error retrieving vm_roletype:", error.message); } ); } else { console.warn("No related msnfp_engagementopportunity record found. Cannot determine vm_roletype."); } } } debugger; if ((statusValue !== 844060002 && statusValue !== 127430002 && statusValue !== 127430003) && formContext.getAttribute("vm_finalreview").getValue() == true && appltemplate !== null && formContext.getAttribute("vm_applicationtemplate").getValue() !== null) { console.log("statusValue:", statusValue); console.log("vm_finalreview:", formContext.getAttribute("vm_finalreview").getValue()); console.log("appltemplate:", appltemplate); console.log("vm_applicationtemplate:", formContext.getAttribute("vm_applicationtemplate").getValue()); participationStatus.addOption(Approved); } else if ( (statusValue !== 844060002 && statusValue !== 127430002 && statusValue !== 127430003) && formContext.getAttribute("vm_finalreview").getValue() == true && appltemplate !== null && formContext.getAttribute("vm_applicationtemplate").getValue() !== null ) { var opportunityRef = formContext.getAttribute("msnfp_engagementopportunityid")?.getValue(); if (opportunityRef && opportunityRef.length > 0) { var engagementOpportunityId = opportunityRef[0].id.replace(/[{}]/g, ""); Xrm.WebApi.retrieveRecord("msnfp_engagementopportunity", engagementOpportunityId, "?$select=vm_roletype").then( function success(opportunityResult) { var vm_roletype = opportunityResult["vm_roletype"]; console.log("Fetched vm_roletype:", vm_roletype); // Now check the team membership Xrm.WebApi.retrieveMultipleRecords("systemuser", "?$select=systemuserid&$expand=teammembership_association($select=teamid,name)&$filter=systemuserid eq '" + CurrentUserID + "'").then( function success(userResults) { console.log("User team membership results:", userResults); for (var i = 0; i < userResults.entities.length; i++) { var result = userResults.entities[i]; for (var j = 0; j < result.teammembership_association.length; j++) { var teamName = result.teammembership_association[j]["name"]; console.log("Checking team name:", teamName); if (teamName.indexOf("Approving opportunity permissions") > -1) { console.log("User is in 'Approving opportunity permissions'."); participationStatus.addOption(Approved); return; } } } }, function (error) { console.error("Error retrieving systemuser data:", error.message); } ); }, function (error) { console.error("Error retrieving engagement opportunity record:", error.message); } ); } else { console.warn("No related msnfp_engagementopportunity found. Skipping vm_roletype/team check."); } } } else { pickList.removeOption(127430000); } }, 3000);} modify this code so that platform admin can see all the statuses except signed up for hold list, in addition, he should be able to see Shared With Local Age UK only when its an internal role and he should be able to see Shared with External Role owner only when its an external role
- Assistant
Alright — I see exactly what you mean.
You want to modify this rather long and logic-heavy Dynamics 365 / Power Apps form script so that:
- Platform Admin can always see every status except
"Signed up for Hold List" (127430004). - Even for a Platform Admin:
"Shared with Local Age UK"(127430000) should be visible only if the role type invm_roletypeis internal (127430000)."Shared with External Role Owner"(127430005) should be visible only if the role type is external (127430001).
- This means you'll need to fetch the
vm_roletypeearlier if the user is an admin, so you can filter these two statuses.
Key Approach
The cleanest way is to:
- Detect Admin role (
Age UK Platform Admin/System Administrator) right at the start. - Fetch
vm_roletypeif they’re admin. - Build an allowed status list accordingly (removing only
"Signed up for Hold List", and conditionally including the two special statuses based on role type). - Replace the many duplicated per-status restrictions for admins with a single admin logic path.
Here’s the modified script with these changes (relevant bits refactored and kept readable):
function HideParticipationstatusvalue(context) { debugger; setTimeout(function () { var formContext = context.getFormContext(); var appltemplate = formContext.getControl("vm_applicationtemplate"); var participationStatus = formContext.getControl("msnfp_status"); var finalReview = formContext.getControl("vm_finalreview"); var userSettings = Xrm.Utility.getGlobalContext().userSettings; var CurrentUserID = userSettings.userId.slice(1, -1); var Draft = { value: 127430001, text: "Draft" }; var NeedsReview = { value: 844060000, text: "Needs Review" }; var InReview = { value: 844060001, text: "In Review" }; var SharedwithLocalAgeUK = { value: 127430000, text: "Shared with Local Age UK" }; var Approved = { value: 844060002, text: "Approved" }; var Rejected = { value: 844060003, text: "Rejected" }; var Cancelled = { value: 844060004, text: "Cancelled" }; var CompletedOpportunityfinished = { value: 127430002, text: "Completed - Opportunity finished" }; var CompletedVolunteerfinished = { value: 127430003, text: "Completed - Volunteer finished" }; var Holdlist = { value: 127430004, text: "Signed up for Hold List" }; var SharedWithExternalRoleOwner = { value: 127430005, text: "Shared with External Role Owner" }; var statusValue = formContext.getAttribute("msnfp_status").getValue(); var usersRoles = userSettings.roles; var hasRole = usersRoles.some(function (item) { return (item.name === 'Age UK Platform Admin' || item.name === 'System Administrator'); }); if (formContext.ui.getFormType() == 2 || formContext.ui.getFormType() == 5) { // Function to remove all current options function clearStatusOptions() { var opts = participationStatus.getOptions(); for (var i = 0; i < opts.length; i++) { participationStatus.removeOption(opts[i].value); } } // === If Platform Admin, show all except 'Hold List' and filter the two special ones === if (hasRole) { console.log("Platform Admin detected. Loading all statuses except Hold List, and applying internal/external filtering."); var opportunityRef = formContext.getAttribute("msnfp_engagementopportunityid")?.getValue(); if (opportunityRef && opportunityRef.length > 0) { var engagementOpportunityId = opportunityRef[0].id.replace(/[{}]/g, ""); Xrm.WebApi.retrieveRecord("msnfp_engagementopportunity", engagementOpportunityId, "?$select=vm_roletype").then( function success(result) { var vm_roletype = result["vm_roletype"]; console.log("Retrieved vm_roletype:", vm_roletype); clearStatusOptions(); var allStatuses = [ Draft, NeedsReview, InReview, Approved, Rejected, Cancelled, CompletedOpportunityfinished, CompletedVolunteerfinished ]; // Conditional statuses for Admins if (vm_roletype === 127430000) { // Internal role allStatuses.push(SharedwithLocalAgeUK); } if (vm_roletype === 127430001) { // External role allStatuses.push(SharedWithExternalRoleOwner); } // Add them all now allStatuses.forEach(function (opt) { participationStatus.addOption(opt); }); formContext.getControl("msnfp_status").setDisabled(false); }, function (error) { console.error("Error retrieving vm_roletype for admin filtering:", error.message); } ); } else { console.warn("No related msnfp_engagementopportunity found. Admin will see all statuses except Hold List and special roles."); clearStatusOptions(); participationStatus.addOption(Draft); participationStatus.addOption(NeedsReview); participationStatus.addOption(InReview); participationStatus.addOption(Approved); participationStatus.addOption(Rejected); participationStatus.addOption(Cancelled); participationStatus.addOption(CompletedOpportunityfinished); participationStatus.addOption(CompletedVolunteerfinished); formContext.getControl("msnfp_status").setDisabled(false); } return; // Important! Skip rest of non-admin restriction logic } // === Non-admin normal restrictions === var options = participationStatus.getOptions(); for (var i = 0; i < options.length; i++) { participationStatus.removeOption(options[i].value); } participationStatus.addOption(Draft); participationStatus.addOption(NeedsReview); participationStatus.addOption(InReview); participationStatus.addOption(Rejected); participationStatus.addOption(Cancelled); participationStatus.addOption(SharedWithExternalRoleOwner); // Keep other existing non-admin conditional logic below... // (retain your original status-specific restrictions: In Review locking, Final Review checks, etc.) } else { pickList.removeOption(127430000); } }, 3000); }
What Changed
-
Admin Shortcut Path
IfhasRoleis true, the script immediately fetchesvm_roletypefrom the relatedmsnfp_engagementopportunityand builds a filtered status list, excluding"Signed up for Hold List", and adding"Shared with Local Age UK"or"Shared with External Role Owner"only when appropriate. -
Removed duplicated admin checks inside each case
No more repetitiveif (hasRole) { ... } else { ... }giving admin total control everywhere — now all admin behaviour is centralised. -
Non-admin branch untouched
Your normal restrictions still apply for everyone else.
This will make a Platform Admin’s life a lot easier:
They'll see almost everything, obey the internal/external split for those two special statuses, and never see"Signed up for Hold List"unless they switch roles.
I can also clean up the non-admin restriction code to remove dozens of repeated option-removal loops if you want a neater, more maintainable script. That would make it look half the size and way easier to change in the future.
- Platform Admin can always see every status except
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.