Blog about anything related to my learnings
  • About
  • posts
bluesky
Blog about anything related to my learnings
POSTS

Compose action TeamsMeetingLinkValue

trim(
  first(
    split(
      substring(
        body('Html_to_text'),
        indexOf(body('Html_to_text'), 'https://teams.microsoft.com/meet/')
      ),
      '\n'
    )
  )
)

TeamsMeetingLinkmd

concat('[Join the meeting now](', outputs('TeamsMeetingLinkValue'), ')')

BodyDescription

substring( body('Html_to_text'), 0, indexOf(body('Html_to_text'), '--------------------------------------------------------------------------------') )

ListItemId

decodeUriComponent(split(split(variables('linktodownloadics'), 'ID=')[1], '&')[0])

EventMessagefromoutlook body

concat(
  coalesce(triggerBody()?['subject'], '(No subject)'),
  ' đź“… ',
  formatDateTime(triggerBody()?['startWithTimeZone'], 'dd/MM/yyyy HH:mm'),
  ' - ',
  formatDateTime(triggerBody()?['endWithTimeZone'], 'dd/MM/yyyy HH:mm'),
  ' | ',
  coalesce(triggerBody()?['location'],'Location TBC'),
  decodeUriComponent('%0A%0A'),
  coalesce(
    triggerBody()?['body'],
    ''
  ),
  decodeUriComponent('%0A'),
  'đź”— ',
  if(
    not(empty(triggerBody()?['webLink'])),
    concat('[Open](', triggerBody()?['webLink'], ')'),
    concat(
      '[Open in Outlook](',
      'https://outlook.office.com/calendar/item/',
      uriComponent(triggerBody()?['id']),
      ')'
    )
  ),
  decodeUriComponent('%0A')
)

compose from SP list

concat(
  coalesce(triggerBody()?['subject'], '(No subject)'),
  ' đź“… ',
  formatDateTime(triggerBody()?['startWithTimeZone'], 'dd/MM/yyyy HH:mm'),
  ' - ',
  formatDateTime(triggerBody()?['endWithTimeZone'], 'dd/MM/yyyy HH:mm'),
  ' | ',
  coalesce(triggerBody()?['location'],'Location TBC'),
  decodeUriComponent('%0A%0A'),
  coalesce(
    outputs('BodyDescription'),
    ''
  ),
  decodeUriComponent('%0A'),
  'đź”— ',
  concat('[Download ics]','(https://avanade.sharepoint.com/sites/ukslearninglounge/_layouts/15/Event.aspx?ListGuid=',outputs('listId'),'&ItemId=',outputs('ListItemId'),')'),
  decodeUriComponent('%0A')
)
    © Blog about anything related to my learnings 2026
    bluesky