Validate Patch update

(0) Share

Report

Posted on by Gargoolgala

270

Hi,

I am wanting to validate that all the required fields are filled in prior to updating a form which is using Patch to update. I can get it working fine if I sumitform as it seems the validation is built-in to the submit form but I cannot use submit form as it resets all my tabbed pages which are based off the same record and is not an option.

I want to Patch the form - Patch('Secure Print Assessments',First(Filter('Secure Print Assessments', ID=CustomerGallery.Selected.ID)),GAForm.Updates)) - this update works fine but how do I validate it first?

I have found Validate( Scores, EditRecord, Gallery.Updates ) but I do not know what the EditRecord would be??? If I use Validate ('Secure Print Assessments', EditRecord, GAForm.Updates) it says the Validate has syntax errors - specifically on EditRecord but I do not know how to reference the current record I am trying to validate. I tried variations of ID=CustomerGallery.Selected.ID instead of EditRecord but no luck.

Also if I was to get past this would I then need to check if the result is blank to go ahead with the patch of will the validate stop any commands further on?

All I want to do is check the datacards are filled in - I have many of them so I do not want to jhave to reference each and everyone of them to check if the field is empty - that would be a nightmare.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Sofie_D 260 on at

Like (1)

Report
Copy link

Link copied!

Try replacing EditRecord with LookUp(Scores, ID=CustomerGallery.Selected.ID)

To make sure the required fields aren't blank, n my PowerApps I usually use the Rules feature and make the submit button disabled unless all required fields aren't empty anymore. Though there may be easier solutions.

Was this reply helpful? Yes No
Gargoolgala 270 on at

Like (0)

Report
Copy link

Link copied!

Sofie, thanks for the input. Using lookup has not given me an error but now I am attempting to work out how to use it

If(IsBlank(Validate('Secure Print Assessments',LookUp('Secure Print Assessments',ID=CustomerGallery.Selected.ID),GAForm.Updates)),UpdateContext({Test:true}),UpdateContext({Test:false}))

My label text is set as If(Test=true,"Blank","Not Valid") - I also always reset Test to false on screen visible.

Everytime it runs I get a return of Blank in my textbox - which to me is saying it always validates - yet I know the form does not have required fields. I am sure there is a way about this but the documentation is non-existent and I am relient on forums like this.

I would love to know what SubmitForm is doing in the background to check the required fields and how it can be done with a Patch command as Submit form seems to work great.

Is there any debugging options in PA? Is there any support? Is PA only designed for simple forms?

Was this reply helpful? Yes No
AlexandraJ 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you finally make it work? I'm having the same issue with my app and I'm really new working with PowerApps.

Was this reply helpful? Yes No
Matthew 9 on at

Like (0)

Report
Copy link

Link copied!

Are there any updats on this?

Was this reply helpful? Yes No
Tom_Slosse 1,430 on at

Like (1)

Report
Copy link

Link copied!

Hey all

I guess the answer here is like @Sofie_D said.

Just use rules to disable your submit button until all fields are filled in.

With the Validate option you can only pass in your datasource and some records, but in this case the validation is not in the datasource itself but on the form so therefore you need to use Rules.

Kind regards

Tom

Was this reply helpful? Yes No