Error in Lookup while getting distinct values

Manjari Manokar 1

I am trying to do a look up on a table, preview data in the look up gets me the correct data when table option is chosen but when the query option is chosen and if I try to get the distinct values from the table it throws me an error

Vaibhav Chaudhari 38,721 Reputation points

2020-08-20T08:00:54.957+00:00

Can you share the screenshot of dataset or lookup or both (wherever you mention the table name)
Vaibhav Chaudhari 38,721 Reputation points

2020-08-20T08:03:43.497+00:00

Can you share the screenshot of dataset where you mention the table name. Try to click on Preview to see if it show the data

If it works with query, it should work with table selection as well if the table really exists in that database

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

1 answer

KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2020-08-21T20:20:09.303+00:00
Hi @Manjari Manokar ,

Welcome to Microsoft Q&A and thanks for using this forum.

As Vaibhav called out, if the lookup works when table option is selected, then ideally it should work with query unless if there is something wrong with the query formation. By looking at the error messages it seems that SQL is throwing error saying that object is invalid (please make sure the object name is correct in your query).

Are you using dynamic expression to form your query? If so could you please share the expression?

If you are using query directly without dynamic expression, then please try to copy it as is and execute it in SSMS to make sure the same query is working in SSMS. This is to check if the issue is with query formation.

Let us know how it goes.

Thanks
Please sign in to rate this answer.
KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2020-08-27T20:30:02.7+00:00

Hi ManjariManokar-0465,

Just checking to see if any of the above suggestions were helpful to resolve your issue? If that answers your query, please do consider to click “Accept Answer” and "Up-Vote" as it might be beneficial to other community members reading this thread. And, if you still need assistance do let us know.

Thank you

KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2020-08-28T22:26:38.847+00:00

Hi ManjariManokar-0465,

Just checking to see if your issue was resolved? If you still need assistance do let us know.

Thank you
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error in Lookup while getting distinct values

1 answer

Your answer