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?
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)
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?
#1
WarrenBelz
146,708
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,030
Most Valuable Professional
Share
Report
All responses (
Answers (
