Hi Team
I need help, have this json now trick part on my sharepoint when i submit data from power apps and on email when approval type is submitted, its not showing who did and pending status should the document is on hold to someone needs to approve or reject a document on word. Who can assist to achieve this?
{ "$schema": "//developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "nowrap" }, "children": [ { "elmType": "div", "style": { "display": "=if([$ItemStatus] == 'Pending' || [$ItemStatus] == '', 'inherit','none')", "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "wrap" }, "children": [ { "elmType": "button", "customRowAction": { "action": "setValue", "actionInput": { "ItemStatus": "Approved", "ApprovalActionBy": "@me" } }, "attributes": { "class": "=if([$ItemStatus] == 'Approved', 'greenButton', 'ms-fontColor-themePrimary ms-fontColor-themeDarker--hover')" }, "style": { "border": "none", "background-color": "transparent", "cursor": "pointer", "display": "flex", "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "wrap" }, "children": [ { "elmType": "span", "attributes": { "iconName": "SkypeCircleCheck" }, "style": { "padding": "4px" } }, { "elmType": "span", "txtContent": "Approve", "style": { "word-break": "keep-all" } } ] }, { "elmType": "button", "customRowAction": { "action": "setValue", "actionInput": { "ItemStatus": "Rejected", "ApprovalActionBy": "@me" } }, "attributes": { "class": "=if([$ItemStatus] == 'Rejected', 'redButton', 'ms-fontColor-themePrimary ms-fontColor-themeDarker--hover')" }, "style": { "border": "none", "background-color": "transparent", "cursor": "pointer", "display": "flex", "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "wrap" }, "children": [ { "elmType": "span", "attributes": { "iconName": "Blocked" }, "style": { "padding": "4px" } }, { "elmType": "span", "txtContent": "Reject", "style": { "word-break": "keep-all" } } ] }, { "elmType": "button", "customRowAction": { "action": "setValue", "actionInput": { "ItemStatus": "Reassign", "ApprovalActionBy": "@me" } }, "attributes": { "class": "=if([$ItemStatus] == 'Reassign', 'orangeButton', 'ms-fontColor-themePrimary ms-fontColor-themeDarker--hover')" }, "style": { "border": "none", "background-color": "transparent", "cursor": "pointer", "display": "flex", "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "wrap" }, "children": [ { "elmType": "span", "attributes": { "iconName": "Rotate" }, "style": { "padding": "4px" } }, { "elmType": "span", "txtContent": "Reassign", "style": { "word-break": "keep-all" } } ] }, { "elmType": "button", "customRowAction": { "action": "setValue", "actionInput": { "ItemStatus": "Restart for Approval", "ApprovalActionBy": "@me" } }, "attributes": { "class": "=if([$ItemStatus] == 'Restart for Approval', 'blueButton', 'ms-fontColor-themePrimary ms-fontColor-themeDarker--hover')" }, "style": { "border": "none", "background-color": "transparent", "cursor": "pointer", "display": "flex", "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "wrap" }, "children": [ { "elmType": "span", "attributes": { "iconName": "Refresh" }, "style": { "padding": "4px" } }, { "elmType": "span", "txtContent": "Restart for Approval", "style": { "word-break": "keep-all" } } ] }, { "elmType": "button", "customRowAction": { "action": "setValue", "actionInput": { "ItemStatus": "Request Action", "ApprovalActionBy": "@me" } }, "attributes": { "class": "=if([$ItemStatus] == 'Request Action', 'yellowButton', 'ms-fontColor-themePrimary ms-fontColor-themeDarker--hover')" }, "style": { "border": "none", "background-color": "transparent", "cursor": "pointer", "display": "flex", "flex-directon": "row", "justify-content": "left", "align-items": "center", "flex-wrap": "wrap" }, "children": [ { "elmType": "span", "txtContent": "Request Action", "style": { "word-break": "keep-all" } } ] } ] }, { "elmType": "div", "children": [ { "elmType": "span", "txtContent": "='This item is ' + toLowerCase([$ItemStatus])", "style": { "display": "=if([$ItemStatus] == 'Pending' ||[$ItemStatus] == '' , 'none','inherit')", "padding-left": "5px", "word-break": "keep-all" } } ] } ] }