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

(0) Share

Report

Posted on by omkarb26011

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,580 Super User 2025 Season 2 on at

Like (0)

Report

Hi @omkarb26011

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

Was this reply helpful? Yes No
João Santos 323 on at

Like (0)

Report

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:

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

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

omkarb26011 47 on at

Like (0)

Report

Hi @AhmedSalih.

Thanks for the response.
I am using a canvas app to interact with Dataverse.
I need this validation in backend- Dataverse side

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@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

Was this reply helpful? Yes No

omkarb26011 47 on at

Like (0)

Report

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

Was this reply helpful? Yes No
omkarb26011 47 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,580 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No