Power Platform Community Forum Thread Details

Can anyone advice me how to extract string after a particular text which occurs multiple times and store the data to a Compose function so that I can use the compose function to store the date to an Excel sheet.

I have extracted the contents below from an email and converted to text via MS Flow.

What I need is the string of sentence after the word "Reason", which you can see here occurs multiple times and each string contains different values:

In short, I want the values as follows:

Primary : UPG6_Coupler Insertion on 001 Omnibus.

Backup : UPG6_Coupler Insertion on 002 Omnibus.

Backup : UPG6_Coupler Insertion on 003 Omnibus.

=====================================

Contents

=======

1. Circuit: BKK/MAL/TOK 1445

Date/ Time 1 (SGT): 20-Jun-2023 04:00 - 20-Jun-2023 14:00

Date/ Time 1 (UTC): 19-Jun-2023 20:00 - 20-Jun-2023 06:00

Impact : Primary : The circuit will be down within the entire maintenance window period.

Reason : Primary : UPG6_Coupler Insertion on 001 Omnibus.