Answered

combining multiple form responses into one line in excel

(0) Share

Report

Posted on by lmaeser

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?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

lmaeser 11 on at

Like (1)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No