Answered

Visible IF statement on gallery (canvas app)

(0) Share

Report

Posted on by ChristoNindyo

Hello experts, I want to ask about how to use IF statement in visible properties. I want hide when it's still waiting for approval and only will be visible when it gets approved.

I try with this, but it didn't work:

If(ThisItem.Status = "Approved", true, false)

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @ChristoNindyo ,
have you used this code in the Visible property of the Status text label?
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ChristoNindyo ,

You can also use Filter function to show items with "Approved" in gallery.

Items of Gallery.

Filter(DataSource,Status="Approved")

Best regards,

Rimmon
ChristoNindyo 99 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, @v-mengmli-msft .
I already had this on item of gallery
Sort( Search( AddColumns('Order Lists (New)',CreateByUser, 'Created By'.DisplayName), TextSearchBox2.Text, CreateByUser, 'Email Address' ), ThisRecord.Created, If( SortAscending2, SortOrder.Ascending, SortOrder.Descending ) )

How should I put the filter in item of gallery ?
Filter('Order Lists (New)',Status="Approved")
ChristoNindyo 99 on at

Like
a
(0)

Report
Copy link

Link copied!
I found how to put it all together, finally.
Filter( Sort( Search( AddColumns('Order Lists (New)',CreateByUser, 'Created By'.DisplayName), TextSearchBox2.Text, CreateByUser, 'Email Address' ), ThisRecord.Created, If( SortAscending2, SortOrder.Ascending, SortOrder.Descending ) ), Status="Approved")

Just like what you said, I used filter function on Items of Gallery. It works !
Thank you so much.
ChristoNindyo 99 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, it didn't work according to what I want