Changing color of the circle according to the value of the column in a Collection

(0) Share

Report

Posted on by Kepcla

Hi All!

When I try to evaluate a column condition of a collection to change the color of a circle, it doesn't work ...

Any idea how to refer to the collection?

Thanks in advance

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (3)

Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report
@Kepcla

PowerApps is having trouble understanding which row in the collection you want to check. I believe you want it to look at the first one. Replace DaysFinal.Item1 with the code below in both places.

First(DaysFinal).Item1

---
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
Verified answer

KennethNicasens 275 on at

Like (1)

Report

Hi Kepda,

You're changing the color based on the collection, does this only contains 1 item?

If yes: Power Apps does not know this and will check on the whole table which he can't determine if the value is "vacation".
You can solve this by using First(DayFinal).Item1

If this is not the case, you will have to find a workaround.
Can you provide a little more detail about the app?

Kind Regards,
Kenneth Nicasens

Was this reply helpful? Yes No
Kepcla on at

Like (0)

Report

the "items1" column could be vacations or work:

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

Like (0)

Report

@Kepcla

Yes, that's true. But you cannot simply check to see if Items1 is equal to vacations or work because there are several rows and PowerApps doesn't know which row to check.

Which row do you want to check?

---
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
Kepcla on at

Like (0)

Report

Actualy all (Item1)....maybe ForAll function could work...

Was this reply helpful? Yes No
KennethNicasens 275 on at

Like (0)

Report

Kepla,

Can you give a bit more context of the use of this functionality.

ForAll will loop over each item and will do an action(s) within this loop.

Was this reply helpful? Yes No
Kepcla on at

Like (1)

Report

Thanks to All, "First" function works!

Was this reply helpful? Yes No
Kepcla on at

Like (0)

Report

Sorry clumsiness!!😥
Is not working...
First function just evaluate the 1st record...
I tried LookUp, Filter, ForAll, and not luck...
My brain is hanging upside down😖

Was this reply helpful? Yes No
KennethNicasens 275 on at

Like (0)

Report

Can you give a bit more context of the use of this functionality?

You can create a gallery with each item and color the circle in for each record.
Or do you want to check if there is 1 vacation within the list? Then you can use the following formula: If(Empty(Filter(colName, item1 = "vacation")),RGBA(),RGBA())

Was this reply helpful? Yes No
Kepcla on at

Like (0)

Report

I think it´s little more complicated, it´s a circle in a calendar.
The circle is visible according to the date column in the collection, (DateAdd(_firstDayInView,ThisItem.Value,Days) in DaysFinal.StartDate1) This code works OK..
But I need to paint with a color X the circle according to the item, and that is the problem...

Was this reply helpful? Yes No