How to create an autofile that ignores a DATE in the title

(0) Share

Report

Posted on by AnalystOwen

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!

I have the same question (0)

All responses (1)

Answers (0)

abm abm 32,594 Most Valuable Professional on at

Like (0)

Report

Re: How to create an autofile that ignores a DATE in the title

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

Was this reply helpful? Yes No