Unanswered

Validation error on submit/create form in power apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am creating Power Apps from that user can fill the record and record should get saved in dynamics 365.

Problem: Whenever i submit the form i get a error stating "Field is Required" or "An entry is required or has an invalid value" and form gets reloaded, whereas i have filled data in all the fields.

Screenshots:

Error 1: date is addedError 2: after submit form . Form get loaded and shows error.

Categories:

Building Power Apps

All responses (17)

Answers (0)

Sort by

Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @VaishaliVyas

Why do you need to fill in the time twice?
I guess it conflicts with eachother, I would try and remove the textboxes for Hours and Minutes.
As you can fill in the time already in the dates.

Hope this helps
Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Tom_Slosse

I Tried that. But It's not working.
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @VaishaliVyas

Does your field in Dynamics accept time?
Also how do you save all your data back to Dynamics 365?
So how does the code under the submit button looks like

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tom_Slosse

In CRM

and on submit . code: SubmitForm(EditForm1)
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @VaishaliVyas

Well looks like CRM isnt the problem.
I guess it is the submit that doenst do the job.
I would suggest that you take a copy of your current app and try the following on the submit button:

Patch(<datasource>,Defaults(<datasource>), {Title="", <Field>: <NameOfYourControl>.<TypeOfField>,..})
So in your case it could be something like this:
Patch(<datasource>,Defaults(<datasource>), {Title="", StartDate: StartDate.SelectedDate, EndDate: EndDate.SelectedDate, Hours: HoursTextbox.Text, Minutes: MinutesTextbox.Text})

Hope this helps
Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Tom_Slosse

I am trying that but its giving me error.

This is my form in power apps:
where Project, Project Task , Billing code are lookup fields , Start and End Date are Date and Time field, Hours and Minutes are Number filed,comments is text field

I have noticed one thing when i open an previosuly created record from Browse screen and edit that record then i can see that changes in my CRM system. But when i try to create a new record it gives me error.
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @VaishaliVyas

Now you get an error because Hours and Minutes are number fields.
Are they number fields in Dynamics?
Otherwise I suggest you change them to text fields

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hey @Tom_Slosse

Hours and Minutes are Whole number in CRM. Now i was trying to submit form it shows some fields are ewquired.(Project case, Billing Type, Status) fileds are required. values of this fields are automatically created in crm after user save the form.
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @VaishaliVyas

I'm not an Dynamics expert so sorry on my behalf but could you try and save everything without any required fields.
If that works then we are sure the form really submits to Dynamics.

Kind regards

Tom
vaishali_37 84 on at

Like
a
(0)

Report
Copy link

Link copied!

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.