Add new lines in an Excel from a Forms with an Excel document answer

[Bigote75]

Hey Everyone! 

I'm just starting with Power automate and I'm trying to add new lines in an Excel Table from a Forms answer, but the Forms answer is also an Excel table with already the same columns than the original one. So I don't know how to extract the Excel from the Forms and read the rows to add them in my original Excel Table...

If anyone here can help me, it would be great! 

Sorry for my English, I hope the explanation is quite clear!

[v-xiaochen-msft · Accepted solution]

Hi @Bigote75 ,

I did a sample for you.

Uploaded file:

Best Regards,

Wearsky

[Bigote75]

Hey @v-xiaochen-msft !

Thanks for your answer, that's exactly what I'm trying to do! 

But I'm still having a problem, I applied what you gave me and it's not working...I think it's because I'm not writing the correct line in the Json Formula.

That'what I wrote: json(outputs('Obtenir_les_détails_de_la_réponse')?['body'])?[0]?['name']

My powerautomate is in French, that's why I wrote Obtenir_les_détails_de_la_réponse for Get response détails... but I don't think that's the problem... Can you help me? 

Thanks again!