Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Splitting paragraphs i...
Power Automate - Building Flows
Unanswered

Splitting paragraphs in a document

(1) ShareShare
ReportReport
Posted on by SergeW 20

I'm attempting to split the below into individual reports to process. Thanks to this community I was able to get what I wanted from the reports, but I ran into this problem when I discovered that certain reports come in as multiple. So basically I want to separate the information into individual reporrts.

I've tried expression

trim(first(split(last(split(outputs('Get_Attachment_Body'),'SORTED')),'MULTI-WIRE')))
and that gives me what I want, but I only get the last one back. So basically I need that for however many
are in the report.

Hopefully I can give a clear example of what I want below. Red is where I want to start and end the separation.

Wed May 22 13:03:44 2024 Page 1 of 1 - Starting here
WC 281592
** FACS PENDING ORDER REPORT ** FULL REPORT - or maybe here
EMP UNKNOWN
SORTED BY DUE DATE, ORDER NUMBER
WC 281592 DLE INV Y
PASS ORDER LOOP COF COFUPD SOAC SOP RREQ

ORD NO DUE DATE RECEIVED MODE ORIG TYPE STATUS STATUS STATUS STATUS STATUS STATUS CLASS STAT

------ -------- -------- ---- ---- ---- ------ ------ ------ ------ ------ ------ ----- ----

C602063 04-29-24s 04-24/18:15 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608710 04-29-24s 04-26/18:44 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608712 04-29-24s 04-26/18:44 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608714 04-29-24s 04-26/18:45 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608716 04-29-24s 04-26/18:46 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608718 04-29-24s 04-26/18:47 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608720 04-29-24s 04-26/18:48 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C608722 04-29-24s 04-26/18:49 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
D258065 05-01-24 05-01/11:01 AUTO SOP PRE ASEC RTD ASGD ASGD NO RQD FANK FANK RES NRQ
C622990 05-02-24 05-02/11:55 AUTO SOP PRE ASEC RTD NO RQD NO RQD NO RQD FNAS FNAS RES NRQ
C619826 05-06-24s 05-01/14:16 AUTO SOACSW6 PRE RMA FMIS N/A BUS NRQ
C619838 05-06-24s 05-01/14:20 AUTO SOACSW6 PRE RMA FMIS N/A BUS NRQ
C619841 05-06-24s 05-01/14:28 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
C634889 05-10-24s 05-07/16:44 AUTO SOACSW6 PRE RMA MA NO RQD NO RQD FMIS N/A BUS RQD
N301225D SD05-14-24 05-14/14:38 AUTO SOP COR ASEC RTD ASGD ASGD NO RQD FANC FANC RES NRQ
C106469P3A 05-22-24 05-15/17:27 AUTO SOP PRE ASEC RTD ASGD ASGD NO RQD FANK FANK BUS NRQ
C109412P0A 05-22-24 05-18/11:54 AUTO SOP PRE ASEC RTD ASGD ASGD NO RQD FANK FANK RES NRQ
D264884 05-22-24 05-22/10:45 AUTO SOACSW6 PRE ASEC RTD ASGD ASGD NO RQD FANK N/A RES NRQ
D266105 05-22-24 05-20/18:07 AUTO SOP PRE ASEC RTD ASGD ASGD NO RQD FANK FANK BUS NRQ

 

 

 

 

 

 

 

 

 

 

 

 

* MULTI-WIRE CENTER ORDER & SPECIAL FOREIGN EXCHANGE ORDER c REUSE COMBINED ORDER
q QUEUED TRANSACTION s SPECIAL SERVICE ORDER i REUSE INDIVIDUAL ORDER - ending here


Wed May 22 13:03:44 2024 Page 1 of 1
WC 979245
** FACS PENDING ORDER REPORT ** FULL REPORT
EMP UNKNOWN
SORTED BY DUE DATE, ORDER NUMBER
WC 979245 DLE INV N
PASS ORDER LOOP COF COFUPD SOAC SOP RREQ

ORD NO DUE DATE RECEIVED MODE ORIG TYPE STATUS STATUS STATUS STATUS STATUS STATUS CLASS STAT

------ -------- -------- ---- ---- ---- ------ ------ ------ ------ ------ ------ ----- ----

C662137 05-22-24 05-22/08:28 AUTO SOP PRE ASEC RTD FNAS FNAS BUS NRQ

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

* MULTI-WIRE CENTER ORDER & SPECIAL FOREIGN EXCHANGE ORDER c REUSE COMBINED ORDER
q QUEUED TRANSACTION s SPECIAL SERVICE ORDER i REUSE INDIVIDUAL ORDER


Wed May 22 13:03:44 2024 Page 1 of 1
WC 979279
** FACS PENDING ORDER REPORT ** FULL REPORT
EMP UNKNOWN
SORTED BY DUE DATE, ORDER NUMBER
WC 979279 DLE INV N
PASS ORDER LOOP COF COFUPD SOAC SOP RREQ

ORD NO DUE DATE RECEIVED MODE ORIG TYPE STATUS STATUS STATUS STATUS STATUS STATUS CLASS STAT

------ -------- -------- ---- ---- ---- ------ ------ ------ ------ ------ ------ ----- ----

C619526 05-06-24s 05-01/12:12 AUTO SOACSW6 PRE RMA ASGD MA NO RQD FMIS N/A BUS NRQ
C619584 05-06-24s 05-01/12:41 AUTO SOACSW6 PRE RMA ASGD MA NO RQD FMIS N/A BUS NRQ
D261166 05-09-24 05-06/10:07 AUTO SOP PRE RMA MA RQD NO RQD FMIS FMIS BUS NRQ
D261167 05-09-24 05-06/10:08 AUTO SOP PRE RMA MA RQD NO RQD FMIS FMIS BUS NRQ
C662193 05-22-24 05-22/10:16 AUTO SOP PRE ASEC RTD NO RQD NO RQD NO RQD FNAS FNAS BUS NRQ

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

* MULTI-WIRE CENTER ORDER & SPECIAL FOREIGN EXCHANGE ORDER c REUSE COMBINED ORDER
q QUEUED TRANSACTION s SPECIAL SERVICE ORDER i REUSE INDIVIDUAL ORDER

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans