I have been scratching my head a bit around this topic. I would please like some help on the following:
I have a folder in Sharepoint where I have multiple Excel files with the following names:
File 1 – A19@B2
File 2 – A19@B3
File 3 – A19@A2
The A19 refers to the financial year. When I am in this specific folder the financial year 'A19' will stay constant, however, the text after the '@' can change as indicated above. It can be B2, B3, A2 etc.
I can import these files one at a time through a parameter.
What I need is a parameter that will pull in all 3 my files if I indicate that I want all files in my folder with a financial year of 'A19'.