Power Platform Community Forum Thread Details

Hello all,

I have been on this project and found some useful info via youtube and the community here. But i am currently now stuck. So basically these are my details.

QU SYDFRSQ SINFMSQ SINCCSQ CBRKKSQ
.MUCKMSQ 080210
CPM
SQ288/08.9VSMH
-11P/PMC32962DS/SYD/1528/C.PLD/QL
-14L/AKE28028SQ/SYD/60/D/BNE/176/C.VAL.VAL.VAL.VAL-14R/
AKE87246SQ/SYD/689/BJ0
-15L/AKE25679SQ/SYD/208/C.VAL-15R/AKE11837SQ/SYD/627/BY1

-11P/PMC32962DS/SYD/1528/C.PLD/QL
-14L/AKE28028SQ/SYD/60/D/BNE/176/C.VAL.VAL.VAL.VAL-14R/
AKE87246SQ/SYD/689/BJ0
-15L/AKE25679SQ/SYD/208/C.VAL-15R/AKE11837SQ/SYD/627/BY1

-45L/AKE80154SQ/SYD/720/C-45R/AKE70025SQ/SYD/736/C
-51/SYD/63/BJ/91/BY/10/C/599/M/BNE/17/BY/31/C.PIL.PIL.VR234
SI AKE70235SQ RELOAD TO BUL
LDD IN BULK
DOCS
07 MIXED BGE
SYD:02 BY

B14L/D/3/60
B51/BT//0
END OF DOCUMENT

I manage to get data from the above details. For example putting the 9VSMH into A/C Reg Column in Excel below. So when the variable changes for the A/C Registration it will also change. But the problem are the other columns where i want to put the other data under information column. In this case:

I also will have an issue as the data: SQ288/08.9VSMH where 08. will change as this shows the date. How can i remove this and not show in my excel since i have already done a date formula in my power automate.

For the flight number column , i am trying to put the SQ288 into the flight number column. Below is my power automate flow.
Where:
Initialize Variable 2 codes under values are: last(split(variables('EmailBody'),'SQ288/08.'))

Initialize Variable 3 codes under values are: first(split(variables('EmailStep1'),'<br>-'))

The BR is showing in my excel where i cannot seem to remove. I am very new to this and would need your help please. Or would this be actually do-able?

Categories:

General topics