Dynamic Excel Table Range to Convert xlsx into table

(0) Share

Report

Posted on by Community Power Pla...

Here is the scenario.
1. There is an automated process from Service Now to drop an xlsx file in a document library folder.
That file always has a date and time stamp appended to the file name, which makes it very problematic when using an automated process that runs once a month.
2. I need to create a table within the Excel document before I can import the data into a SharePoint list.
Right now I am using the below action and it does work IF I enter the Table Range.

Manually opening this action each day, week, month or whatever isnt efficient.
I need to find the table range dynamically in some way in order to insert a table in the xlsx file.

Is there a solution in importing excel data into a SharePoint list without having the xlsx file being a table?
I need to be able to update a master SharePoint list with data if the record is not present.

All responses (1)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Dynamic Excel Table Range to Convert xlsx into table

Hello,
The only workaround to my issue was using "When a File is Created - Properties Only" trigger.
I was going to try to do the same thing on a timer but wasnt able to.
I found a way to get this to work using the solution provided by Michael Alex here!