Unanswered

Patch Function and Business Rules

(0) Share

Report

Posted on by Pinguito

Hi guys, i have one question about business rules on entities. I need to Patch some data using canvas app OnSelect property that have some required fields, but have a scenario when the user isn't need to populate this fields.

In my entity table I have this fields as required, so when the canvas try to Patch will appears required error message, okay ...

My question is: Can I create business rules to "When a field is set with 'Yes' option, the required field of the field is removed"?

I tried to do some like this but nothing changes in canvas app.

*Im using Defaults entity to Patch the data, if helps in something ...

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@Pinguito the answer is very simple. Business Rules are not supported in Canvas Apps. Recently I had a conversation about this with someone from MS who confirmed it.

Was this reply helpful? Yes No
Pinguito 58 on at

Like (0)

Report

Do you know other way? I didnt want make them optional

Was this reply helpful? Yes No
nickellis74 432 Moderator on at

Like (1)

Report
I can't see a way around making it optional in the data source, then use fx formulas to control the behaviour in the app.

On the screen.onVisible put
Set(_Validated,true)

Do something with the border formatting of the text box like
// Black if validated, red if not If( _Validated, RGBA(0,0,0,1), RGBA(255,0,0,1) )

On the 'submit' button put something like
If( IsBlank(TextBox.Text) && (whatever your other requirement is), Set(_Validated,false); Notify("You have not completed the text box",Warning), Patch(Data Source, Defaults(Data Source), {table content}) )

I have to say though, if it's a Yes/No field which is set to Yes, I don't see the value in making it non-mandatory. The Yes you've entered will meet the requirement. Unless you mean "field a is required unless field b is Yes"?

Nick

Was this reply helpful? Yes No
Pinguito 58 on at

Like (1)

Report

Hi @nickellis74 , thanks for your reply.

In canvas app its okay, I have made all necessary validated to make sure the data. I'm not worry about this.

My curious was about the back-end, if was possible to do something like this.

Thank very much (:

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@Pinguito You can use Calculated and Rollup to do some server side logic. For example, you have a Date of Birth field and an Age field, you can calculate the Age based on the Date of Birth.
The other way to do validations within Canvas App Forms is to use the Valid function.
Also, you can use the Match function to validate the format of certain fields. For example you can check if the user has entered a valid email address etc.,

Hope this helps!

Was this reply helpful? Yes No