Hello,
I hope I can explain this so as to get an answer.
I have a document library called "General", which is a sub folder in my "Documents" folder.
Once a month Service Now dumps an excel file with the month and year appended as shown below.
What I need to do is dynamically find the first part of the URL where my Excel files reside.
I can get the URL by populating a variable with "strLinkToItem" but this includes the file name as well.
The file name changes so I need to get that dynamically as well in order to use Get Worksheets action.
In order to get this to work I had to hardcode the library path and then use a variable that holds the file name in order to use get worksheets action.
"/General/EmailMessages_6_2023" is hard coded and I need that to be dynamic.
The latest folder that was created (Because it is now July) is...
Notice the folder under General has changed.
Please give me some direction if possible.
