I have a excel power query table listing all the files in a folder and i want to have both a column for manual data entry and have it automatically update. I have created the column for manual data entry according to the video down below and that works but now it doesnt update when new files are added to the source folder

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://m.youtube.com/watch%3Fv%3DQRg5PGNmLA0&ved=2ahUKEwiBo-GEmLCGAxVDGBAIHQeDAH4QwqsBegQIDRAG&usg=AOvVaw0ntETiP_yAEw3MXPS2FzJw

I tried updating every different query but doesnt help