EventMessage Compose Action 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( trim( replace( replace( body('Html_to_text'), ' ', ' ' ), decodeUriComponent('%0A%0A%0A'), decodeUriComponent('%0A%0A') ) ), '' ), 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 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.

Refer to the post for detailed overview of the context where the replace is being used. Bulk Import CSV to SharePoint with Power Automate Options to Import Large tab delimited Data to SharePoint with Power Automate Replace New lines split(trim(body(‘Get_file_content’)), decodeUriComponent(’%0A’)) /r/n Replace tab characters split(item(), decodeURIComponent(’%09’)) /r Replace carriage return split(item(), decodeURIComponent(’%09’)) /t