web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add row to spreadsheet...
Power Automate
Answered

Add row to spreadsheet and fill both columns - power automate

(0) ShareShare
ReportReport
Posted on by 26

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?

Categories:
I have the same question (0)
  • Verified answer
    abc1235 Profile Picture
    26 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard