Populate PowerApps Chart with gallery items count and label according to Item Icon colors.

(0) Share

Report

Posted on by NN-21081740-0

492

I have a gallery with items and a circle Icon to indicate the status based on the end date in the SP list.

The chart should reflect the count of three green icons and one yellow-green icon, for example.

Categories:

Building Power Apps

All responses (4)

Answers (3)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NC12 ,

Could you explain what is the logic for different icon colors?

Best Regards,

Wearsky
Verified answer

NN-21081740-0 492 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Here is the logic:
If(DateDiff(ThisItem.'Projected End Date',Today())<=0, Color.Green, If(DateDiff(ThisItem.'Projected End Date',Today())=1,Color.YellowGreen, If(DateDiff(ThisItem.'Projected End Date',Today())=5,Color.Yellow, If(DateDiff(ThisItem.'Projected End Date',Today())=10,Color.Red))))

If the projected project end date is breached by one day, green changes to YellowGreen, after 4 days it becomes yellow and then on the 10th day it's Red.

So, on the chart, I want to see how many greens, yellowgreen and red.

Thanks
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NC12 ,

Please try this in items property of chart control.

[ {Name:"Green",Count:CountRows(Filter(<db>,DateDiff('Projected End Date',Today())<=0))}, {Name:"YellowGreen",Count:CountRows(Filter(<db>,DateDiff('Projected End Date',Today())=1))}, {Name:"Yellow",Count:CountRows(Filter(<db>,DateDiff('Projected End Date',Today())=5))}, {Name:"Red",Count:CountRows(Filter(<db>,DateDiff('Projected End Date',Today())=10))} ]

Best Regards,

Wearsky
NN-21081740-0 492 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Oh my word, it worked!!!!!!

Thank you a million times!!!🤗