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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
LJPiro on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No