Hello all,
As stated in the topic above, my general question is "What is the best way to export data from a SharePoint List to Excel?"
First of all, some information about my app and the stored data. We built the app based on our SharePoint list.
When the app is started, a collection (col_Data) is created, this is transferred directly to the sharepoint list (operational data) via a button. Via a flow I create daily empty data sets, so that the entry for the building can be made in the app. However, the Sharepoint list is only a very roughly summarized version of the Excel table. The data from Sharepoint would then have to be transferred via a process into the Excel list/table (but only in certain columns!).
The data from Sharepoint would then have to be entered into the red marked columns of the respective buildings and matching date. This is only a small insight into the very large Excel table.
I hope that someone has a good idea how to implement this or if this can be implemented at all.
