The flow is triggered by a new email with a specific subject line entering my inbox
Body of email and received time are turned from HTML to text
To find specific number I'm looking for in the body of the email to update my sharepoint excel file with I used compose:
trim(replace(first(split(last(split(outputs(‘Html_to_text’)?[‘body’], ‘Quantity: ’)), ‘ records’)), ‘#’, “)).
I used compose to format the date to match what I have in excel which is, for example 4/17/2026
formatDateTime(triggerOutputs((‘Html_to_text’)?[‘received time’], 'm/d/yyyy'))
I then chose the Update a row function choosing the specific table within the excel file
Key Column: Date
Key Value: Compose Formatted Date Output
Column to Update: Initial Compose Split Output
Appreciate any help
