Unanswered

MS Forms -> PowerAutomate -> Excel

(0) Share

Report

Posted on by Biren_Pat

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:

General topics

I have the same question (0)

All responses (2)

Answers (0)

efialttes 14,756 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Biren_Pat 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No