Announcements
I have a form in which I enter various components with their weight and material number.
Is it possible that powerapp also writes if I have entered a material number twice?
Example: 384-345 8kg324-233 9kg384-345 //This number already exists//
Assuming that you are using SharePoint Online as database, if you have configured the column to allow only unique values, the submit of the form will fail.
If you want to validate the data before submiting the form, add a LookUp looking for that material number. If the result is blank, the material number does not exist in your data origin.
---------------------------------------------------------------------------------------------If this post helps please consider Accept it as the solution to help other members to find it.Have a great day!
hey @Crichan
this is possible yes, but we would need more information on your setup an column names and so on
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 342 Most Valuable Professional
11manish 234
Valantis 187