Power Automate：将字符串转为键值对数组以生成HTML邮件表格

我需要把包含Key:Value格式的字符串转换成对象数组，原始字符串格式如下：

Date:2024-10-02 time,Time:13:13:45,Desc:SSL VPN login fail,IPAddress:95.164.32.58,User:swf group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in|Date:Date:2024-10-02 time,Time:13:13:31,Desc:SSL VPN login fail,IPAddress:79.110.62.9,User:Brenton group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in|Date:Date:2024-10-02 time,Time:13:11:45,Desc:SSL VPN login fail,IPAddress:45.125.66.55,User:Raquel group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in

每个数据块包含固定7组键值对（Date、Time、Desc、IPAddress、User、Group、Msg），用|分隔。

按|分割后得到如下数组：

"Date:2024-10-02 time,Time:13:13:45,Desc:SSL VPN login fail,IPAddress:95.164.32.58,User:swf group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in",
  ",Date:2024-10-02 time,Time:13:13:31,Desc:SSL VPN login fail,IPAddress:79.110.62.9,User:Brenton group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in",
  ",Date:2024-10-02 time,Time:13:11:45,Desc:SSL VPN login fail,IPAddress:45.125.66.55,User:Raquel group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in",
  ",Date:2024-10-02 time,Time:13:11:21,Desc:SSL VPN login fail,IPAddress:79.110.62.8,User:Oliver group,Group:VPN-USERS-Epicor,Msg:SSL user failed to logged in",

但把这个数组放入循环后，流程一直无输出。试过把所有,替换成|再分割，结果是每个键值对单独成元素的长数组，不符合需求。

我的核心需求是：从Outlook邮件中提取这类数据，筛选出上述7个字段后生成表格并通过邮件发送。邮件中会有10-100行数据，需要把每行的7组键值对转换成对象数组，最终用Create HTML table操作生成邮件表格。

期望得到的格式示例（3行数据）：

[
  {
    "Date": "2024-10-02",
    "Time": "13:13:45",
    "Desc": "SSL VPN login fail",
    "IPAddress": "95.164.32.58",
    "User": "swf",
    "Group": "VPN-USERS-Epicor",
    "Msg": "SSL user failed to logged in"
  },
  {
    "Date": "2024-10-02",
    "Time": "13:13:31",
    "Desc": "SSL VPN login fail",
    "IPAddress": "79.110.62.9",
    "User": "Brenton",
    "Group": "VPN-USERS-Epicor",
    "Msg": "SSL user failed to logged in"
  },
  {   
    "Date": "2024-10-02",
    "Time": "13:11:45",
    "Desc": "SSL VPN login fail",
    "IPAddress": "45.125.66.55",
    "User": "Raquel",
    "Group": "VPN-USERS-Epicor",
    "Msg": "SSL user failed to logged in"
  }
]

内容的提问来源于stack exchange，提问作者Mike