validation inside a form

(0) Share

Report

Posted on by DariuszSzwabo

Hi,

When validating your forms, documented approach states to you use

Validate( DataSource, Column, DataCardValue_123)

Does the data source object is stored locally inside my app instance - or does Validate calls the source (datasource) to validate with?

My question is about performance optimization during validations, I would like to avoid multiple calls due to multiple validations. The way Validate arguments are written suggest to me it might be calling for pattern to the source - I would like to avoid that especially with forms with dozens of fields to be validated.

Hypothetically, would some kind of alternative approach be possible e.g Validate(formBeingUsed, ThisItem.FormAttribute, DataCardValue_123)

Kind regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

vaubeee 533 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DariuszSzwabo ! You're right: The validation calls the datasource. You could use local validation to prevent database performance issues. I recommend this article by Matthew Devaney Data validation for power apps forms
Super insightful on this topic. Maybe Debouncing or triggering validation with OnChange could also work for you.

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
DariuszSzwabo 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi VauBee,

I have scanned through this article, it suggests 'Data Validation With Logical Expressions' which some people could call 'ifology '. I was hoping to find easier way to support validation of higher number of input attributes than writing if statement for each of them.

Using Validate seems to be easier solution form this perspective as the function even returns restriction you created in e.g Dataverse column,

I would like to stay with Validate, but the question is how to avoid bounding and reuse single object I already fetched when opening a new form,

Was this reply helpful? Yes No