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 / combining multiple for...
Power Automate
Answered

combining multiple form responses into one line in excel

(0) ShareShare
ReportReport
Posted on by 11

Perhaps this is more of an excel question - but I am using power automate here. I am using power automate to track completion 3 employee forms. How can I (or what excel formula do I need to use) combine the three separate responses into one line? 

Test.PNG

Categories:
I have the same question (0)
  • wskinnermctc Profile Picture
    6,519 Moderator on at

    I'm guessing you have 3 different flows, 1 for each of the forms?

     

    For each of the flows you should add the steps that will List Rows in a table, filter the table by the person's name (Would be better if you had a unique identifier like employeeID or their O365 account principle name), then a condition to check if the name exists.

    If the name does not exist, then add a new row with the form response. 

    If the name does exist, then get that row ID and update that row with the form response.

     

    Could you add a unique identifier like employeeID or use their O365 account information? 

  • Verified answer
    lmaeser Profile Picture
    11 on at

    Thanks for the response! I am new to power automate but could not get your suggestion to work for me - I must have been missing something. But I found this to be an effective solution: Solved: Update the row if not exist in excel but also crea... - Power Platform Community (microsoft.com)

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 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard