@unclemonty
It seems like you’ve already found a solution, but I wanted to chime in and say that it should, theoretically, be possible to map the same value to both a footage and text layer simultaneously. In this case, the footage layer should be swapped out, and the text layer should be replaced with the filename present in the cell.
As you noted, you’d need to use an expression to strip out any subfolder information or file extensions, but from a theoretical standpoint, it should work.
If you have any other questions or run into any problems, let us know, and we’ll do whatever we can to get you up and running.
Thanks!