PowerApps AddColumns doesn't show result - Error [object Object]

[Wilder1626]

Hi

I have a Data Table where i want to pull data from 2 tables.

Table One: SHPG_LOC_T

Table Two: ADDR_T

The column to map from both tables are named the same: ADDR_ID

In the Items field of the Data Table, I've entered below code:

AddColumns('[QA].[SHPG_LOC_T]', 
"PST_CD", 
LookUp('[QA].[ADDR_T]',ADDR_ID = '[QA].[SHPG_LOC_T]'[@ADDR_ID] ))

I was assuming that it would give me the Postal code of the ADDR_ID, but instead, I'm getting [object Object].

Would you know what I'm doing wrong with this pretty straight forward code?

I have this error on the PST_CD column:

"This Formula uses scope, which is not presently supported for evaluation"

Please let me know if you require more info. 

Thank's for your help.

[Wilder1626 · Accepted solution]

It think i found it. Still doing some tests

AddColumns('[QA].[SHPG_LOC_T]', 
"Address", 
LookUp('[QA].[ADDR_T]',ADDR_ID = '[QA].[SHPG_LOC_T]'[@ADDR_ID] ))

And on the PSTL_CD column, i now have: ThisItem.'Address'.PSTL_CD

[alrez]

Hi,

Thanks for your follow up post! I am glad that you were able to get this resolved. Hopefully this will prove useful for future communities members.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.