Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Form in edit and new

Hi, I need that in a form, the default mode, change from edit to new, in case a field of the form is different (example: when the client = C0001, form must create a new record, therefore in insertion, when it is different from C0001 , the form must register in modification of the same record. Would you have any suggestion? Thank you all

Super User III
Super User III

An alternative is to put this on OnSelect of the Submit Button to check if the number entered in the textbox or datacarvalue5 (assumed textbox change it to your actual name) exist. If it exist, it gives error message for the user to change the number otherwise allow:


If(CountRows(Filter(YourDatasource,YourNumberCulumn= DataCardValue5)) > 0,

SubmitForm(YourFormName), Notify("Number Exist! Change it",NotificationType.Error))


If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

Thanks for the tip, but luckily I found the solution.

Hi @gioce 

If you have found a solution, would you please post it so that others can benefit? 

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (37,816)