Power Automate adding items to shared team list fr...

TammyHomet · ‎02-13-2023

Hello,

I am able to converted body to text, however I can't figure out how to
retrieve the info and add items to teams list. I am not sure if I should convert to text or not. Any help would be appreciated. I am including detailed info and excluded personal information.

The information in the "bodyPreview" area, trying to extract items for teams list, items needed are:
From:
To:
Date of Loss:
Claim Number:
Insured Name:
Type of Loss:
Loss Description:
Notification Sent:

{
"statusCode": 200,
"headers": {
"Pragma": "no-cache",
"Transfer-Encoding": "chunked",
"Vary": "Accept-Encoding",
"Cache-Control": "no-store, no-cache",
"Set-Cookie":
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Mon, 13 Feb 2023 09:07:59 GMT",
"Content-Type": "application/json; charset=utf-8",
"Expires": "-1",
"Content-Length": "5430"
},
"body": {
"value": [
{

"receivedDateTime": "2023-01-03T16:42:32+00:00",
"hasAttachments": false,
"internetMessageId": "<E@xaw1pwcoll02>",
"subject": "Contact T. THOMAS @ H(717) 698-1111 (15) - Rainbow International of Martinsburg (Normal assignment)",
"bodyPreview": "From: Allstate - Rainbow\r\nTo: Rainbow International of Martinsburg\r\n\r\nAssignment Profile:\r\nType: Normal\r\nDate of Loss: 12/30/2022\r\nClaim Number: 0698055225\r\nInsured Name: THOMAS THOMAS\r\nEvening Phone: (717) 687-1111\r\nEmail Address: ",
"importance": "normal",
"conversationId": "SF-SDFSDF=",
"isRead": true,
"isHtml": true,
"body": "<html><head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"></head><body style=\"font-size:10.0pt; font-family:Arial,sans-serif\"><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" style=\"font-size:10.0pt; font-family:Arial,sans-serif\"><tbody><tr><td><b>From: </b></td><td>Allstate - Rainbow</td></tr><tr><td><b>To: </b></td><td>Rainbow International of Martinsburg</td></tr></tbody></table><br><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" style=\"font-size:10.0pt; font-family:Arial,sans-serif\"><tbody><tr><th colspan=\"2\" style=\"text-align:left\">Assignment Profile:</th></tr><tr><td>Type: </td><td>Normal</td></tr><tr><td>Date of Loss: </td><td>12/30/2022</td></tr><tr><td>Claim Number: </td><td>0698055225</td></tr><tr><td>Insured Name: </td><td>T. THOMAS</td></tr><tr><td>Evening Phone: </td><td>(717) ***-****</td></tr><tr><td>Email Address:</td><td>T@GMAIL.COM</td></tr><tr><td>Type of Loss: </td><td>WATER</td></tr><tr><td>XA ID: </td><td>0573ZQ6</td></tr><tr><td>Location of Property: </td><td>12910 XXXXXXXXXXXX, USA</td></tr> <a href=\"https://maps.google.com/maps?q=12910+XXXXXXXX%2C+US\" style=\"font-size:7.0pt; font-family:Verdana\">Google Maps</a><a>  </a><a href=\"http://www.mapquest.com/maps/map.adp?&address=12910+XXXXXXX&country=US&zoom=7\" style=\"font-size:7.0pt; font-family:Verdana\">MapQuest</a><a> </a><tr><td></td><td>8º N, 77.694412º W</td></tr><tr><td></td><td>39º 48' N, 7º 2' W</td></tr></tbody></table><br><b>Instructions:</b><br><pre style=\"font-size:10.0pt; font-family:Arial,sans-serif\">RoofTypeCd: 2\r\nLoss Description: Begingi December 30th the drains started backing up. The shower stall and the toliet abd the toliet in the guest bedroom on the same floor\r\nLocation Description: \r\nPolicy Line Code: 078\r\nPolicy Type Description: 15\r\nLienholder Name: \r\nCompanion Claims - \r\nPrior Loss Claim Number:000217r\nEP-Extended Protection $10000/ $0\r\nFF-Fire Department Service Charge $500/ $0\r\nGG-Loss Assessments $50000/ $0\r\nMM-Money $200/ $0\r\nMN-Manuscripts $1000/ $0\r\nRT-Theft of Rugs $2500/ $10000\r\nSS-Securities $1000/ $0\r\nSB-Sewer Back Up $10000/ $500\r\nTD-Trading Cards $250/ $1000\r\nTR-Trailer - Non Boat $1000/ $0\r\nVP-Motorized Land Vehicle Parts, Equipment or Accessories $1000/ $0\r\nWT-Watercraft $1000/ $0\r\nYY-Guest Medical $1000/ $0\r\nY9-Guest Medical - Mold $0/ $0</pre><br><br><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" style=\"font-size:10.0pt; font-family:Arial,sans-serif\"><tbody><tr><th colspan=\"2\" style=\"text-align:left\">Dates:</th></tr><tr><td>Assignment Received by XactAnalysis: </td><td>01/03/2023 04:42PM GMT</td></tr><tr><td>Notification Sent: </td><td>01/03/2023 09:42AM MT</td></tr></tbody></table><br><a href=\"https://xactanalysis.com/apps/xnportal/welcome.jsp?detail_mfn=0573ZQ6&detail_tab=d_assignment\" style=\"font-size:9.0pt; font-family:Verdana\">View detailed information for this assignment in XactAnalysis.</a><a> </a></body></html>",
"from": "XactAnalysis.support@xactware.com",
"toRecipients": "s@gmail.com",
"attachments": []
}
]
}
}

Converted body to text:

From: Allstate - RainbowTo: Rainbow International of Martinsburg

Assignment Profile:Type: NormalDate of Loss: 12/30/2022Claim
Number: 0698055225Insured Name: T. THOMASEvening Phone: (717) ***-****Email
Address:3@GMAIL.COMType of Loss: WATERXA ID:

Instructions:

RoofTypeCd: 2
Loss Description: Begingi December 30th the drains started backing up. The shower stall and the toliet abd the toliet in the guest bedroom on the same floor
Location Description:

Power Automate adding items to shared team list from email

Helpful resources

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

Updates to Transitions in the Power Platform Communities