Server sends me 4 emails, 2 per environment per server. Each of these emails has a subject format of env-svrname-SomeText.
I have 6 columns in my spreadsheet namely: email body, date, stage-svr1, stage-svr2, prd-svr1, prd-svr2.
The email body contents are filtered via filter array to display FAIL items and remove null items.
Only the email subject has the env-Svrname. I want to filter the subject of the email per environment per server so that the email body would be under their respective columns without using excel formulas.
Expected output would be in the spreadsheet would be:
Date stage-svr1 stage-svr2 prd-svr1 prd-svr2
10/24/22 SomeText: FAIL SomeText: FAIL SomeText: FAIL, SomeText: FAIL
It should only be 1 row per day because the emails are sent simultaneously.
Related post for the email body contents: https://powerusers.microsoft.com/t5/Using-Flows/Display-Results-of-an-array-power-automate/m-p/1833357#M34259
