cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vaishalivyas1
Level: Powered On

Re: Validation error on submit/create form in power apps

Hey @Tom_Slosse

 

How do i convert Text Field to Number . In  My case Data Type of hours and minutes is number. when i write them inside patch function is gives me error beacuse of that.

Kgrange
Level: Powered On

Re: Validation error on submit/create form in power apps

I had the same issue when trying to submit a form to my Azure SQL table.  The app was working perfectly until recently and I have found that, in the SQL table I have a unique ID field that is a required field.  I have this as the first card on my form and noticed that its property is now set to true. While I don;t know what it was set to before, I never had any issues submitting the form.  I have now changed it to false and the app started working correctly again.

vaishalivyas1
Level: Powered On

Re: Validation error on submit/create form in power apps

hi @Kgrange

 

Which properties you set to false. I have three fields which are required but I don't want them in form. I am stuck here.

 

 

Highlighted
Kgrange
Level: Powered On

Re: Validation error on submit/create form in power apps

I have included the required fields on the form but set their visible property to false as well as their required property.  This issue is something new so I'm not sure what causes it but changing the required property to false on the form has fixed it.

vaishalivyas1
Level: Powered On

Re: Validation error on submit/create form in power apps

Hi @Kgrange

 

I tried that , but it's not wroking for me.

Super User
Super User

Re: Validation error on submit/create form in power apps

Hey @vaishalivyas1

 

 

Sorry I didn't respond anymore. Was busy working on something else that had my priority.

So I guess you should try and recreate your Dynamics form with Hours and Minutes as text fields.

And then use text fields in your PowerApp as well, to eliminate that you have a conflict with types of fields.

 

Kind regards

 

 

Tom

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Validation error on submit/create form in power apps

Hey @vaishalivyas1

 

 

Well if you use number types, you just need to use the textinputname of your field in the Patch function something like this:

 

Patch(...{Title: Textboxtitle.text, ANumber: textinput1})

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





vaishalivyas1
Level: Powered On

Re: Validation error on submit/create form in power apps

Hey @Tom_Slosse

 

 Ya , I got the solution . There were some fields on my CRM system which were not there on CRM form but those fields were system required. So I made those fields to optional . and accordingly made changes on PowerApps form. and now it's Working.

 

Regards,

Vaishali

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 340 members 5,180 guests
Please welcome our newest community members: