Power Platform Community Forum Thread Details

Hi All,

I'm looking for guidance relating to a previous post (https://powerusers.microsoft.com/t5/Building-Flows/How-do-I-remove-an-empty-row-in-HTML-text-HTML-file-to-JSON/m-p/2461391)

I'm in the process of creating a flow which takes a HTML email attachment and converts it to JSON. It captures the attachment via email > converts the contentBytes to a string > Replaces the column delimiter with '^' and row delimiter with '|' > Converts it to text > splits the text by each row > filters out rows containing 4 or less characters > splits and maps data to it's respect column.

On the last step, my output is in the below example code. I'm hoping to pull the 'Mobile Phone' number for each row and input each in its own SQL table row. I understand how add row in SQL however I'm stuck on splitting the below in order to have the variable to use.

For context: Ultimately, the goal is to receive a HTML file attachment via email (personal or shared mailbox), pull the mobile phone number in each row from this attachment and store this in a SQL database table.

[
 {
 "Order": "1000000000",
 "IsellNo": "200000000",
 "WorkOrderNo": "30000000",
 "Customer": "Super Man",
 "Mobile Phone": "+61111111111",
 "Address": "1 Street Road",
 "Zip": "1111",
 "City": "Cityer",
 "DelDate": "Nov 17, 2023 5:00:00 PM",
 "OrdStatus": "1",
 "PlannedOL": "1",
 "PickedOL": "1",
 "Trip Note": "PARCEL",
 "Routeno": "1111AA",
 "TripSeq": "1",
 "PlanDate": "Nov 17, 2023 4:02:00PM",
 "TripStatus": "1"
 },
 {
 "Order": "4000000000",
 "IsellNo": "500000000",
 "WorkOrderNo": "60000000",
 "Customer": "Bat Man",
 "Mobile Phone": "+61422222222",
 "Address": "1 Avenue Court",
 "Zip": "2222",
 "City": "Cityson",
 "DelDate": "Nov 17, 2023 5:00:00 PM",
 "OrdStatus": "1",
 "PlannedOL": "1",
 "PickedOL": "1",
 "Trip Note": "PARCEL",
 "Routeno": "1111AA",
 "TripSeq": "1",
 "PlanDate": "Nov 17, 2023 4:02:00PM",
 "TripStatus": "1"
 },
 {
 "Order": "70000000000",
 "IsellNo": "8000000000",
 "WorkOrderNo": "90000000",
 "Customer": "Robin Hood",
 "Mobile Phone": "+614333333332",
 "Address": "1 Close Circuit",
 "Zip": "3333",
 "City": "Cityville",
 "DelDate": "Nov 17, 2023 5:00:00 PM",
 "OrdStatus": "1",
 "PlannedOL": "1",
 "PickedOL": "1",
 "Trip Note": "PARCEL",
 "Routeno": "1111AA",
 "TripSeq": "1",
 "PlanDate": "Nov 17, 2023 4:02:00PM",
 "TripStatus": "1"
 },
 {
 "Order": "12222222222",
 "IsellNo": "233333333",
 "WorkOrderNo": "34444444",
 "Customer": "Iron Man",
 "Mobile Phone": "+61444444444",
 "Address": "1 Road Highway",
 "Zip": "4444",
 "City": "Citylah",
 "DelDate": "Nov 17, 2023 5:00:00 PM",
 "OrdStatus": "1",
 "PlannedOL": "1",
 "PickedOL": "1",
 "Trip Note": "PARCEL",
 "Routeno": "1111AA",
 "TripSeq": "1",
 "PlanDate": "Nov 17, 2023 4:02:00PM",
 "TripStatus": "1"
 }
]

Categories:

Building flows