Unanswered

MS Forms Sections to different Rows in Excel with Power Automate

(0) Share

Report

Posted on by cgrass

I am working to create a microsoft form that will allow a group of employees to insert various work fees. I have created different sections to capture them. Section 1 captures fee 1, section 2 captures fee 2, etc. However, what I need is for the sections 2-5 to drop down an start the next row so all fee costs end up in the same column for the same employee. Is this possible with power automate.

Categories:

General topics

I have the same question (1)

All responses (2)

Answers (0)

AlexEncodian 4,409 Moderator on at

Like (0)

Report

@cgrass

You will be using the Excel connector and the "Add a row into a table" action. What you are trying to achieve is possible, you simply build your flow so that a new row is added for each section.

Was this reply helpful? Yes No
cgrass 2 on at

Like (0)

Report

Thank you so much for your response! I think my problem comes with a condition. Each form has the ability to add up to 5 fees that need to be reimbursed. I can get the first one to work perfectly. But I only need to add the second fee if the answer is yes, add another row if the answer is yes for fee three. I can get the first fee on section one to work, but what do I use to create the condition for the second fee?

Was this reply helpful? Yes No