
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
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?
It's an interesting question and I haven't tried it before but, instead of "<br>" have you tried with "\n" or "\\n"?
Just to be sure, if possible, try to configure your Excel as follows:
https://www.extendoffice.com/documents/excel/3614-excel-text-on-multiple-lines-in-one-cell.html
Can you please check if and let me know if you have any questions?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel