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 / MS Forms -> PowerAutom...
Power Automate
Unanswered

MS Forms -> PowerAutomate -> Excel

(0) ShareShare
ReportReport
Posted on by 2

Team Community

 

I have a scenario where I want to send two different MS Forms to capture candidate information, but I want the results from both Forms to appear in one (same) row in excel. for example the 1st round interview of a candidate and the 2nd round interview results of the same candidate would appear in the same row in the master excel file. The unique identifier in both the forms will be the candidate's email ID.

 

Any help please? 

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Hi!

    "The unique identifier in both the forms will be the candidate's email ID"

    You mean the unique identifier is the candidate's email address?

    If so, you can use 'List rows present in a table' action block, filter its results to obtain the row with candidate's email address.

    You can use either an ODATA expression as filter query input on 'List rows present in a table' or add a 'Filter array' action block assigning as its input 'List rows present in a table' output.

    The tricky point is that both approaches will provide you an array with one element, so you need to read its values in order to update the row. The easiest way to do it is by means of an Apply to Each, as explained here

    https://powerusers.microsoft.com/t5/Connecting-To-Data/Help-using-Flow-to-update-row-in-Excel/td-p/200530

    BTW How many rows do you plan to have in your Excel table?

    Thanx!

  • Biren_Pat Profile Picture
    2 on at

    Hi,

     

    Thanks for the prompt reply. Yes thee unique identifier is the candidate's email address.

     

    The number of rows depends on the number of responses. 

     

     
     

    Excel.JPGForm 1 & 2.JPG

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
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard