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 Sage
Solution Sage

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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,234)