Field Validation between 2 different Table

KevinMorneault — Wed, 31 Aug 2022 01:53:54 GMT

I am trying to find a way to validate some data within 2 Table. Relationship setup are Many to Many Both .

The purpose of this is to validate most of the data between 2 table.

1. First I want to validate Serial from both Table.

a) Table 1 SCCM

b) Table 2 Asset Management

I wrote a query which does the validation and provide an outpout of Found or NotFound

The query use is something like this

IF(LookupValue('AssetManagement'[SerialNumber], 'AssetManagement'[SerialNumber],'SCCM[SerialNumber'='SCCM[SerialNumber],"Found","NotFound")

Output result works by providing which one are Found and NotFound.

The issue is I created a detailed view (Visual) by including SCCM Serial, SCCM Serial Validation, this works fine, but if i

add a colum from AssetManagement to this visual, Exmaple Organisation, OrganisationValidation, it works with the Found

but does not work with NotFound, it just remain blank. If I remove colum from Asset Management it works.

Is there a way to make this work, and it woud say NotFound for either serial or Organisation if it's not found.

Re: Field Validation between 2 different Table

KevinMorneault — Wed, 31 Aug 2022 02:38:07 GMT

I found the issue and it is now working. Basically in the Colum under visualization, needed to select 'Show items with no data'