
Creating a flow that will automatically copy and file a powerpoint on sharepoint and place a copy in another folder.
The problem I have when using the "Copy File" function is that the powerpoint has a date ie. 10April23 that changes each week. But the powerpoint is a living document, and each week the team just changes the title to reflect the new week. So when the flow goes to look for the file ie 10April23 XXXX but it has since been changed to 17April23 XXXX it fails.
Is there a way to build a rule in the Copy File function that can ignore the date at the front, as long as the rest is correctly named? The rest of the name is consistent every week and only the date changes.
Thanks in advance!
Hi @AnalystOwen
Looks like you need some sort of configuration date where you can change as it required. So in flow read the configuration date before it access the filter query for the files. You could store this configuration date change in another SharePoint list or in an Excel file. Is that a possibility?
Thanks