LOOKUPVALUE - "A table of multiple values was supplied where a single value was expected"

[ss89]

Hello Community,

I'm trying to use the LOOKUPVALUE function to lookup values from Input Summary Table in gmsgqmi_sql_lims_ri_sqa_lots query table .

I get the following error:

"A table of multiple values was supplied where a single value was expected"

The "Input Summary" table is linked to a sharepoint list.

I would like to create a new column where each protocol name code has its corresponding ATP value, (ATP is the number of days to release the protocl name code from its date of receipt).

Many thanks in advance for your help!

[JadhavVarsha_13]

Hello @ss89 

I guess the lookup you have used, it should be other way round

 LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

You can also use Related here  

[RemyO]

If that works i would check if the sharepoint list does not contain any duplicate lookup values. The error suggest that there is a duplicate value.

Then I would try a sharepoint list with only 1 value in which can be found by at least 1 record in gmsgqmi_sql_lims_ri_sqa_lots  it and see what happens.

If this works add a few records

If it still works add some more.. and keep going till the end.

[ss89]

Hi,

thanks for your reply.

I exported to an Excel file the list on the sharepoint but there are no duplicate values.

Duplicate values are only on gmsgqmi_sql_lims_ri_sqa_lots

[RemyO]

JadhavVarsha_13 also says something which can be the issue.

Read the lookup documentation. It could be that your lookup is reversed

erm Definition

result_columnName	The name of an existing column that contains the value you want to return. It cannot be an expression.
search_columnName	The name of an existing column. It can be in the same table as result_columnName or in a related table. It cannot be an expression.
search_value	The value to search for in search_columnName.

[JadhavVarsha_13]

Yes, i think that could be the cas because i have faced same issues earlier 

@ss89 let us know if that works