Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Check object in many table whether it is in masterdata table

Hi All,   I have a transaction table called "Activities" and a Master data table called "projects".   Sometimes new projects are added in the activities table and I need to know so I can update t...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    You can add the following column in 'Find new addition' table. 

    Column 2 = IF('Find new addition'[ProjectName] IN VALUES(ProjectList[ProjectName]),TRUE(),FALSE())

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

You can add the following column in 'Find new addition' table. 

Column 2 = IF('Find new addition'[ProjectName] IN VALUES(ProjectList[ProjectName]),TRUE(),FALSE())

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you! It is working as intended