web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Add a record to a Data...
Power Apps
Answered

Add a record to a Dataverse table only if a column contains data from another Table's column

(0) ShareShare
ReportReport
Posted on by 47

Hi All!

 

I have a requirement where a Record is added only if data is present in same column of a master table.

So For Example :

Master Table contains a column TeamName with Teams: A, B, C

So only these 3 teams should be allowed to add in another Table's Teams column

If the team Name is different than the one in master table then it should not be allowed or should throw an error while adding a new record

 

 

 

 

I have the same question (0)
  • Verified answer
    Ram Prakash Duraisamy Profile Picture
    5,699 Super User 2026 Season 1 on at

    Hi @omkarb26011 

     

    Create a plugin in Pre-Validation and Validate the same and throw the error.

  • João Santos Profile Picture
    323 on at

    Hi,

    Depending on your model this should be achievable.

    If you have a structure of:

    Master Table  -< Master Table's Teams  >- Teams

                   |               /

                  Child Table

    So, a table for all teams, a new one for Teams that belong to the Master Table.

    With this you can link whatever teams you want on the master table, and from the child table you then have a lookup to the Master Table's Teams (N:1 Relationship)

    Then on the Child Table's form use a Filtered Lookup to only show Master Table Teams that are already linked to the Child Table's Master

    Once you select the Lookup field on the Child Table's form you'll see these options:

    joaodsantos_0-1664889019140.png

     

    You should be able to select the Master Table lookup. This will ensure you only see teams from the Master.

     

    hope this helps and that I didn't make it too confusing

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @omkarb26011, How do your users interact with your Dataverse? Model-Driven App or Canvas App?

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • omkarb26011 Profile Picture
    47 on at

    Hi @AhmedSalih.

     

    Thanks for the response.

    I am using a canvas app to interact with Dataverse.

    I need this validation in backend- Dataverse side

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @omkarb26011, you said: So only these 3 teams should be allowed to add in another Table's Teams column >> You mean that those three teams can create new Table's Column ??

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • omkarb26011 Profile Picture
    47 on at

    No @AhmedSalih 

    For example I have a teams master table which will have team data -> Team Name.

    So number of Teams is not fixed it will vary and increase as per the requirement.

    Now I have another table say PersonalData where I am entering the name of the person with his team.

    What I want is that Dataverse should not allow/ save data if I enter any other team name apart from the one available in team's table

     

  • omkarb26011 Profile Picture
    47 on at

    HI @rampprakash can you please provide me some links or previously solved use cases regarding the same

  • Ram Prakash Duraisamy Profile Picture
    5,699 Super User 2026 Season 1 on at

    Hi @omkarb26011 

     

    Please find my attached Video https://www.youtube.com/watch?v=BNpqbt8NDhw

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Follow me on Twitter : @rampprakashd
    Blog : https://microsoftcrmtechie.blogspot.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard