colour row of the table

(0) Share

Report

Posted on by gioce

is it possible to color the rows of a table, when a value changes between one row and another?

Thank's in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report
Hi @gioce ,
You can colour the row of a gallery with the TemplateFill setting. If for example you wanted all values in a field called Status where the value was Complete to be coloured Yellow, you would put n the TemplateFill of the Gallery
If( ThisItem.Status="Compete", Yellow, White )
Is this what you are asking?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

I guess you are referring to a Datatable?
If you are using a Datatable, there are limitations so son cannot do that.

If you are using a Gallery, you can arrange the labels inside the Gallery to look like a Datatable. With that you can use the color.

You may have to give more information on the conditions under which you want the color.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@gioce

Put this code in the TemplateFill property of your gallery. It will work assuming each row has an ID number.

If(Mod(ThisItem.ID,2)=1, White, Blue)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
gioce 90 on at

Like (0)

Report

hi, I tried with this string but in fact the field is colored only when I click on it. Is there a way to see the fields of all the rows directly colored, without clicking on them? Thanks in advance

planning.jpg

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report

@gioce ,
Who are you responding to here? Alternate rows as per @mdevaney 's post will work if the gallery is sorted in ID order and you want every second row coloured (but not for other sorts).
My solution will work if you want items with a specific value shaded.
You have marked @eka24 's as the solution.
Your picture refers to none of these and none require selecting the gallery item.

Was this reply helpful? Yes No
gioce 90 on at

Like (0)

Report

I apologize, but perhaps I have not been clear in the exhibition. I want the individual rows to be colored differently depending on the type of visit they find, taking the color (in hexadecimal) from the sql table

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report
OK @gioce ,
That's sort of what I posted except for the hex bit.
Yo can set Variables with Hex colours
Set( vColor1, ColorValue("#24e34a") )
is a light green - your conditional TemplateFill would be vColor1.
All you need to do is Lookup your table for the colour you need.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

If you have the colors in your SQLTable example ColorColumn, then in the Template fill put:
ColorValue(ThisItem.ColorColumn)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No