Forum Discussion

Boveitj's avatar
Boveitj
Frequent Visitor
9 years ago
Solved

No Relation Between Table

Hey Guys,   Simple Question for you, I have two tables one for Badge IDs and Another for Persons Name. I need to know how to make it when there is no relation that it will show up as "Invalid Badge...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Boveitj,

     

    Assume there is a relationship between Table 1 and Table 2 based on IDs, then you can create a Calculated column like below:

     

    Column1= IF(IsBlank(Related(Table 2[Names])),"Invalid Badge ID",Related(Table 2[Names]))

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Boveitj,

 

Assume there is a relationship between Table 1 and Table 2 based on IDs, then you can create a Calculated column like below:

 

Column1= IF(IsBlank(Related(Table 2[Names])),"Invalid Badge ID",Related(Table 2[Names]))

 

Best Regards,
Qiuyun Yu