In the Files app, click on the “...” button in the top right. Then choose “Connect to Server”.

I use FileExplorer for this and it works great: https://apps.apple.com/us/app/fe-file-explorer-pro/id4994701...

(No affiliation to the author)

I think that should be possible with the files app or something like Transmit