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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard