Add row to spreadsheet and fill both columns - power automate

(0) Share

Report

Posted on by abc1235

Hello again,

I created a flow for "When an email arrives" and filtered the subject.

The main keyword is "Check" but it has a suffix to identify from which server it was sent from.
Something like: Check-SVR1, Check-SVR2.

What I've tried so far is by using the condition 'Subject' contains 'SVR1'.
I created a Compose named SVR1 and placed it on the "if yes" column
I created another compose named SVR2 and placed it on the "if no" column.
In the spreadsheet, I have SVR1 and SVR2 column. I want the outputs of subject with SVR1 to be placed in SVR1 and subject with SVR2 to be placed in SVR2.
I then added a step to Add a row into excel where SVR1 column = outputs('SVR1') and SVR2 column =outputs('SVR2')
When I send both emails with different subjects at the same time, it does create a new row for each of the output.
Is there a way to update both columns in a spreadsheet when an email arrives at the same time but contains a different subject?

All responses (1)

Answers (1)

Verified answer

abc1235 26 on at

Like (0)

Report

Re: Add row to spreadsheet and fill both columns - power automate

Looks like this is not possible. I just created a new column and used excel filters to get the desired output 🙂