"Body copy from email is not populating the SharePoint list columns instead the code is populating.
How can I correct this.
I created a SharePoint list with column names that are in the email message so that when I receive the email the body copy populates to the SharePoint list columns
Email Example body copy:
PICTURE
An Offboard request has been completed by HR
Details:
Requested by: manager name
Requested on: Day Month Day Hour:Minute:Second TimeZone Year
Power Automate Process
When a new email arrives in a shared mailbox (V2) option - Populated with email addresses, subject filter and folder
Html to text - Populated with dynamic option "Body"
Compose Input - expression data
trim(split(split(outputs('Html_to_text')?['body'], 'Requested by:')[1], 'decodeUriComponent('%0A')')[0])
Compose Input - expression data
trim(split(split(body('Html_to_text'), 'Requested on:')[1],
Create item - Selected SharePoint site address
Selected List name
Advanced parameters - selected from the list
Requested by column > dynamic option Compose - Requested By
Requested on column > dynamic option Compose - Requested on
When I test the flow the columns fill in with below data which is where I am stuck
Requested by column shows this data
trim(split(split(outputs('Html_to_text')?['body'], 'Requested by:')[1], 'decodeUriComponent('%0A')')[0])
Requested on column shows this data
trim(split(split(body('Html_to_text'), 'Requested on:')[1],
