azure-logic-appstext-extractionemail-body
How to find particular text after convert HTML to text in azure logic app?
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta content="text/html; charset=utf-8"><meta name="Generator" content="Amazon WorkMail v3.1.358.0"></head><body><table class="Table" width="909" style="border-collapse:collapse; width:909px"><tbody><tr><td style="background-color:#d9e1f2; border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; height:19px; padding:0cm 7px 0cm 7px; width:315px"><p align="center" style="text-align:center"><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Type</span></span></span></p></td><td style="background-color:#d9e1f2; border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:1px solid black; height:19px; padding:0cm 7px 0cm 7px; width:215px"><p align="center" style="text-align:center"><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Detail</span></span></span></p></td><td style="height:19px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr><tr><td style="border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:315px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Bot ID</span></span></span></p></td><td style="border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:215px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">4122</span></span></span></p></td><td style="height:19px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr><tr><td style="border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:315px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Bot Name </span></span></span></p></td><td style="border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:215px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Route U2K2 -CR </span></span></span></p></td><td style="height:19px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr><tr><td style="border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; height:38px; padding:0cm 7px 0cm 7px; width:315px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Bot Overview </span></span></span></p></td><td style="border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; height:38px; padding:0cm 7px 0cm 7px; width:215px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">BOT to process all the SR's raised in remedy for Route U2K2. </span></span></span></p></td><td style="height:38px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr><tr><td style="border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:315px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Stakeholder/Business approver Name </span></span></span></p></td><td style="border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:215px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><u><span style="color:#0563c1"><a href="mailto:[email protected]" style="color:#0563c1; text-decoration:underline">someemail.com</a></span></u></span></span></p></td><td style="height:19px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr><tr><td style="border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:315px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Estimated Run Costs</span></span></span></p></td><td style="border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:215px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"> </span></span></p></td><td style="height:19px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr><tr><td style="border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:315px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"><span style="color:black">Margin (Euros) - Optional </span></span></span></p></td><td style="border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; height:19px; padding:0cm 7px 0cm 7px; width:215px"><p><span style="font-size:11pt"><span style="font-family:"Calibri",sans-serif"> </span></span></p></td><td style="height:19px; padding:0cm 7px 0cm 7px; width:64px"> </td></tr></tbody></table></body></html>email body is in html converted to text like below, I need to find the required data and place those data somewhere.
How to split and take particular required text.
The logic app design : https://i.sstatic.net/GB3AF.png
email body image : https://i.sstatic.net/6k89j.png
the data was not in key value pair
Detail
Bot ID
4122
Bot Name
Route U2K2 -CR
Bot Overview
BOT to process all the SR's raised in remedy for Route U2K2.
Stakeholder/Business approver Name
Solution
After converting html to text, you can use substring('<text>', <startIndex>, <length>) to get the value you want.
Before you use substring('<text>', <startIndex>, <length>), you need to get <startIndex>and <length> first.
To get startIndex
You can use indexOf(variables('var'),'Bot ID') to get the index of Bot ID, then use add(indexOf(variables('var'),'Bot ID'),6) to get the index behind Bot ID.
To get length
You can use indexOf(variables('var'),'Bot Name') to get the index of Bot Name, then use sub(indexOf(variables('var'),'Bot Name'),add(indexOf(variables('var'),'Bot ID'),6)) to get the length.
The expression like this:
substring(variables('var'),add(indexOf(variables('var'),'Bot ID'),6),sub(indexOf(variables('var'),'Bot Name'),add(indexOf(variables('var'),'Bot ID'),6)))
The design is like this:
I did a test:
Note
The text has \n to start a newline, so you need to adjust the value of the startIndex and length according to your own text.
- Power Automate. Delete from parent and child list using ID from parent list
- Logic App to Queue - SSL connection could not be established
- Error in Azure logic app workflow when using inline java script action
- Azure Logic App - Create CSV form JSON to send in Email
- Azure Key Vault Disabled public access, how to access it through the portal via internet
- trigger logic app from Azure Service bus in sequance
- Initiate Azure DevOps Release Pipeline from Logic App and Retrieve Environment Variable Output from the pipeline
- xpath expression not working in Logic Apps
- Blocker when adding a blob action in the logic app
- Workflow and API connection provisioning for Standard logic app via Bicep templates/scripts
- Logic App (standard) deployment via DevOps pipeline - kudu service unavailable 503
- Logic Apps copy action gives: The managed identity used with this operation no longer exists. To continue, set up an identity or change the connection
- Logic App PDF File from Sharepoint uploading to Azure Blob is Blank
- Delete files from destination if deleted from source using logic app
- Creating CSV table from Crowdstrike API output
- Convert report JobFailureCode name Succes with Green and Failed with Red
- Logic apps - how to read 2 rows through an index variable
- Logic App Workflow - Flat File Encode error - Invalid Schema
- Copy Folder along with files from Azure Blob to SharePoint
- In Azure Logic Apps, how do I take SQL query results that are JSON and populate an array so I can use the results is a conditional logic?
- Append result in Azure Logic Apps
- Create an API Connection to Azure KeyVault using Service Principal Authentication through ARM template
- How to trigger Azure Logic App when a file is not being uploaded in Blob Storage? When you have replacing previous file?
- How to iterate through a JSON array and read a specific value using Logic App?
- Generate workflow in current devops sprint through logic apps
- Trigger concurrency runtime configuration cannot be removed once specified
- The execution of template action 'Response' is skipped: the client application is not waiting for a response from service
- Using Terraform to deploy Standard Logic App with Liquid Template Maps
- VSCode Logic App func.exe Service Bus Transport Type
- How can I get the UPN of the person who is activating a EntraID Identity Governance Lifecycle Workflow?