I am trying to update excel tables, I have seen so many people asking similar questions but rarely is the answer an easy one. Everyone usually just asks if the excel has tables and that is it. I understand that the excel file needs a table, which mine do.
My situation is, I have a database excel file let's name it 1.xlsx this has a one table Table 1.
Each month a new set of data points is sent to us in an excel file 2.xlsx which has one table in it Table 2, the headers are the same as those present in Table 1.
I would like to append the contents of Table 2 to the end of Table 1.
For the sake of this being an example I am happy to test this with the SharePoint trigger - For a selected file. I am having trouble with which flow to use. I can manage to Get Tables, but get kind of confused on the right actions to take. Any help would be much appreciated.
