Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

In a table, change color of the row, when the status is different

I would like the rows of a table to color automatically, without selecting the single rowtaking the color from an sql tables. This is the function I use to pick the color, in the select fill ColorValue(LookUp('[dbo].[USR_TIPI]';DESCRIZIONE=DataTable6.Selected.TIPOVISITA And NEGOZIO=DataTable3.Selected.CODICENEGOZIO ;HEXCOLOR)) Thank's in advance

Super User
Super User

If I understand correctly, you want each row of the gallery to have a different color, without having to be selected first? Use the TemplateFill() property. 

Solution Specialist
Solution Specialist

I am assuming that @Giovanni1 is using a DataTable control. I couldn't find any property that regulates the fill of rows, but I dont have any experience with DataTables.


In a Gallery this will definately be possible.

Super User
Super User

@KvB1 Ah, my apologies, I must have missed that/misread

Yes, but not in a gallery, bat in a table

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,806)