Hello,
I am trying to automate an output excel file of results from a software system (it monitors 30k radios and creates output files of user errors) then, create a table of those within the excel file so that it can be utilised by power automate.
Found several topics on YT to create the flow, but it doesn't work (flow attached).
Q's I have;-
1) Does the excel file have to contain the table already before adding it to sharepoint?
2) On the create table conn, it doesn't allow me to select the root directory other than Resource Library, when i put it in manually it errors with 'Drive' failure.
Can anyone suggest where i am going wrong or a better way for this to function? Thank you in advance. Simon