Hi @Trey-Peirce ，
Firstly, I'm afraid that it's not supported to change a form's color based on data in model-driven app.
Its visual effect is generated by system automatically.
Secondly, by combining conditions and actions, you can do any of the following with business rules:
Set field values
Clear field values
Set field requirement levels
Show or hide fields
Enable or disable fields
Validate data and show error messages
Create business recommendations based on business intelligence.
Adding multiple rules is ok, you could combining conditions and actions in the whatever way you like.
Here's a doc about how to create rules for your reference:
What's more, if you want to customize a form's visual effect, I suggest you embe canvas apps in model driven app.
Here' s a doc about it for your reference:
Thanks for the response!
I don't think we are talking about the same thing though. I'm referring to 'Views' not 'Forms'. I want to add conditional formatting to my tables, much like Excel allows me to do. Check out my example below.
Is this even possible? This seems like such a simple feature, but maybe I am missing something. I would really appreciate some help! I am new to this.
Hi @Trey-Peirce ,
Do you want to customize text color in model-driven app view?
I'm afraid it's not supported to make this currently.
In model-driven app, app's visual effect is limitted. Most of the app's visual effect is genegrated by system and is not supported to customize.
You could edit a view to filter data and sort data.
Please note that:
A view defines:
Not include the text's color.
However, you could display custom icons depending on the value, which I think is similar to the function that you want.
Here's a doc about it for your reference:
Thanks for the response.
I was afraid that JS is the only way to accomplish some sort of conditional formatting. Is this definitely the best method to use?
Hi @Trey-Peirce ,
Yes, I'm afraid there's no better way to format based on condition in model-driven app.
I suggest you express your views on PowerApps Ideas Forum. Your precious feedback will be very helpful for our work.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!