Hi,
I'm currently building a scheduled flow that gets information from a Sharepoint List and copies it to a Sharepoint Library as metadata to relevant items. Despite this being easy enough, the difficult is on how to select and call the correct list. From a seperate implemented process, done by someone else, an Excel macro was set up that every time it runs it creates a new SP list and dumps data from an Excel table in that newly created list. The new list name has a predetermined name (i.e. "doc meta - dd/mm/yyyy - X"), with the X being an incremental count. Because each list contains a full set of information, I need my flow to find the most recently created list that contains a certain string on its name, and then get the contents of that particular list. Would anyone be able to advise a way of doing this?
TIA