Answered

Different Card Fill Colors reflecting cell color

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello fellow PowerUsers,

I'm new to using PowerApps and I think the potential use for it in my workplace is great. I think it can really streamline some processes. I do not have much coding experience and am learning little by little how this useful little platform works.

For my data, I'm using an excel sheet where I color coded three different columns to represent the status of three different stages of the data cycle.

My question is, is there any way to reflect on the card the color (so the status) of one of those cycle columns?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Yes, that could be done.

We could change the Fill property of the corresponding DataCard when Viewing the record details under Display form control.

With an If () function to check the value of the corresponding field, then define the related color.

For example:

1. Select the DataCard, then configure the fill property with the code below:

If(IsBlank(ThisItem.Business_x0020_Stream),Color.White,Color.LightGreen)

2. Select any other controls added within the DataCard, change the corresponding Fill property from:

RGBA(255, 255, 255, 1)

To

RGBA(255, 255, 255, 0)

Doing the steps above should be able to control the color based on the actual data.

Regards,

Michael

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

Like (0)

Report
Copy link

Link copied!

Hi Michael,

I did end up using a ISBLANK() function, I figured that was the easiest way to check since there's no way to track actual fill color.

It ended up looking very nice but when sorting according to that column, the ones that are in red, essentially blank, don't get included in sorting and get sent to the bottom, which is the opposite of where I want them to be. If I reverse the sorting, it only reverses the ones with data in them, the green ones at the top.

Any suggestions?

Was this reply helpful? Yes No