Power Platform Community Forum Thread Details

Hello Everyone,

I have a use case where I want to extract information from subject line of a meeting invite and update it to a SharePoint List. The format of the invite subject line will be as

QAR Call - MLT123456987 - ABC. Inc OR QAR Call - MLT987654123 - Consultant - DEF. Inc

I've followed the below process

Added a trigger - When an event is added, updated or deleted (V3)
Added compose action and given parameter - match(triggerOutputs()?['body/subject'], 'MLT([0-9]+)')
Added second compose action and given parameter - match(triggerOutputs()?['body/subject'], '(?<= - )[A-Za-z\s]+(?= - MLT)')
Added third compose action and given parameter - match(triggerOutputs()?['body/subject'], '(?<= - )[A-Za-z\s.]+$')
Added a create item action for SharePoint where the extracted values will be updated.
- Under the advanced parameter I selected the name of columns in which I need the values to be updated and selected the dynamic content for all the three columns which is
  - outputs('Compose_for_MLT_ID')
  - outputs('Service')
  - outputs('Compose_for_Name')

When I run the flow it is giving me the output in SharePoint list as:

MLT ID	Service	Name
match(triggerOutputs()?['body/subject'], 'MLT([0-9]+)')	match(triggerOutputs()?['body/subject'], '(?<= - )[A-Za-z\s]+(?= - MLT)')	match(triggerOutputs()?['body/subject'], '(?<= - )[A-Za-z\s.]+$')