Filter via Subject - Power Automate

(0) Share

Report

Posted on by abc1235

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.

All responses (2)

Answers (0)

abc1235 26 on at

Like (0)

Report

Re: Filter via Subject - Power Automate

I wanted the STAGECDC, STAGEPDC etc to display the contents of the email body based on the subject of the email. Is there a way to do that apart from using excel's formula? That's the workaround I'm currently doing to get what I needed.
VictorIvanidze 12,515 on at

Like (0)

Report

Re: Filter via Subject - Power Automate

Could you show your flow?