I am trying to add a new column as a look up column and store it in a local collection. I plan to use the new column as a column for the data table control.
I have noticed that normally without lookup, i.e. just some formatting added like formatting new column to add date format or currency format works. But whenever I use the lookup formula within add columns, the collection does not show any columns within it.
I am using the below expression to create the collection:
ClearCollect(tempCollection,
AddColumns(
'[dbo].[Category]',
"Observers",LookUp('[dbo].[Observers]',LOGIN_ID = OBS_LOGIN_ID,Concatenate(LAST_NAME,", ",FIRST_NAME))))
Hi @Swagato,
Check if there is anything wrong with the Concatenate(LAST_NAME,", ",FIRST_NAME) part. Make sure that only [dbo].[Observers] contain the LAST_NAME and FIRST_NAME column.
Regards,
Mona
Hello,
The Observer table is the master table and only has information on FIRST_NAME and LAST_NAME. Also, this issue is not just with the expression I have mentioned. It has occurred for me for any lookup function on any table I use within the add columns and then creating a local collection out of it.
P.S. I am using an on-premise SQL Server database. Not sure whether it has anything to do with it.
User | Count |
---|---|
137 | |
132 | |
79 | |
75 | |
72 |
User | Count |
---|---|
210 | |
200 | |
69 | |
63 | |
54 |