Source File Name changes weekly and workflow fails to run


I have a workflow, where in my source file in sharepoint and the file name is XYZ_02012023 today and it will be replaced by XYZ_02022023 tomorrow, because of this change in file name my workflow throws error. How to dynamically read the file even the file name changes?

the Excel reader should support wildcard in the configuration window. Choose Files in Folder instead of File

1 Like

You could also experiment with dynamically creating the file name based on today’s date, and passing the created filename to the reader via flow variable.

This example shows how you might do so to write a file, but the concept is not that different to read one:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.