Pulling in Date Columns into Outlook
Appreciate all following help on the issue I am dealing with in trying to rewrite JSON: I have a SharePoint form in which employee upload PTO...once they fill out the subject field on the SharePoint form, a link populates within the footer of my SharePoint form that opens up this link: https://outlook.office.com/calendar/deeplink/compose This link allows them to add their time off to their own personal outlook calendar. (it copies the title field over from the SharePoint form). In the SharePoint form, I have a StartDate field and an EndDate field (they are both date and time columns, with the date only). I want to take those field's in SharePoint and copy its' value to their respective fields in the outlook deep url interface (just like I am with the title field). This is the current code I have right now in which I want to add the new functionality to: { "elmType": "div", "style": { "width": "100%", "display": "=if([$Title], 'block', 'none')", "padding-top": "10px", "border-top": "1px solid" }, "attributes": { "class": "ms-fontColor-neutralSecondary" }, "children": [ { "elmType": "a", "attributes": { "target": "_blank", "href": { "operator": "+", "operands": [ "https://outlook.office.com/calendar/deeplink/compose", "?subject=", "[$Title]" ] }, "class": "ms-fontColor-themePrimary" }, "children": [ { "elmType": "span", "txtContent": "Post PTO on Individual Outlook Calendar" }, { "elmType": "span", "style": { "margin-left": "8px", "vertical-align": "middle" }, "attributes": { "iconName": "OutlookLogo", "class": "ms-fontColor-themePrimary ms-fontSize-xl" } } ] } ] }
