You’re offline. This is a read only version of the page.
Announcements
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?
Hi @kennethkonglars ,
With regard to the <br> issue, please try to use uriComponent() function to encode the string, where '<br>-' is encoded to '%0A-', then string can be splitted by "%0A-".
Hope this helps.
Sik
Share
Report
All responses (
Answers (
796
