query.Expression.Error.. there weren't enough elements in the enumeration...detail [Table]

[OZMckenzie]

Hello,

This issue seems has been asked several times in this forum, but I haven't found any solution workable to my question, so I am posting here: 

I am creating a function by duplicating one query, and modifiy the query steps by advanced editor. The purpose is to apply the same query steps to another worksheet in another Excel workbook.

In the advanced editor, I added "quartername" as the parameter, which is the file name of the Excel workbook. However when I input the name of the workbook and the click "invoke", an error message pops-up as "query. Expression.Error. Snapshot as below. I wonder what caused the error? The details only show [Table] which I don't quite understand.

Both workbooks contain several worksheets, but my target sheets are both called "quality data". And the format of both "quality data" are identical. BTW, the file name of the Excel workbook contains Korean character. 

Please kindly advise any thoughts or comments, thank you so much!

[camargos88]

@OZMckenzie ,

It looks like you are not using the parameter quartername, only the string "quartername" for the SelectRows function.

[OZMckenzie]

Hi @camargos88 ,

Thank you so much for response, may I know how I should fix the function?

Thanks!

[camargos88 · Accepted solution]

Hi @OZMckenzie ,

Try this on #"Filtered Rows2" step:

(each [Name] = quartername)

Instead of string value, use the parameter defined as text,

[OZMckenzie]

Hi @camargos88 ,

It works after I removed the quotation mark, thanks for your great advice!