Error when using Custom List attached to a Source Entity and getting data from another Data Entity using Lookup

[Murtuza_Masalawala]

I am using a Custom list connected to a Data Entity table Approver Tree as the Source, but for one of the labels in the Custom List I am doing a Lookup to another Data entity Table using the Key from the Approver Data Entity. But this fails with the error : Unexpected character encountered while parsing value: {. Path ‘filterGroup.queryFilters[0].value’, line 1, position 226.
Appreciate guidance on this.

[Arvind_Kumar1 (Arvind Kumar)]

@Murtuza_Masalawala ,

Can you debug one by one and see if value is coming into your filters?

Thanks,
AK

[Murtuza_Masalawala]

I replaced ApprovalsTree.UserKey with a hardcoded value and it worked.
I also tried setting the ApprovalsTree.UserKey to a label in the custom list and used that in the Lookup, it only shows for one row and fails for the rest.
I re-entered the user key manually in the Users and ApprovalTree Data Entity to ensure there are no special characters to no avail.

This is with a hardcoded user key to display the user name, the ApprovalsTreed Data Entity does not have the User Name but only the User Key.

[Arvind_Kumar1 (Arvind Kumar)]

@Murtuza_Masalawala ,

Can you set the user key into some label or parameter and see if value is coming then only filter it.

Looks like User key is Blank for your case.

Thanks,
AK

[Murtuza_Masalawala]

I did check that, user Keys are all correct and the columns type is Number in Bothe the Entities.