Power Platform Community Forum Thread Details

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

Categories:

Building flows