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.

 

 

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!





Highlighted
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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,989)