Forum Discussion

OZMckenzie's avatar
OZMckenzie
Icon for Helper I rankHelper 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,

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

OZMckenzie ,

 

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

OZMckenzie's avatar
OZMckenzie
Icon for Helper I rankHelper 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper I rankHelper I
      6 years ago

      Hi camargos88 ,

       

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