Answered

Adding multiple rows to an Excel table from single Microsoft Form

(1) Share

Report

Posted on by LJPiro

I have a basic Microsoft Form (as shown) with the fields Date / Time 1 & Fatigue Level 1 / Time 2 & Fatigue Level 2.

I am able to get the data to flow into an Excel spreadsheet to look like this:

Date	Time 1	Fatigue Level 1	Time 2	Fatigue Level 2
01/03/22	0545z	3	1000z	2

But I actually want the data to flow to Excel with the each Time/Fatigue Level pairing being in a new row (WITH the date included each time). So, for example, taking the data from the table above I actually want it to flow to Excel as follows:

Date	Time	Fatigue Level
01/03/22	0545z	3
01/03/22	1000z	2

However, I only want it to create a second row IF there is data in the Time 2/Fatigue Level 2 fields.

Sorry, I am booking myself onto training to get more comfortable with Power Automate, but this is an urgent task I need fixed.

Thanks,

LJ

All responses (2)

Answers (1)

LJPiro on at

Like (0)

Report

Re: Adding multiple rows to an Excel table from single Microsoft Form

Thanks Charlie,

I was definitely having a chemotherapy-brain day! Will avoid Power Automate on those days in the future.

Managed to use your solution and then added in conditions to do more with it.

Thanks so much.

Lorna
Verified answer

v-yujincui-msft on at

Like (1)

Report
Re: Adding multiple rows to an Excel table from single Microsoft Form

Hi @LJPiro ,

I have made a test for your reference.
1. Here is my Form.

2. Here is my excel table.
3. Create a Flow.
formatDateTime(outputs('Get_response_details')?['body/rceaf70616ecb40239cedb6fee2ad844e'],'dd/MM/yy')

Best Regards,
Charlie Choi