Forum Discussion

OZMckenzie's avatar
OZMckenzie
Helper I
6 years ago
Solved

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

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 on...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi OZMckenzie ,

     

    Try this on #"Filtered Rows2" step:

    (each [Name] = quartername)

     

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

OZMckenzie's avatar
OZMckenzie
Helper I
6 years ago

Hi camargos88 ,

 

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

Thanks!

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi OZMckenzie ,

 

Try this on #"Filtered Rows2" step:

(each [Name] = quartername)

 

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

  • OZMckenzie's avatar
    OZMckenzie
    Helper I
    6 years ago

    Hi camargos88 ,

     

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