Expression.SyntaxError: Token ')' expected.

[AnaIsa]

Hi, Could you help me to know why I have this kind of error and how can be solved?

Expression.SyntaxError: Token ')' expected.

Table.TransformColumns( #"Filtered Rows4",("AttachmentContent",each Excel.Workbook(_ true)))

thankyou

[AnaIsa]

Thank you very much for your help, I was abble 😀

[lbendlin]

Second parameter needs to be a list, identified by {  and not (

Table.TransformColumns - PowerQuery M | Microsoft Learn

[AnaIsa]

I tried as well, but it does not work:

[lbendlin]

Remove the "true" part.

What are you trying to accomplish?

[AnaIsa]

I want to connect PBI directly from outlook, that email contains two files one is excel file and the other one is PDF file.

In the next image,in the extension field,  I have filtered by .xlsx, in AttachmentContent field is where I want to put this formula: Table.TransformColumns( #"Filtered Rows4",{"AttachmentContent",each Excel.Workbook(_ true)}) in order to see table instead of Binary.

I need to mention that the file I want to connect contains four tabs, I only need the yellow tab:

Is there another option to do this?

Thank you

[lbendlin · Accepted solution]

If you only need that tab then you need to specify that. 

I would recommend you click the Binary link for the first attachment and then examine the code that creates.  Then replace the new steps by the appropriate sequence.