Answered

Hide Icon When column chart is visible

(0) Share

Report

Posted on by Nikhil2

522

I would like to hide the + icon when column chart has bars and show when column chart is empty. Similarly, I would like to show edit icon when bars are visible on column chart and hide when column chart is empty.

I tried using this code on Visible property. If(IsBlank(DataCardValue41.Text),true,false) but did not succeed.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Nikhil2

What is the significance of DataCardValue41 ??

Also, what is the Items property of your chart?

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Datacardvalue41 is my form which i am using as New Form when i click on +. I have three fields 41,42,43
Items Property : LastN(Filter(SharePoint List ,Title=variable.Title)). SharePoint List

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Nikhil2

Doesn't really explain the significance of the datacard in relation to the formula you provided.

However, your Visible property for the Icon should be based on the chart, and thus the formula should be:

CountRows(Filter(SharePoint List ,Title=variable.Title) > 0

Not entirely clear why you have a LastN function but are not providing the number of records for the function either.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report
Copy link

Link copied!
@RandyHayes
Significance of Datacard is basically to check if value is empty or not, if empty show + else edit icon.
But if possible to check directly the chart is empty would be useful.

I tried using the above formula the Visible property of icon

CountRows(Filter(SP List,Title=variable.Title) > 0)

Not working, Invalid argument type expecting number, date time and The function countrows has some invalid arguments.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Nikhil2

You typed it incorrectly, and I omitted a closing paren as well...the formula should be:

CountRows(Filter(SharePoint List ,Title=variable.Title)) > 0

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes I tried so it applying in the opposite way like when chart is empty, the icon is hidden and chart is visible the icon is shown.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Nikhil2

Just adjust the formula to meet your logic.

i.e.

CountRows(Filter(SharePoint List ,Title=variable.Title)) = 0

The above will be true when there are no records.

CountRows(Filter(SharePoint List ,Title=variable.Title)) > 0

The above will be true when there are records.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes That worked as expected ! Thank you.

Was this reply helpful? Yes No