Is it possible to set the 'Fill' property of a component with a value from SQL Server table?

We would like the 'Fill' property of a component in PowerApp to be set based on a hex color value stored in a SQL Server table. For example, we have a simple config table in SQL server and the value is different between DEV, QA and PROD SQL servers. So, when we build an App and connect to SQL Server on DEV, then the hex value of the color is X, and when we promote the App from DEV to QA, the hex value of the color would be different without us needing to change it manually. The same way, when we promote the App to PROD environment, the hex value of the color would be different.

Is it possible to set the 'Fill' property of a component based on a value stored in SQL server table?

2 comments