Power Apps: Manipulate row text/fill colour based on values in SharePoint online item columns

(0) Share

Report

Posted on by GeorgeLong94

Hi,

Does anyone know how to automate the colour of a row based on the value of an item in a DataTable?

Example:

Colour: If(Status = "Published", Green, Black)

ID	Name	Status
1	Katie	Pending
2	Steve	Pending
3	Sarah	Published

The content of the data table is pulled from a SharePoint Online custom list.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Rahber 1,935 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

This is currently not possible on Datatable. My advice would be to use Gallery.

There is a post in Ideas forum to enable this feature on Datatable. You can view it here: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/datatable-control-row-color-Fill/idi-p/382768

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Thanks,
Rahber

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@GeorgeLong94,
Based on the issue that you mentioned, do you want to color the selected row within the DataTable?
There is a property named "SelectedColor" which means the color of the text in the selected row in the Data table control. I think you can achieve this by "SelectedColor" property.
Set the SelectedColor property of the Data Table as below

If(DataTable3.Selected.Status.Value="Published",Green,Black)
Note: 'Status' column in my SP list is a Choice column, so l quote it as the format of "DataTable3.Selected.Column.Value". If yours is a Text column, please modify the formula as below.
If(DataTable3.Selected.Status="Published",Green,Black)

Best Regards,
Qi

Was this reply helpful? Yes No
GeorgeLong94 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for your reply! I understand how this formula can update the colours when a user selects a row.

What I'm after is the colours to update automatically based on the column values pulled through from the SharePoint Online list, similar to how Conditional Formatting works in a normal Excel Spreadsheet.

Do you think this is possible?

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(2)

Report
Copy link

Link copied!

Instaed of Datatable with limitation, Use a Gallery. Arrange the labels to loom like a Table then apply the conditional formatting:
If(ThisItem.Description="Klectrica",Blue,RGBA(0, 0, 0, 0))

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

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
GeorgeLong94 17 on at

Like
a
(0)

Report
Copy link

Link copied!

I've replicated my table using a Gallery rather than a DataTable and it's 10 times better!

Thank you for your help all

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Now how can you filter the gallery by color fill, I am traying and just create circular references.

Help

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24
Is there any possibility to have Horizontal & Vertical scroll bars both in one gallery like Datatable.

Thanks & Regards

Was this reply helpful? Yes No