Power Platform Community Forum Thread Details

Hello,

I'm trying to develop the below workflow in power automate.

Every X minutes i receive an email from a distribution list XXXXXX@XXXXX.COM and the email body is like below.

Every time the first line is about the Date/Time it concerns and following are some information about affected customers per technology.

Period: 2024-07-11T07:30:00.000177 - 2024-07-11T07:45:00.000177

CO/Cabin/PON: 10.112.101.46 atm 1 - accessTech: ADSL - Users: 51 - DisconnectingUsers: 51 - Percentage: 100%

CO/Cabin/PON: 10.112.101.46 atm 2 - accessTech: ADSL - Users: 50 - DisconnectingUsers: 50 - Percentage: 100%

CO/Cabin/PON: 10.112.101.46 atm 3 - accessTech: ADSL - Users: 46 - DisconnectingUsers: 44 - Percentage: 95%

CO/Cabin/PON: 10.112.101.46 atm 4 - accessTech: ADSL - Users: 45 - DisconnectingUsers: 42 - Percentage: 93%

CO/Cabin/PON: 10.112.101.46 atm 5 - accessTech: ADSL - Users: 35 - DisconnectingUsers: 35 - Percentage: 100%

CO/Cabin/PON: 10.112.101.46 atm 7 - accessTech: ADSL - Users: 32 - DisconnectingUsers: 32 - Percentage: 100%

CO/Cabin/PON: KOZAN_KOZANI_D_ALC_27052_KV - accessTech: FTTC - Users: 13 - DisconnectingUsers: 13 - Percentage: 100%

CO/Cabin/PON: LARIS_METAMORFOSI_D_ALC_22559_KV - accessTech: FTTC - Users: 6 - DisconnectingUsers: 5 - Percentage: 83%

Those data i want to extract in a table of a shared excel file.

As you may see i create new line for every blue row, and i use the same period for every row