Matthew Perren @matnav.co.uk · Jun 18

That’s exactly it. I’ve got a wee button in excel that lets the user browse for the file. The cell it returns to is a named range “Path” That is then stored in PQ in a single value list called Path but Csv.Document(File.Contents(Path)) returns this error

0 likes 1 replies

?

Replies

Matthew Perren · Jun 18

Interestingly it’ll allow me to enter the path into a parameter and will take the contents of the parameter as a data source. But only if it’s entered directly into the parameter by the user. Not if the parameter is populated from a list query.