Answered

combining multiple form responses into one line in excel

Like (0) Share

Report

Posted on 26 Jun 2023 19:09:37 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?

All responses (2)

Answers (1)

Verified answer

lmaeser 11 on 06 Jul 2023 at 20:12:39

Like (1)

Report

Re: combining multiple form responses into one line in excel

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)
wskinnermctc 6,517 Moderator on 26 Jun 2023 at 19:56:41

Like (0)

Report

Re: combining multiple form responses into one line in excel

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?