Power Platform Community Forum Thread Details

Need help extracting the highlighted contents in the email below into an Excel spreadsheet connected via MS 365 OneDrive.

Below are the different expressions I'm using in Power Automate but I keep running into errors when testing the flow.

first(skip(split(triggerOutputs()?['body'],'Code '), 1))
first(skip(split(skip(split(triggerOutputs()?['body'], 'Reason for Job Requisition'), 1), '\n'), 1))
first(skip(split(skip(split(triggerOutputs()?['body'], 'Replacement Name (If applicable)'), 1), '\n'), 1))
first(skip(split(skip(split(triggerOutputs()?['body'], 'Department'), 1), '\n'), 1))
first(skip(split(skip(split(triggerOutputs()?['body'], 'Job'), 1), '\n'), 1))
first(skip(split(skip(split(triggerOutputs()?['body'], 'FTE'), 1), '\n'), 1))
first(skip(split(skip(split(triggerOutputs()?['body'], 'Approved by'), 1), '\n'), 1))

The error details say: "Unable to process template language expressions in action 'Add_a_row_into_a_table' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#split for usage details."

Please help!

Email Request.PNG