Forum Discussion
Solved
Expression.SyntaxError: Token ',' expected
Hell Fabric Community,
I am trying to use List.intersect function to fint common values across tables but everytime I do that, I recicve error Expression.SyntaxError: Token ',' expected
This is my code:
= List.Intersect( { 01_2024_SMBMI[Email Address], 02_2024_SMBMI[Email Address], 07_2023_SMBMI[Email Address], 08_2023_SMBMI[Email Address], 09_2023_SMBMI[Email Address], 10_2023_SMBMI[Email Address], 11_2023_SMBMI[Email Address], 12_2023_SMBMI[Email Address]}, Comparer.OrdinalIgnoreCase)
Can someone assist me if I have extra commas or missing commas in my code? Thank you so much.
You are using "funny" characters that you need to escape.
Instead of
01_2024_SMBMI
you need to specify
#"01_2024_SMBMI"
etc.
