Announcements
Here is what I have
Here is what I want to do. When the button is clicked I'd like to check to see if the value is already in the datasource. Best practice would probably be to make sure that it catches matches for upper and lower case variants. Doable?
What is your data source?
Ideally, you'll check before submit but there are ways to validate/prevent at the source (depending on what you're using). Dataverse supports the concept of alternate keys (https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/define-alternate-keys-reference-records) which can prevent duplicates at the DB-level.
Alternatively, you'll want to do a LookUp and confirm the value does not yet exist, BEFORE you attempt to create it. Here is an example from a quick search: https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
My data source is whatever the default data source is when you add data. I simply click the 'Create new table" option
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 547
WarrenBelz 444 Most Valuable Professional
Valantis 322
