Pulling in Date Columns into Outlook

Copper Contributor

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"
}
}
]
}
]
}

0 Replies