Can I put a constraint on a creation ( or modification I guess) of a row based on two fields. So I want to ever only have a singular row which has the same values in these two fields.
In my case one is a lookup field, the other a choice fields. Essentially a customer and a year.
Your are only allowed to create one report for each customer per year.
Business rules seem focused on the entity itself, and not on what exists in the table already.
Solved! Go to Solution.
Hi @ingovals ,
Have you looked at alternate keys for this need? https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-alternate-keys-portal
Hi @ingovals ,
Have you looked at alternate keys for this need? https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-alternate-keys-portal