Issue with SharePoint JSON Button: Green Button Not Triggering Action Despite Valid Conditions

Question

Issue with SharePoint JSON Button: Green Button Not Triggering Action Despite Valid Conditions

Yakout RAMZI 40

I'm working with SharePoint JSON column formatting to create a custom button labeled "Envoyer Validation". The button is designed to have three color states: green (valid and complete data), yellow (incomplete data), and grey (already validated). However ,the issue with this JSON formatting is that while the yellow and grey buttons are correctly non-clickable, the green button is also unresponsive. My objective is to ensure that only the green button is clickable when all required conditions are met, and the other buttons remain inactive as expected .

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "div",

"attributes": {

"role": "button" 
  }, 

  "style": { 

powershell
"background-color": "=if([$Statut] == 'Validé', '#d6d6d6', if([$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), '#28a745', '#ffc107'))", 

"color": "white", 

"font-weight": "bold", 

"border-radius": "6px", 

"padding": "6px 12px", 

"cursor": "=if([$Statut] == 'Validé', 'not-allowed', if([$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'pointer', 'not-allowed'))", 

"pointer-events": "=if([$Statut] == 'Validé', 'none', if([$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'auto', 'none'))" 
  }, 

  "txtContent": "Envoyer Validation", 

  "customRowAction": { 

powershell
"action": "=if([$Statut] != 'Validé' && [$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'setValue', 'none')", 

"actionInput": { 

  "Statut": "=if([$Statut] != 'Validé' && [$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'En Cours', [$Statut])" 

} 
  }

Accepted answer

0 additional answers

Your answer

Answer 1

Teddie-D 1,030 Microsoft External Staff Moderator

Hi @Yakout RAMZI,
Thank you for reaching out to the Microsoft Q&A Forum.

Based on my testing environment, your JSON code is correct, and functions as expected. The green button becomes active only when all required fields are populated, and the other states behave as intended.

Additionally, I noticed you mentioned that the green button is also unresponsive. Could you please clarify this issue further? Understanding this will help us troubleshoot more effectively.
User's image

However, to better understand why the green button might not be triggering the action in your environment, could you please confirm the default column types for the following fields?

MotifPrescription
TypeTraitement
NomMedicament
DateExpiration
CodeProduit
Fournisseur
MedecinResponsable
Posologie
RemiseTotale
Statut

In my setup, I configured these column as below types:

MotifPrescription: Choice
TypeTraitement: Choice
NomMedicament: Text
DateExpiration: Date and time
CodeProduit: Text
Fournisseur: Text
MedecinResponsable: Text
Posologie: Multiple lines of text
RemiseTotale: Currency
Statut: Text

Looking forward to your update so we can help you troubleshoot further.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Yakout RAMZI 40 Reputation points

2025-06-16T07:41:40.06+00:00

Hello,

Thank you Teddie-D for your response and for testing the JSON code in your environment.

I'd like to clarify a few key points regarding the configuration of my SharePoint list, which may explain why the expected behavior is not fully achieved on my side:

Current column configuration in my SharePoint list:

Field Current column type

NomMedicament Single line of text

DateExpiration Date and time

CodeProduit Single line of text

Fournisseur Single line of text

MedecinResponsable Single line of text

Posologie Multiple lines of text

RemiseTotale Text (not Currency)

MotifPrescription Single line of text

TypeTraitement Text (not Choice)

Statut Choice (Non Traité / En Cours / Validé)

Expected business behavior:

I would like the "Envoyer Validation" button to:

Be clickable only when all required fields are filled (green),

Automatically update the Statut column from "Non Traité" to "En Cours" up on click,

Remain inactive and unclickable if the data is incomplete (yellow),

Be fully disabled when the status is already "Validé" (grey).

Issue encountered:

Even when the button appears green (with all required conditions visually met), clicking it does not update the Statut field.

Teddie-D 1,030 Microsoft External Staff Moderator

Hi @Yakout RAMZI,

Thank you for your quick response.
After configuring these columns as specified, here is the updated script that should meet your requirements.

{ 
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", 
  "elmType": "div", 
  "attributes": { 
    "role": "button" 
  }, 
  "style": { 
    "background-color": "=if([$Statut] == 'Validé', '#d6d6d6', if([$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), '#28a745', '#ffc107'))", 
    "color": "white", 
    "font-weight": "bold", 
    "border-radius": "6px", 
    "padding": "6px 12px", 
    "cursor": "=if([$Statut] == 'Validé', 'not-allowed', if([$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'pointer', 'not-allowed'))", 
    "pointer-events": "=if([$Statut] == 'Validé', 'none', if([$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'auto', 'none'))" 
  }, 
  "txtContent": "Envoyer Validation", 
  "customRowAction": { 
    "action": "setValue", 
    "actionInput": { 
      "Statut": "=if([$Statut] != 'Validé' && [$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'En Cours', [$Statut])" 
    } 
  } 
}

However, the "Envoyer Validation" button cannot be fully disabled when the status is already "Validé" (grey). This is because, in SharePoint, the double-click behavior on a list row is intentionally designed to automatically open the item's edit form.

I hope this helps. If you have any further updates on this issue, please feel free to post back.

If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.

Yakout RAMZI 40 Reputation points

2025-06-17T07:34:27.46+00:00

Hi Teddie-D ,

Thank you for your response ,but the issue related to this code is that when the button is green, clicking on it does not update the status to "En Cours".
Teddie-D 1,030 Reputation points Microsoft External Staff Moderator

2025-06-17T08:52:31.8233333+00:00

Hi @Yakout RAMZI

In my testing environment, when I click on green button, the statut will automatically update to En Cours.

I set the statut of this picture to blank.

And the statut of this picture to "Non Traité."
Both of them updated when I clicked the green button.

Therefore, I am unsure why it does not work in your environment.
Could you please double check the script against your column configuration?
Warm thanks.
Yakout RAMZI 40 Reputation points

2025-06-17T09:29:16.9733333+00:00

Hi Teddie-D ,

Thank you for your quick response.

It works well, there's just one issue left: when I click on the yellow or grey button, it is clickable and displays an update message .

Warm thanks.
Teddie-D 1,030 Reputation points Microsoft External Staff Moderator

2025-06-18T07:22:14.4333333+00:00
Hi @Yakout RAMZI
This script meets your requirements. The yellow and grey buttons are disabled, and no update message is displayed.
Please replace the existing script in the old JSON with this updated version.

"customRowAction": {     "action": "setValue",     "actionInput": {       "Statut": "=if([$Statut] != 'Validé' && [$NomMedicament] && [$DateExpiration] && [$CodeProduit] && [$Fournisseur] && [$MedecinResponsable] && [$Posologie] && [$RemiseTotale] && ([$MotifPrescription] || [$TypeTraitement] == 'Traitement Prolongé' || [$TypeTraitement] == 'Traitement Ponctuel'), 'En Cours', false)"     } }

If the issue has been resolved, please mark the helpful replies as answers.

This helps others in the community facing similar problems.

Thanks for your understanding.
Yakout RAMZI 40 Reputation points

2025-06-18T08:39:38.8233333+00:00

Hi Teddie-D

Thank you very much for your quick response, it solved my problem.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Share via

Issue with SharePoint JSON Button: Green Button Not Triggering Action Despite Valid Conditions

0 additional answers

Your answer