Which formula to use in Power Automate to find a number from a txt file?
Good afternoon.
I am working on Power Automate and I would like to create a compose action that extract a specific data from a .txt file (Mail1.txt). I would like to extract the number which is located after Service and before the currency. In the example, this is 96 140. But for other example, the number will change.
color:black">The third PR 10303445 contains now only GBP. and is validated on SAP.</span></p><p style="direction:ltr; margin:0cm; font-family:Calibri,sans-serif; font-size:11pt"><span style="font-family:Aptos,sans-serif; color:black"> </span></p><ul style="direction:ltr; margin-top:0cm; margin-bottom:0cm"><li style="font-family:Calibri,sans-serif; font-size:11pt; color:black; direction:ltr; margin:0cm"><u>2023 TAS 167 Static Equipment & Package Engineer, PR </u><b><u>10303445</u></b><u>, PO 4100004319, (Consultant ).</u></li></ul><p style="direction:ltr; margin-top:0px; margin-bottom:0px; margin-left:36pt"><span style="font-family:"Segoe UI",sans-serif; font-size:12pt; color:black"> </span></p><p style="direction:ltr; margin-top:0px; margin-bottom:0px; margin-left:36pt"><span style="font-family:"Segoe UI",sans-serif; font-size:12pt; color:black">Line 3, 4000657 Service : <b>96 140</b> <b>GBP</b></span></p><p style="direction:ltr; margin-top:0px; margin-v></body></html>
Thank you for your help.
I tried this in the input from PowerAutomate.
substring( string(outputs('Compose_1_extraire_contenu_du_fichier')), add(indexOf(string(outputs('Compose_1_extraire_contenu_du_fichier')), 'Service: '), 9), sub( indexOf( string(outputs('Compose_1_extraire_contenu_du_fichier')), ' ', add(indexOf(string(outputs('Compose_1_extraire_contenu_du_fichier')), 'Service: '), 9) ), add(indexOf(string(outputs('Compose_1_extraire_contenu_du_fichier')), 'Service: '), 9) ) )
I get the following error:
Solution
There'll be better ways to do this with regex but I've managed to get by using a standard expression based on the text you provided.
This is the expression I used ...
last(split(first(split(last(split(outputs('Compose_Email'), 'Service :')), '</b>')), '<b>'))
- Which formula to use in Power Automate to find a number from a txt file?
- Removing input background colour for Chrome autocomplete?
- Set the default value of an input field
- How to remove arrows in input type "number" inside the input?
- change color / transpanency of spinor of <input type="number">
- 3d person controller in unity with rigidbody doesnt work
- Explain taking multiple lines of input in python - example from hackerrank
- How to select from index[3] to the index[8] on a list on python?
- When having String and int as an output - how do I print string first?
- How do i change the color of my password input when browser completes the password automatically?
- DatePicker: Dynamic Border Color Based on Validation
- PyAutoGui - Press key for X seconds
- Change default size of text input in Simple Form
- shadcn Input + Form + Zod "A component is changing an uncontrolled input to be controlled"
- Color of outline on input field
- Angular input signal with function type
- HTML5 restricting input characters
- Javascript manually firing .onchange() event
- Get number of non-empty input elements
- Remove new Firefox autofill color
- How to customize <input type="file">?
- Proper Memory Handling for User Input in C
- Is there any way to prevent input type="number" getting negative values?
- PHP: Best way to check if input is a valid number?
- HTML Form text input suggestions box
- How can I set max-length in an HTML5 "input type=number" element?
- How to prevent non-numeric characters being put inside an input box
- What is sharding in machine learning and how to do sharding in Tensorflow?
- Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
- I'm trying to place the placeholder in the border of the input field