Copy List to Excel

[PeterKuehlian]

Hi 

I am currently trying to copy a log list from SharePoint to an Excel sheet. 

Is there any flow available that grabs all lines of my SharePoint list and copies it to my defined Excel sheet (on OneDrive for Business)

Greetings

Peter

[Brad_Groux]

This is a fairly simply Flow, and would look something like this: However, you should be aware of the severe limitations of the Excel connectors, including the file lockout times, and 100 API Calls per 60 seconds. So you may need to build in delays within your Flow.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[PeterKuehlian]

Hi

Thank you for your response. 

I tried to rebuild the flow. 

I am facing problems with creating my table. Any idea why this does not work?

Greetings

[v-yamao-msft]

Hi @PeterKuehlian ,

Thanks for the images.

It is a known issue for Microsoft Flow.

Currently, dynamic contents in File and Table are not supported in Excel online connector.

Please vote the similar request at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Dynamic-content-in-File-amp-Table-inputs-Excel-Busine...

Best regards,

Mabel